官方文档地址
https://baomidou.com/pages/981406/#%E6%95%B0%E6%8D%AE%E5%BA%93%E9%85%8D%E7%BD%AE-datasourceconfig
数据库测试SQL
create database my_app collate utf8mb4_bin;
use my_app;
create table m_user(user_id bigint primary key auto_increment,username varchar(32) not null );
# 修改表
alter table m_user add create_time bigint null comment '创建时间';
alter table m_user add update_time bigint null comment '更新时间';
alter table m_user add version int null comment '乐观锁版本';
alter table m_user add deleted int comment '逻辑删除';
build.gradle
dependencies {
runtimeOnly 'mysql:mysql-connector-java:8.0.33'
implementation 'com.baomidou:mybatis-plus-boot-starter:3.5.3.1'
implementation 'com.baomidou:mybatis-plus-generator:3.5.3.1'
implementation 'org.freemarker:freemarker:2.3.31'
implementation 'org.apache.velocity:velocity-engine-core:2.3'
}
代码
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.generator.FastAutoGenerator;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
import com.baomidou.mybatisplus.generator.fill.Column;
import com.baomidou.mybatisplus.generator.fill.Property;
public class MainApplication {
private static String driver = "com.mysql.cj.jdbc.Driver";
public static void main(String[] args) throws Exception {
Class.forName(driver);
FastAutoGenerator.create(
"jdbc:mysql://127.0.0.1:3306/my_app?serverTimezone=GMT%2B8&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true",
"root", "2023")
.globalConfig(
builder -> {
builder
.disableOpenDir()
.author("ms") // 设置作者
.fileOverride() // 覆盖已生成文件
.outputDir("gen/src/main/java"); // 指定输出目录
})
.packageConfig(
builder -> {
// 设置父包名
builder.parent("com.my.app.mysql");
builder.moduleName("my_app");
})
.strategyConfig(
builder -> {
// 数据库表
builder.addInclude("m_user");
builder.entityBuilder().idType(IdType.ASSIGN_ID);
builder.entityBuilder().logicDeleteColumnName("deleted");
builder.entityBuilder().logicDeletePropertyName("deleted");
builder.entityBuilder().versionColumnName("version");
builder.entityBuilder().versionPropertyName("version");
builder.entityBuilder().enableChainModel();
builder.entityBuilder().addTableFills(new Column("create_time", FieldFill.INSERT));
builder.entityBuilder().addTableFills(new Property("update_time", FieldFill.INSERT_UPDATE));
builder.entityBuilder().enableFileOverride();
})
.templateEngine(new FreemarkerTemplateEngine()) // 使用Freemarker引擎模板,默认的是Velocity引擎模板
.execute();
}
}
完整案例github地址
https://github.com/code-mm/mybatis-plus-codegen-example.git