Spring Boot 整合Mybatis 学习笔记_springboot整合mybatis笔记-CSDN博客

本文链接：https://blog.csdn.net/ssdate/article/details/107458618

新建一个Spring Initializr项目，选择依赖项：

还需要添加依赖，mysql jdbc 连接容器和 Druid 连接池，完整的依赖配置：


        <!-- Spring Boot -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <!-- Spring Boot web-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- MyBatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>
        <!-- MySql驱动 jdbc 链接容器 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <!--druid-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>

在主包下面新建四个分包：controller、mapper、entity、service，resource文件夹下新建mapping文件夹。
新建数据表，(为了测试临时建的表，根据实际情况自行对应)：

CREATE TABLE `uc_users`  (
  `uid` bigint(0) NOT NULL AUTO_INCREMENT,
  `uname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `upass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `real_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `c_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `c_user` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

在entity下新建表对象：

public class User {
    private Integer uid ;
    private String uname = "" ;
    private String upass = "" ;
    private String real_name = "";
    private String c_time = "";
    private String c_user = "";

    //get \ set 、 toString
}

在mapper下新建UserMapper：


@Mapper
public interface UserMapper {
    User findUser(int id);
}

在services新建UserService

@Service
public class UserService {

    @Autowired
    UserMapper userMapper ;

    public User findUser(int id){
        return userMapper.findUser(id);
    }

}

在controller下新建UserController

@RestController
public class UserController  {

    @Autowired
    UserService userService ;

    @RequestMapping("/user/{id}")
    public String findUser(@PathVariable int id){
        return userService.findUser(id).toString();
    }

}

实现配置文件application.properties：

server.port=6000

#mysql datasource
spring.datasource.url      = jdbc:mysql:///mg_server?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
spring.datasource.username = root
spring.datasource.password = root
#连接池
spring.datasource.type     = com.alibaba.druid.pool.DruidDataSource

#mybatis
mybatis.mapper-locations = classpath:mapping/*Mapper.xml
mybatis.type-aliases-package = org.mg.uc.center.mapper

在mapping文件夹下新建UserMapper.xml：
namespace ：对应Mapper具体类。
resultType : 对应具体实体类

<?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.study.s0720.demo.mapper.UserMapper">
    <select id="findUser"   resultType="com.study.s0720.demo.entity.User">
        select * from uc_users where uid = #{uid}
    </select>
</mapper>

启动类添加mapper包扫描

@MapperScan("com.study.s0720.demo.mapper")
@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

最终项目结构是这样的：

尝试启动项目，启动成功，浏览器访问：http://localhost:6000/user/1