SpringBoot学习 — 整合Mybatis

官方文档

Maven仓库

整合测试

1.导入Mybatis 所需要的依赖

        <!-- 整合Mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.2</version>
        </dependency>

2.配置数据库连接信息

#配置mysql连接
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone = UTC&useSSL=true&useUnicode=true&characterEncoding=utf-8

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

    @Autowired
    DataSource dataSource;

    @Test
    void contextLoads() {
        System.out.println(dataSource.getClass());
    }

4.创建实体类

User 实体类：

public class User {
    private int id;
    private String username;
    private String pwd;
    ...
}

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

/*
 * @Mapper 表示本类是一个Mybatis的Mapper
 */
@Mapper
@Repository
public interface UserMapper {

    //获取所有用户
    List<User> getUser();
    
}

6.对应的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.damin.mapper.UserMapper">

    <select id="getUser" resultType="User">
        select * from user ;
    </select>
</mapper>

7.编写UserController 进行测试

@RestController
public class UserController {
    @Autowired
    UserMapper userMapper;

    @RequestMapping("/getUser")
    public List<User> getUser(){
        return userMapper.getUser();
    }
}

8.启动项目访问 http://localhost:8080/getUser

整合完成！