SpringBoot-13 整合MyBatis框架

官方文档：http://mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/

Maven仓库地址：https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter

1. 导入 MyBatis 所需要的依赖

   
       org.mybatis.spring.boot
       mybatis-spring-boot-starter
       2.2.0
   
   

2. 配置数据库连接信息（不变）

   spring:
     datasource:
       username: root
       password: root
       url: jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8
       driver-class-name: com.mysql.cj.jdbc.Driver
   
   # 整合 mybatis
   mybatis:
     type-aliases-package: com.aze.pojo
     mapper-locations: classpath:mybatis/mapper/*.xml
   

3. 测试数据库是否连接成功

4. 创建实体类，导入 Lombok

   package com.aze.pojo;
   
   import lombok.AllArgsConstructor;
   import lombok.Data;
   import lombok.NoArgsConstructor;
   
   @Data
   @AllArgsConstructor
   @NoArgsConstructor
   public class User {
   
       private Integer id;
       private String name;
       private String pwd;
   
   }
   

5. 创建mapper目录以及对应的 Mapper 接口

   package com.aze.mapper;
   
   import com.aze.pojo.User;
   import org.apache.ibatis.annotations.Mapper;
   import org.springframework.stereotype.Repository;
   
   import java.util.List;
   
   @Mapper // 这个注解表示了这个是一个 mybatis 的 Mapper 类
   @Repository
   public interface UserMapper {
   
       List queryUserList();
   
       User queryUserById(int id);
   
       int addUser(User user);
   
       int updatUser(User user);
   
       int deleteUser(int id);
   
   }
   

6. 对应的Mapper映射文件

   
   
   
   
       
           select * from mybatis.user;
       
   
       
           select * from mybatis.user where id=#{id};
       
   
       
           insert into mybatis.user(id, name, pwd) values (#{id},#{name},#{pwd});
       
   
       
           update mybatis.user set name=#{name},pwd=#{pwd} where id=#{id};
       
   
       
           delete from mybatis.user where id=#{id}
       
   
   
   

7. maven配置资源过滤问题

   
       
           
               org.springframework.boot
               spring-boot-maven-plugin
           
       
       
           
               src/main/java
               
                   **/*.xml
               
               true
           
       
   
   

8. 编写 Controller 进行测试

   package com.aze.controller;
   
   import com.aze.mapper.UserMapper;
   import com.aze.pojo.User;
   import org.springframework.beans.factory.annotation.Autowired;
   import org.springframework.web.bind.annotation.GetMapping;
   import org.springframework.web.bind.annotation.PathVariable;
   import org.springframework.web.bind.annotation.RestController;
   
   import java.util.List;
   
   @RestController
   public class UserController {
   
       @Autowired
       private UserMapper userMapper;
   
       @GetMapping("/queryUserList")
       public List queryUserList(){
           return userMapper.queryUserList();
       }
   
       @GetMapping("/queryUserById/{id}")
       public User queryUserById(@PathVariable("id") Integer id){
           return userMapper.queryUserById(id);
       }
   
       @GetMapping("/addUser")
       public String addUser(){
           User user = new User();
           user.setId(5);
           user.setName("大头");
           user.setPwd("abc123");
           userMapper.addUser(user);
           return "add,ok!";
       }
   
       @GetMapping("/updateUser/{id}")
       public String updatUser(@PathVariable("id")Integer id){
           User user = new User();
           user.setId(id);
           user.setName("大头");
           user.setPwd("111111");
           userMapper.updatUser(user);
           return "update,ok!";
       }
   
       @GetMapping("/deleteUser/{id}")
       public String deleteUser(@PathVariable("id")Integer id){
           userMapper.deleteUser(id);
           return "delete,ok!";
       }
   }
   

9. 启动项目测试

10. 业务都能实现

11. 完成收工！