【SpringBoot】14、整合MyBatis【狂神篇】

1、导jar包

（1）手工导入

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.2.1</version>
</dependency>

（2）创建工程时勾选依赖

2、配置数据源

与整合JDBC、Druid一样

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mybatis?userSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT
    driver-class-name: com.mysql.cj.jdbc.Driver
    # DruidDataSource
    type: com.alibaba.druid.pool.DruidDataSource

3、测试数据源

4、创建实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Integer id;
    private String name;
    private String ps;
}

导入 lombok 包

5、Mapper接口

@Mapper
@Repository
public interface UserMapper {
    List<User> queryUserList();

    User getUserById(Integer id);

    int addUser(User user);

    int updateUser(User user);

    int deleteUser(Integer id);
}

@Mapper 表示这是一个mapper接口；也可以在入口类中添加 @MapperScan("com.tuwer.mapper")；二者等效

6、Mapper映射

在 resources 目录下创建

mybatis/mapper/UserMapper.xml

<?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.tuwer.mapper.UserMapper">
    <select id="queryUserList" resultType="user">
        select * from mybatis.user;
    </select>

    <select id="getUserById" resultType="user">
        select * from mybatis.user where id = #{id};
    </select>

    <insert id="addUser" parameterType="user">
        insert into mybatis.user(id, name, ps) VALUES (#{id},#{name},#{ps})
    </insert>

    <update id="updateUser" parameterType="user">
        update mybatis.user
        set name=#{name},ps=#{ps}
        where id=#{id};
    </update>

    <delete id="deleteUser" parameterType="int">
        delete from mybatis.user where id=#{id};
    </delete>
</mapper>

• 配置映射文件

  application.yaml 中配置

mybatis:
  # 实体类别名
  type-aliases-package: com.tuwer.pojo
  # 映射文件路径
  mapper-locations: classpath:/mybatis/mapper/*.xml

7、CRUD测试

Controller 中注入 UserMapper

导入 fastjson 包

@RestController
@RequestMapping("/user")
public class UserController {
    @Autowired
    UserMapper userMapper;

    @GetMapping("/getAll")
    public String queryUserList(){
        List<User> userList = userMapper.queryUserList();
        return JSON.toJSONString(userList);
    }

    @GetMapping("/add")
    public String addUser(){
        User user = new User(15, "王五", "888");
        int i = userMapper.addUser(user);
        return JSON.toJSONString(i);
    }

    @GetMapping("/del")
    public String deleteUser(){
        int i = userMapper.deleteUser(15);
        return JSON.toJSONString(i);
    }
}