SpringBoot整合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、创建数据库和插入数据

CREATE TABLE `root` (
  `id` INT(32) NOT NULL AUTO_INCREMENT,
  `userName` VARCHAr(32) NOT NULL,
  `passWord` VARCHAr(50) NOT NULL,
  `realName` VARCHAr(32) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO `root` (`id`,`userName`,`passWord`,`realName`) VALUES (1,'刘备','123','大哥')
INSERT INTO `root` (`id`,`userName`,`passWord`,`realName`) VALUES (2,'关羽','456','二弟')
INSERT INTO `root` (`id`,`userName`,`passWord`,`realName`) VALUES (3,'张飞','789','三弟')

2、新建一个Spring Initializr项目

3、项目建好后的pom.xml文件

    
        
        
            org.springframework.boot
            spring-boot-starter-jdbc
        
        
        
            org.springframework.boot
            spring-boot-starter-web
        
        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.2.1
        


        
            mysql
            mysql-connector-java
            runtime
        
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        
        
    

4、配置数据库连接信息

spring.datasource.username=root
spring.datasource.password=peng
#?serverTimezone=UTC解决时区的报错,8.0以上的要加
spring.datasource.url=jdbc:mysql://localhost:3306/jdbc?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

# 整合mybatis
mybatis.type-aliases-package=com.peng.pojo
mybatis.mapper-locations=classpath:mapper*.xml
        
        true
    

10、创建Service接口和Service实现类

public interface UserService {

    //查询全部用户
    List queryList();

    //根据id查询用户
    User queryUserById(int id);

    //增加一个用户
    int addUser(User user);

    //更新一个用户
    int updateUser(User user);

    //删除一个用户
    int deleteUser(Integer id);
    
}

@Service
public class UserServiceImpl implements UserService {

    //注入mapper包下的userMapper类
    @Autowired
    UserMapper userMapper;

    //查询全部用户
    public List queryList(){
        return userMapper.queryList();
    }

    //根据id查询用户
    public User queryUserById(int id){
        return userMapper.queryUserById(id);
    }

    //增加一个用户
    public int addUser(User user){
        return userMapper.addUser(user);
    }

    //更新一个用户
    public int updateUser(User user){
        return userMapper.updateUser(user);
    }

    //删除一个用户
    public int deleteUser(Integer id){
        return userMapper.deleteUser(id);
    }

}

11、创建Controller类进行测试

@RestController
public class UserController {

    //自动注入service包下的userService类
    @Autowired
    UserServiceImpl userService;

    //查询全部用户
    @GetMapping("/list")
    public List queryList(){
        List userList = userService.queryList();
        for (User user : userList) {
            System.out.println(user);
        }
        return userList;
    }


    //根据id查询用户
    @GetMapping("/one")
    public User queryUserById(){
        User userById = userService.queryUserById(1);
        return userById;
    }

    //增加一个用户
    @GetMapping("/add")
    public String addUser(){
        userService.addUser(new User(4, "马超", "9527", "打工仔"));
        return "插入成功";
    }

    //更新一个用户
    @GetMapping("/update")
    public String updateUser(User user){
        userService.updateUser(new User(4, "赵云", "9571", "守护者"));
        return "更新成功";
    }

    //删除一个用户
    @GetMapping("/delete")
    public String deleteUser(){
        userService.deleteUser(4);
        return "删除成功";
    }

}

12、项目结构