New file |
| | |
| | | package com.ycl; |
| | | |
| | | import com.baomidou.mybatisplus.annotation.FieldFill; |
| | | import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException; |
| | | import com.baomidou.mybatisplus.core.toolkit.StringPool; |
| | | import com.baomidou.mybatisplus.core.toolkit.StringUtils; |
| | | import com.baomidou.mybatisplus.generator.AutoGenerator; |
| | | import com.baomidou.mybatisplus.generator.InjectionConfig; |
| | | import com.baomidou.mybatisplus.generator.config.*; |
| | | import com.baomidou.mybatisplus.generator.config.po.TableFill; |
| | | import com.baomidou.mybatisplus.generator.config.po.TableInfo; |
| | | import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy; |
| | | import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine; |
| | | import com.ycl.base.BaseController; |
| | | |
| | | |
| | | import java.util.ArrayList; |
| | | import java.util.List; |
| | | import java.util.Scanner; |
| | | |
| | | /** |
| | | * @author Lyq |
| | | * @version 1.0 |
| | | * @date 2022/9/14 |
| | | */ |
| | | public class MysqlGenerator { |
| | | private static final String PN_ENTITY = "entity"; |
| | | private static final String PN_CONTROLLER = "controller"; |
| | | private static final String PN_MAPPER = "mapper"; |
| | | private static final String PN_SERVICE = "service"; |
| | | private static final String PN_SERVICE_IMPL = "impl"; |
| | | private static final String PN_DELIMITER = "."; |
| | | |
| | | |
| | | /** |
| | | * <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.isNotEmpty(ipt)) { |
| | | return ipt; |
| | | } |
| | | } |
| | | throw new MybatisPlusException("请输入正确的" + tip + "!"); |
| | | } |
| | | |
| | | public static void main(String[] args) { |
| | | // 代码生成器 |
| | | AutoGenerator mpg = new AutoGenerator(); |
| | | |
| | | // 全局配置 |
| | | GlobalConfig gc = new GlobalConfig(); |
| | | String projectPath = System.getProperty("user.dir"); |
| | | gc.setOutputDir(projectPath + "/ycl-generator/src/main/java"); |
| | | gc.setAuthor("lyq");//作者 |
| | | gc.setBaseResultMap(true); //mapper.xml 生成 ResultMap |
| | | gc.setBaseColumnList(true); //mapper.xml 生成 ColumnList |
| | | // gc.setSwagger2(true); |
| | | gc.setOpen(false); |
| | | // gc.setSwagger2(true); 实体属性 Swagger2 注解 |
| | | // 是否覆盖已有文件 |
| | | gc.setFileOverride(true); |
| | | mpg.setGlobalConfig(gc); |
| | | |
| | | // 数据源配置 |
| | | DataSourceConfig dsc = new DataSourceConfig(); |
| | | dsc.setUrl("jdbc:mysql://42.193.1.25:3306/sccg?useUnicode=true&characterEncoding=utf8&autoReconnect=true&useSSL=false"); |
| | | // dsc.setSchemaName("public"); |
| | | dsc.setDriverName("com.mysql.cj.jdbc.Driver"); |
| | | dsc.setUsername("root"); |
| | | dsc.setPassword("321$YcYl@1970!"); |
| | | mpg.setDataSource(dsc); |
| | | |
| | | // 包配置 |
| | | PackageConfig pc = new PackageConfig(); |
| | | // pc.setModuleName(scanner("模块名")); |
| | | pc.setModuleName(null); |
| | | pc.setParent("com.ycl"); |
| | | String packageName = scanner("请输入包名"); |
| | | //自定义所在包的名称 基本没必要 |
| | | pc.setEntity(PN_ENTITY + PN_DELIMITER + packageName); |
| | | pc.setController(PN_CONTROLLER + PN_DELIMITER + packageName); |
| | | pc.setMapper(PN_MAPPER + PN_DELIMITER + packageName); |
| | | pc.setService(PN_SERVICE + PN_DELIMITER + packageName); |
| | | pc.setServiceImpl(PN_SERVICE + PN_DELIMITER + packageName + PN_DELIMITER + PN_SERVICE_IMPL); |
| | | |
| | | //pc.setMapper("com.cikers.ps.mapper"); |
| | | |
| | | mpg.setPackageInfo(pc); |
| | | // 自定义配置 |
| | | InjectionConfig cfg = new InjectionConfig() { |
| | | @Override |
| | | public void initMap() { |
| | | // to do nothing |
| | | } |
| | | }; |
| | | |
| | | // 如果模板引擎是 freemarker |
| | | String templatePath = "/templates/mapper.xml.ftl"; |
| | | // 如果模板引擎是 velocity |
| | | // String templatePath = "/templates/mapper.xml.vm"; |
| | | |
| | | // 自定义输出配置 |
| | | List<FileOutConfig> focList = new ArrayList<>(); |
| | | // 自定义配置会被优先输出 |
| | | focList.add(new FileOutConfig(templatePath) { |
| | | @Override |
| | | public String outputFile(TableInfo tableInfo) { |
| | | // 自定义输出文件名 , 如果你 Entity 设置了前后缀、此处注意 xml 的名称会跟着发生变化!! |
| | | // return projectPath + "/coinyee-contract-generator/src/main/resources/mapper/" + pc.getModuleName() |
| | | // + "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML; |
| | | return projectPath + "/ycl-generator/src/main/resources/mapper/" |
| | | + packageName + "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML; |
| | | } |
| | | }); |
| | | /* |
| | | cfg.setFileCreate(new IFileCreate() { |
| | | @Override |
| | | public boolean isCreate(ConfigBuilder configBuilder, FileType fileType, String filePath) { |
| | | // 判断自定义文件夹是否需要创建 |
| | | checkDir("调用默认方法创建的目录,自定义目录用"); |
| | | if (fileType == FileType.MAPPER) { |
| | | // 已经生成 mapper 文件判断存在,不想重新生成返回 false |
| | | return !new File(filePath).exists(); |
| | | } |
| | | // 允许生成模板文件 |
| | | return true; |
| | | } |
| | | }); |
| | | */ |
| | | cfg.setFileOutConfigList(focList); |
| | | mpg.setCfg(cfg); |
| | | |
| | | // 配置模板 |
| | | TemplateConfig templateConfig = new TemplateConfig(); |
| | | |
| | | // 配置自定义输出模板 |
| | | //指定自定义模板路径,注意不要带上.ftl/.vm, 会根据使用的模板引擎自动识别 |
| | | // templateConfig.setEntity("templates/entity2.java"); |
| | | // templateConfig.setService(); |
| | | // templateConfig.setController(); |
| | | |
| | | templateConfig.setXml(null); |
| | | mpg.setTemplate(templateConfig); |
| | | |
| | | // 策略配置 |
| | | StrategyConfig strategy = new StrategyConfig(); |
| | | strategy.setNaming(NamingStrategy.underline_to_camel); |
| | | //strategy.setSuperEntityClass("你自己的父类实体,没有就不用设置!"); |
| | | strategy.setColumnNaming(NamingStrategy.underline_to_camel); |
| | | //去除字段前缀 |
| | | strategy.setFieldPrefix(""); |
| | | |
| | | List<TableFill> tableFills = new ArrayList<>(); |
| | | |
| | | TableFill createTimeFill = new TableFill("createTime", FieldFill.INSERT); |
| | | TableFill modifiedTimeFill = new TableFill("modifiedTime", FieldFill.UPDATE); |
| | | |
| | | tableFills.add(createTimeFill); |
| | | tableFills.add(modifiedTimeFill); |
| | | |
| | | // strategy.setEntityTableFieldAnnotationEnable(true); |
| | | strategy.setColumnNaming(NamingStrategy.underline_to_camel); |
| | | //strategy.setSuperEntityClass("你自己的父类实体,没有就不用设置!"); |
| | | strategy.setSuperControllerClass(BaseController.class); |
| | | // strategy.setSuperEntityClass(BaseEntity.class); |
| | | strategy.setSuperEntityColumns("createTime", "lastModify", "isDeleted"); |
| | | strategy.setTableFillList(tableFills); |
| | | strategy.setEntityBooleanColumnRemoveIsPrefix(false); |
| | | strategy.setLogicDeleteFieldName("isDeleted"); |
| | | |
| | | strategy.setVersionFieldName("version"); |
| | | strategy.setEntityTableFieldAnnotationEnable(true); |
| | | |
| | | strategy.setEntityLombokModel(true); |
| | | strategy.setRestControllerStyle(true); |
| | | |
| | | strategy.setEntityLombokModel(true); |
| | | strategy.setRestControllerStyle(true); |
| | | // 公共父类 |
| | | // strategy.setSuperControllerClass("你自己的父类控制器,没有就不用设置!"); |
| | | // 写于父类中的公共字段 |
| | | // strategy.setSuperEntityColumns("id"); |
| | | String[] split = scanner("表名,多个英文逗号分割").split(","); |
| | | strategy.setInclude(split); |
| | | strategy.setControllerMappingHyphenStyle(true); |
| | | // strategy.setTablePrefix(pc.getModuleName() + "_"); |
| | | //去掉表前缀 |
| | | strategy.setTablePrefix("ums_"); |
| | | mpg.setStrategy(strategy); |
| | | mpg.setTemplateEngine(new FreemarkerTemplateEngine()); |
| | | mpg.execute(); |
| | | } |
| | | } |