都需要引入的maven依赖,一般放在公共类项目
<mysql.connector.version>5.1.46</mysql.connector.version>
<velocity.engine.core>2.0</velocity.engine.core>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.connector.version}</version>
</dependency>
<dependency>
<groupId>org.apache.velocity</groupId>
<artifactId>velocity-engine-core</artifactId>
<version>${velocity.engine.core}</version>
</dependency>
3.4.0版本生成器代码
package com.yww.common.util.mybatisplus;
import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import org.apache.commons.lang3.StringUtils;
import java.util.Scanner;
class CodeGenerator {
/**
* 数据库地址
*/
public static final String DATABASE_URL = "jdbc:mysql://xxx:6033/yww_xxx";
/**
* 数据库用户名
*/
public static final String DATABASE_NAME = "yww";
/**
* 数据库密码
*/
public static final String DATABASE_PWD = "xxx";
/**
* 生成者
*/
public static final String AUTHOR = "xxx";
/**
* 生成到本地的地址
*/
public static final String OUTPUT_DIR = "/Users/zeechao/SW/test";
/**
* 数据库驱动名
*/
public static final String DRIVE = "com.mysql.jdbc.Driver";
/**
* <p>
* 读取控制台内容
* </p>
*/
public static String scanner(String tip) {
Scanner scanner = new Scanner(System.in);
StringBuilder help = new StringBuilder();
help.append("请输入" + tip + ":");
System.out.println(help.toString());
if (scanner.hasNext()) {
String ipt = scanner.next();
if (StringUtils.isNotBlank(ipt)) {
return ipt;
}
}
throw new MybatisPlusException("请输入正确的" + tip + "!");
}
public static void main(String[] args) {
// 代码生成器
AutoGenerator mpg = new AutoGenerator();
// 全局配置
GlobalConfig gc = new GlobalConfig();
gc.setOutputDir(OUTPUT_DIR);
gc.setAuthor(AUTHOR);
gc.setOpen(false);
mpg.setGlobalConfig(gc);
// 数据源配置
DataSourceConfig dsc = new DataSourceConfig();
mpg.setDataSource(dsc);
dsc.setUrl(DATABASE_URL);
dsc.setUsername(DATABASE_NAME);
dsc.setPassword(DATABASE_PWD);
dsc.setDriverName(DRIVE);
// // 包配置
// PackageConfig pc = new PackageConfig();
// pc.setModuleName(scanner("模块名"));
// pc.setParent("cn.com.do1.dsf");
// mpg.setPackageInfo(pc);
// 策略配置
StrategyConfig strategy = new StrategyConfig();
strategy.setNaming(NamingStrategy.underline_to_camel);
strategy.setColumnNaming(NamingStrategy.underline_to_camel);
strategy.setEntityLombokModel(true);
strategy.setRestControllerStyle(true);
// 写于父类中的公共字段
strategy.setSuperEntityColumns("id");
strategy.setInclude(scanner("表名,多个英文逗号分割").split(","));
strategy.setControllerMappingHyphenStyle(true);
mpg.setStrategy(strategy);
mpg.execute();
}
}
3.5.1代码:注意新版本没有setDrive
package com.yww.common.util.mybatisplus;
import com.baomidou.mybatisplus.generator.FastAutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.OutputFile;
import com.baomidou.mybatisplus.generator.config.converts.MySqlTypeConvert;
import com.baomidou.mybatisplus.generator.config.querys.MySqlQuery;
import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
import com.baomidou.mybatisplus.generator.keywords.MySqlKeyWordsHandler;
import java.util.Collections;
/**
* @author zeechao
*/
public class Generator {
/**
* 数据库地址
*/
public static final String DATABASE_URL = "jdbc:mysql://xxx:6033/yww_xxx?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";
/**
* 数据库用户名
*/
public static final String DATABASE_NAME = "yww";
/**
* 数据库密码
*/
public static final String DATABASE_PWD = "xxx";
/**
* 生成者
*/
public static final String AUTHOR = "xxx";
/**
* 生成到本地的地址
*/
public static final String OUTPUT_DIR = "/Users/zeechao/SW/test";
/**
* 数据源配置
*/
private static final DataSourceConfig.Builder DATA_SOURCE_CONFIG = new DataSourceConfig
.Builder(DATABASE_URL, DATABASE_NAME, DATABASE_PWD)
//数据库查询
.dbQuery(new MySqlQuery())
//数据库schema(部分数据库适用)
.schema("mybatis-plus")
//数据库类型转换器
.typeConvert(new MySqlTypeConvert())
//数据库关键字处理器
.keyWordsHandler(new MySqlKeyWordsHandler());
public static void main(String[] args) {
FastAutoGenerator.create(DATA_SOURCE_CONFIG)
.globalConfig(builder -> {
builder.author(AUTHOR) // 设置作者
.fileOverride() // 覆盖已生成文件
.enableSwagger() // 开启 swagger 模式
// 指定输出目录
//直接右键复制项目根目录的绝对路径
.outputDir(OUTPUT_DIR);
})
.packageConfig(builder -> {
builder.parent("") // 设置父包名
// 设置mapperXml生成路径
//直接右键复制项目mapper文件夹的绝对路径
.pathInfo(Collections.singletonMap(OutputFile.mapperXml, OUTPUT_DIR));
})
.strategyConfig(builder -> {
builder.addInclude("test_mp_user") // 设置需要生成的表名
.addTablePrefix("t_"); // 设置过滤表前缀
})
// 使用Freemarker引擎模板,默认的是Velocity引擎模板
.templateEngine(new FreemarkerTemplateEngine())
.execute();
}
}
mybatis的依赖
<mybatis-plus.version>3.4.0</mybatis-plus.version>
<freemarker.version>2.3.30</freemarker.version>
<velocity.version>2.3</velocity.version>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>${mybatis-plus.version}</version>
</dependency>
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>${mybatis-plus-generator.version}</version>
</dependency>
<dependency>
<groupId>org.freemarker</groupId>
<artifactId>freemarker</artifactId>
<version>${freemarker.version}</version>
</dependency>
<dependency>
<groupId>org.apache.velocity</groupId>
<artifactId>velocity-engine-core</artifactId>
<version>${velocity.version}</version>
</dependency>
共存的 mybatis 需要改一下