Java Mybatis代码自动生成
1、pom文件
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-generator</artifactId>
<version>3.2.0</version>
</dependency>
<dependency>
<groupId>org.apache.velocity</groupId>
<artifactId>velocity-engine-core</artifactId>
<version>2.1</version>
</dependency>
<dependency>
<groupId>org.freemarker</groupId>
<artifactId>freemarker</artifactId>
<version>2.3.29</version>
</dependency>
<!-- lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.24</version>
<scope>provided</scope>
</dependency>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.23</version>
</dependency>
<!-- sqlserver -->
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.1.0.jre8</version>
<exclusions>
<exclusion>
<artifactId>slf4j-api</artifactId>
<groupId>org.slf4j</groupId>
</exclusion>
</exclusions>
</dependency>
<!-- sqlite -->
<dependency>
<groupId>org.xerial</groupId>
<artifactId>sqlite-jdbc</artifactId>
<version>3.23.1</version>
</dependency>
<!-- oracle -->
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>12.2.0.1</version>
</dependency>
2、代码自动生成类
package com.nosya; 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.PackageConfig; 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; public class MyBatisCodeGenerator { /** * <p> * 读取控制台内容 * </p> */ public static String scanner(String tip) { Scanner scanner = new Scanner(System.in); StringBuilder help = new StringBuilder(); help.append("请输入").append(tip).append(":"); System.out.println(help.toString()); if (scanner.hasNext()) { String ipt = scanner.next(); if (StringUtils.isNotEmpty(ipt)) { return ipt; } } throw new MybatisPlusException("请输入正确的" + tip + "!"); } public static void main(String[] args) { boolean isMysql = true; // 代码生成器 AutoGenerator mybatisPlusCodeGenerator = new AutoGenerator(); // 全局配置 GlobalConfig gc = new GlobalConfig(); // 先得到当前工程目录 String projectPath = System.getProperty("user.dir"); // 是maven项目的结构,就是工程目录 + /src/main/java gc.setOutputDir(projectPath + "/src/main/java"); //gc.setOutputDir("D:\\workspace-sts\\0520adv\\02_mp_springboot/src/main/java"); // 设置生成文件的作者信息 gc.setAuthor("nosya"); //当代码生成完成之后是否打开代码所在的文件夹 gc.setOpen(true); // gc.setSwagger2(true); 实体属性 Swagger2 注解 //gc.setServiceName("%sService"); // 将上述的全局配置注入 mybatisPlusCodeGenerator.setGlobalConfig(gc); // 数据源配置 DataSourceConfig dataSourceConfiguration = new DataSourceConfig(); if (isMysql) { dataSourceConfiguration.setUrl("jdbc:mysql://ip:port/db?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=UTC"); // dataSourceConfiguration.setSchemaName("public"); dataSourceConfiguration.setDriverName("com.mysql.cj.jdbc.Driver"); dataSourceConfiguration.setUsername("user"); dataSourceConfiguration.setPassword("password"); } else { dataSourceConfiguration.setUrl("jdbc:oracle:thin:@ip:port:db"); dataSourceConfiguration.setDriverName("oracle.jdbc.OracleDriver"); dataSourceConfiguration.setUsername("user"); dataSourceConfiguration.setPassword("password"); } mybatisPlusCodeGenerator.setDataSource(dataSourceConfiguration); // 包配置 PackageConfig pc = new PackageConfig(); // 设置父级包名 pc.setParent("com.nosya");//controller entity service service.impl // pc.setModuleName(scanner("模块名")); pc.setModuleName("web"); // 实体类名称 pc.setEntity("domain"); // mapper包名称 pc.setMapper("mapper"); // mapper对应的映射器xml pc.setXml("mapper.xml"); // 业务包层名称 pc.setService("service"); // 业务接口的实现类包 pc.setServiceImpl("service.impl"); // 控制器包名称 pc.setController("controller"); // 装填包信息对象 mybatisPlusCodeGenerator.setPackageInfo(pc); // 策略配置 StrategyConfig strategy = new StrategyConfig(); //设置字段和表名的是否把下划线完成驼峰命名规则 strategy.setNaming(NamingStrategy.underline_to_camel); strategy.setColumnNaming(NamingStrategy.underline_to_camel); //设置生成的实体类继承的父类 //strategy.setSuperEntityClass("com.sxt.BaseEntity"); //是否启动lombok strategy.setEntityLombokModel(true); //是否生成resetController strategy.setRestControllerStyle(true); // 公共父类 //strategy.setSuperControllerClass("com.sxt.BaseController"); // 写于父类中的公共字段 //strategy.setSuperEntityColumns("person_id","person_name"); //要设置生成哪些表 如果不设置就是生成所有的表 //strategy.setInclude(scanner("表名,多个英文逗号分割").split(",")); strategy.setControllerMappingHyphenStyle(true); //strategy.setTablePrefix(pc.getModuleName() + "_"); // strategy.setTablePrefix("sys_"); mybatisPlusCodeGenerator.setStrategy(strategy); mybatisPlusCodeGenerator.execute(); } }
有些事情,没经历过不知道原理,没失败过不明白奥妙,没痛苦过不了解真谛。临渊羡鱼,不如退而结网!

浙公网安备 33010602011771号