Springboot3整合MyBatisPlus

Springboot3整合MyBatisPlus

1.数据库脚本：

DROPTABLEIFEXISTS`user`;CREATETABLE`user`(idBIGINTNOTNULLCOMMENT'主键ID',nameVARCHAR(30)NULLDEFAULTNULLCOMMENT'姓名',ageINTNULLDEFAULTNULLCOMMENT'年龄',emailVARCHAR(50)NULLDEFAULTNULLCOMMENT'邮箱',PRIMARYKEY(id));

2.对应依赖：

<dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-spring-boot3-starter</artifactId><version>3.5.15</version></dependency>

3.application.yml配置：

server:port:8888spring:datasource:url:jdbc:mysql://localhost:3306/crud?characterEncoding=UTF8&autoReconnect=true&serverTimezone=Asia/Shanghai&allowMultiQueries=trueusername:rootpassword:rootdriver-class-name:com.mysql.cj.jdbc.Drivermybatis-plus:mapper-locations:classpath*:mapper/**/*.xmltype-aliases-package:com.scuvc.mybatisplustest.entityconfiguration:map-underscore-to-camel-case:truelogging:level:com.scuvc.mybatisplustest.mapper:debug

4.在 Spring Boot 启动类中添加@MapperScan注解，扫描 Mapper 文件夹：

@SpringBootApplication@MapperScan("com.scuvc.mybatisplustest.mapper")publicclassMybatisplusTestApplication{publicstaticvoidmain(String[]args){SpringApplication.run(MybatisplusTestApplication.class,args);System.out.println("项目启动了!");}}

5.添加测试类进行测试：

@SpringBootTestclassMybatisplusTestApplicationTests{@Autowired(required=true)privateUserMapperuserMapper;@Testvoidtest01(){Useruser=userMapper.selectById(0);System.out.println(user.getName());}}