【08】SpringBoot4 MyBatisPlus 代码自动生成

SpringBoot4 MyBatisPlus 代码自动生成前言创建工程application.yml 文件pom.xml 文件代码自动生成安装 mybatisplus 插件使用 mybatisplus 插件启动类Application前言SpringBoot 版本4.0.8JDK 版本21.0.11IDEA 开发工具版本2026.2MySQL 数据库版本8.4.11.LTS关于项目MybatisPlus 更多使用可参考官网https://baomidou.com/相关依赖包坐标可参考官网https://mvnrepository.com/artifact/com.mysql/mysql-connector-j建表 SQLcreatetabletb_client(idbigintnotnullprimarykeyauto_incrementcomment自增ID,client_idbigintnotnullcommentID编号,user_novarchar(30)comment账号,user_passwordvarchar(60)comment密码,nick_namevarchar(30)comment昵称,real_namevarchar(30)comment真实姓名,info jsoncomment扩展信息,created_timedatetimedefaultnow()comment创建时间,upated_timedatetimedefaultnow()comment更新时间);INSERTINTOtb_client(client_id,user_no,user_password,nick_name,real_name,info)VALUES(100001,zhangsan,123456,张三,张三,{age: 25, gender: male, city: 上海}),(100002,lisi,123456,李四,李四,{age: 28, gender: male, city: 北京}),(100003,wangwu,123456,王五,王五,{age: 30, gender: male, city: 深圳}),(100004,zhaoliu,123456,赵六,赵六,{age: 26, gender: male, city: 杭州}),(100005,xiaohong,123456,小红,李红,{age: 23, gender: female, city: 成都}),(100006,xiaoming,123456,小明,王明,{age: 27, gender: male, city: 南京}),(100007,alice,123456,Alice,Alice Chen,{age: 29, gender: female, city: 广州}),(100008,bob,123456,Bob,Bob Liu,{age: 32, gender: male, city: 苏州}),(100009,tom,123456,Tom,Tom Zhang,{age: 35, gender: male, city: 武汉}),(100010,jerry,123456,Jerry,Jerry Wang,{age: 24, gender: male, city: 西安});创建工程创建工程的步骤可参考《SpringBoot3 MybatisPlus 工程创建》工程结构如下未创建任何 java 类application.yml 文件spring:application:name:springboot3-mybatisplus-prodatasource:type:com.alibaba.druid.pool.DruidDataSourcedriver-class-name:com.mysql.cj.jdbc.Driverurl:jdbc:mysql://192.168.88.101:3305/testdb?useUnicodetruecharacterEncodingUTF-8serverTimezoneAsia/ShanghaiuseSSLfalseallowPublicKeyRetrievaltrueusername:adminpassword:Qwer1314druid:# 初始化连接数initial-size:5# 最小空闲连接数min-idle:5# 最大连接数max-active:20# 获取连接最大等待时间max-wait:60000# 定期检测空闲连接time-between-eviction-runs-millis:60000# 最小空闲时间min-evictable-idle-time-millis:300000# 连接有效性检测validation-query:SELECT 1test-while-idle:truetest-on-borrow:falsetest-on-return:false# SQL 统计filter:stat:enabled:truelog-slow-sql:trueslow-sql-millis:2000wall:enabled:truemybatis-plus:mapper-locations:classpath*:/mapper/**/*.xmltype-aliases-package:com.junjiu.**.entityconfiguration:map-underscore-to-camel-case:truecache-enabled:falseglobal-config:banner:falsedb-config:id-type:assign_idlogic-delete-field:deletedlogic-delete-value:1logic-not-delete-value:0pom.xml 文件?xml version1.0 encodingUTF-8?projectxmlnshttp://maven.apache.org/POM/4.0.0xmlns:xsihttp://www.w3.org/2001/XMLSchema-instancexsi:schemaLocationhttp://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsdparentgroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-parent/artifactIdversion4.0.8/versionrelativePath//parentmodelVersion4.0.0/modelVersiongroupIdcom.junjiu.mybatisplus.pro/groupIdartifactIdspringboot3-mybatisplus-pro/artifactIdversion1.0-SNAPSHOT/versionpropertiesmaven.compiler.source21/maven.compiler.sourcemaven.compiler.target21/maven.compiler.targetproject.build.sourceEncodingUTF-8/project.build.sourceEncodingmybatis-plus.version3.5.17/mybatis-plus.versiondruid.version1.2.28/druid.version/propertiesdependenciesdependencygroupIdorg.springframework.boot/groupIdartifactIdspring-boot-starter-webmvc/artifactId/dependency!-- --!-- MyBatis Plus --!-- --dependencygroupIdcom.baomidou/groupIdartifactIdmybatis-plus-spring-boot4-starter/artifactIdversion${mybatis-plus.version}/version/dependency!-- --!-- MySQL --!-- Spring Boot 4.0.8 BOM 管理版本9.7.0 --!-- --dependencygroupIdcom.mysql/groupIdartifactIdmysql-connector-j/artifactIdscoperuntime/scope/dependency!-- --!-- Druid --!-- --dependencygroupIdcom.alibaba/groupIdartifactIddruid-spring-boot-4-starter/artifactIdversion1.2.28/version/dependencydependencygroupIdorg.projectlombok/groupIdartifactIdlombok/artifactIdscopeannotationProcessor/scope/dependency/dependencies/project代码自动生成安装 mybatisplus 插件在插件中搜索mybatisplus如下截图安装插件即可。使用 mybatisplus 插件按如下顺序点击工具-Code Generator会先弹出框让你进行登录数据库、填写完认证信息后将会弹出如下窗口当前数据库testdb中只有tb-client这一张表调整后的信息如下选中 table 表后点击 右下角的生成按钮将会自动生成entitymapperservicecontroller相关代码如下启动类Applicationpackagecom.junjiu.mybatisplus.pro;importorg.mybatis.spring.annotation.MapperScan;importorg.springframework.boot.SpringApplication;importorg.springframework.boot.autoconfigure.SpringBootApplication;SpringBootApplicationMapperScan(com.junjiu.mybatisplus.pro.mapper)publicclassApplication{publicstaticvoidmain(String[]args){SpringApplication.run(Application.class,args);}}