springBoot整合mybatis-plus

简介

MyBatis-Plus是一个Mybatis增强版工具，在MyBatis上扩充了其它功能没有改变基本功能，也就是只做封装增强不做改变，为了简化开发提交效率而存在，不需要写XML等sql语句就可实现

官方文档：https://mp.baomidou.com/guide/

工程搭建

1.创建springboot项目

略

2.依赖

<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.76</version>
            <scope>compile</scope>
        </dependency>
        <!--Mybatis-Plus 注意版本-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.1</version>
        </dependency>
        <!--数据库连接驱动 连接配置修改时间-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
    </dependencies>

3.准备数据库和数据

CREATE TABLE `user_test` (
  `id` int DEFAULT NULL,
  `username` varchar(60) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `tel` int DEFAULT NULL,
  `create_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL,
  `version` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


INSERT INTO `rich`.`user_test`(`id`, `username`, `age`, `tel`, `create_time`, `update_time`, `version`) VALUES (1, '张三', 18, 180, NULL, NULL, NULL);
INSERT INTO `rich`.`user_test`(`id`, `username`, `age`, `tel`, `create_time`, `update_time`, `version`) VALUES (2, '李四', 20, 137, NULL, NULL, NULL);

4.yaml配置

spring:
  datasource:
    #    驱动
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/rich?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    username: root
    password: 123456

5.创建实体类

@Data
public class UserTest {

    private int id;

    private String username;

    private int age;

    private int tel;

    private Date create_time;


    private Date update_time;

    private int version;

}

6.创建Mapper接口

直接继承BaseMapper

public interface UserTestMapper extends BaseMapper<UserTest> {

}

7.创建controller

@RestController
@RequestMapping("/userTest")
public class UserTestController {

    @Autowired
    private UserTestMapper userTestMapper;

    @RequestMapping("/list")
    public List<UserTest> queryUserTest(){
        List<UserTest> userTests = userTestMapper.selectList(null);
        return userTests;
    }


}

8.测试

参考文章：

SpringBoot整合MyBatis-Plus各种使用点超级详细_q736317048的博客-CSDN博客_springbootmybatisplus整合