SpringBoot——集成mybatis（2）

step1:编辑pom文件，引入mysql和mybatis相关依赖：

<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <scope>runtime</scope>
</dependency>
<dependency>
   <groupId>org.mybatis.spring.boot</groupId>
   <artifactId>mybatis-spring-boot-starter</artifactId>
   <version>1.3.1</version>
</dependency>

step2:编辑application.yml文件：

server:
  port: 8080
spring:
  application:
    name: firstDemo
  #配置数据源
  datasource:
    url: jdbc:mysql://localhost:3306/demodata?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver
  #指定mybatis文件映射的地址
mybatis:
  mapper-locations: classpath:mapper/*.xml

step3:应用navicat本地创建数据库demodata，账号密码如配置所示。

step4:创建控制层controller，service层，Dao层（mapper交互数据库）和mapper.xml文件（xml文件创建在mapper目录下）。

step5:mapper文件展示：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.mapper.UserMapper">
    <resultMap type="com.example.demo.Domain.User" id="BaseResultMap">
        <result property="id" column="id"/>
        <result property="username" column="username"/>
        <result property="email" column="email"/>
    </resultMap>
    <sql id="mdUserColumns">
    </sql>
    <insert id="insertUser" parameterType="com.example.demo.mapper.UserMapper">
       insert into user (id,username,email) values (#{id,jdbcType=INTEGER},#{username,jdbcType=VARCHAR},#{email,jdbcType=VARCHAR})
    </insert>
</mapper>

controller层类展示：

@Autowired
private UserService userService;
@RequestMapping(value = "/hello",method = RequestMethod.GET)
public String demotest1(@RequestParam(name = "username")String username,@RequestParam(name = "email")String email){
    if(username.isEmpty()){
        return "username不能为空";
    }
    if(username.isEmpty()){
        return "username不能为空";
    }
    User user = new User();
    user.setEmail(email);
    user.setUsername(username);
    int lineNum = userService.addUser(user);
    System.out.println(lineNum);
    return user.getUsername();
}

Service层类展示：

@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;
    public int addUser(User user){
        return userMapper.insertUser(user);
    }
}

Dao层：

@Mapper
public interface UserMapper {
    int insertUser(User user);
}

step6:启动项目，浏览器访问：http://localhost:8080/demo1/hello?email="wuyifan@qq.com"&username="吴亦凡"，可以看到：

 数据库user表：

 至此，整合完毕，可以看到使用SpringBoot整合mybatis非常easy！

SpringBoot——集成mybatis（2）

原文：https://www.cnblogs.com/BJhao-liu/p/13066337.html