从零搭建自己的SpringBoot后台框架(九)

冷不防 2023-08-17 15:30 221阅读 0赞

一：添加所需依赖

由于我们上篇文章讲过使用通用mapper，所以这里我们除了需要添加mybatis-generator之外还需要添加通用mapper提供的generator依赖，其次我们还需要引入两个常用jar包

  1. <!--代码生成器-->
  2. <dependency>
  3.    <groupId>org.mybatis.generator</groupId>
  4.    <artifactId>mybatis-generator-core</artifactId>
  5.    <version>1.3.5</version>
  6.    <scope>test</scope>
  7. </dependency>
  9. <dependency>
  10.    <groupId>tk.mybatis</groupId>
  11.    <artifactId>mapper-generator</artifactId>
  12.    <version>1.0.0</version>
  13. </dependency>
  15. <!--常用库依赖 -->
  16. <dependency>
  17.    <groupId>org.apache.commons</groupId>
  18.    <artifactId>commons-lang3</artifactId>
  19.    <version>3.5</version>
  20. </dependency>
  21. <dependency>
  22.    <groupId>com.google.guava</groupId>
  23.    <artifactId>guava</artifactId>
  24.    <version>22.0</version>
  25. </dependency>

二：创建系统日志表

  1. CREATE TABLE `system_log` (
  2.   `id` varchar(32) NOT NULL,
  3.   `description` varchar(50) DEFAULT NULL COMMENT '日志信息描述',
  4.   `method` varchar(20) DEFAULT NULL COMMENT '方法名称',
  5.   `log_type` varchar(10) DEFAULT NULL COMMENT '日志类型 0是正常，1是异常',
  6.   `request_ip` varchar(30) DEFAULT NULL COMMENT '请求的ip',
  7.   `exception_code` varchar(50) DEFAULT NULL COMMENT '异常错误码',
  8.   `exception_detail` varchar(255) DEFAULT NULL COMMENT '异常详情',
  9.   `params` varchar(1000) DEFAULT NULL COMMENT '请求参数',
  10.   `user_id` varchar(32) DEFAULT NULL COMMENT '请求的用户id',
  11.   `create_time` datetime DEFAULT NULL,
  12.   PRIMARY KEY (`id`)
  13. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统日志表';

三：创建系统常用变量文件夹

创建core→constant→ProjectConstant

  1. package com.example.demo.core.constant;
  3. public class ProjectConstant {
  5.    // 项目基础包名称
  6.    public static final String BASE_PACKAGE = "com.example.demo";
  8.    // Model所在包
  9.    public static final String MODEL_PACKAGE = BASE_PACKAGE + ".model";
  11.    // Mapper所在包
  12.    public static final String MAPPER_PACKAGE = BASE_PACKAGE + ".dao";
  14.    // Service所在包
  15.    public static final String SERVICE_PACKAGE = BASE_PACKAGE + ".service";
  17.    // ServiceImpl所在包
  18.    public static final String SERVICE_IMPL_PACKAGE = SERVICE_PACKAGE + ".impl";
  20.    // Controller所在包
  21.    public static final String CONTROLLER_PACKAGE = BASE_PACKAGE + ".controller";
  23.    // Mapper插件基础接口的完全限定名
  24.    public static final String MAPPER_INTERFACE_REFERENCE = BASE_PACKAGE + ".core.universal.Mapper";
  26. }

四：创建src\test\java\com\example\demo\CodeGenerator.java

  1. package com.example.demo;
  3. import com.example.demo.core.constant.ProjectConstant;
  4. import com.google.common.base.CaseFormat;
  5. import org.apache.commons.lang3.StringUtils;
  6. import org.mybatis.generator.api.MyBatisGenerator;
  7. import org.mybatis.generator.config.*;
  8. import org.mybatis.generator.internal.DefaultShellCallback;
  10. import java.util.ArrayList;
  11. import java.util.List;
  13. /**
  14.  * @Description: 代码生成器，根据数据表名称生成对应的Model、Mapper简化开发。
  15.  * @author phubing
  16.  * @date 2019/4/23 20:28
  17.  */
  18. public class CodeGenerator {
  20.    // JDBC配置，请修改为你项目的实际配置
  21.    private static final String JDBC_URL = "jdbc:mysql://localhost:3333/demo";
  22.    private static final String JDBC_USERNAME = "root";
  23.    private static final String JDBC_PASSWORD = "123456";
  24.    private static final String JDBC_DIVER_CLASS_NAME = "com.mysql.jdbc.Driver";
  25.    private static final String JAVA_PATH = "src/main/java"; // java文件路径
  26.    private static final String RESOURCES_PATH = "src/main/resources";// 资源文件路径
  28.    /**
  29.     * genCode("输入表名","输入自定义Model名称");
  30.     * 如果想创建所有表，请输入"%"
  31.     * @param args
  32.     */
  33.    public static void main(String[] args) {
  34.       genCode("system_log");
  35.    }
  37.    /**
  38.     * 通过数据表名称生成代码，Model 名称通过解析数据表名称获得，下划线转大驼峰的形式。 如输入表名称 "t_user_detail" 将生成
  39.     * TUserDetail、TUserDetailMapper、TUserDetailService ...
  40.     * 
  41.     * @param tableNames
  42.     *            数据表名称...
  43.     */
  44.    public static void genCode(String... tableNames) {
  45.       for (String tableName : tableNames) {
  46.          genCode(tableName, null);
  47.       }
  48.    }
  50.    /**
  51.     * 通过数据表名称，和自定义的 Model 名称生成代码 如输入表名称 "t_user_detail" 和自定义的 Model 名称 "User"
  52.     * 将生成 User、UserMapper、UserService ...
  53.     * 
  54.     * @param tableName
  55.     *            数据表名称
  56.     * @param modelName
  57.     *            自定义的 Model 名称
  58.     */
  59.    public static void genCode(String tableName, String modelName) {
  60.       genModelAndMapper(tableName, modelName);
  61.    }
  63.    public static void genModelAndMapper(String tableName, String modelName) {
  64.       Context context = getContext();
  66.       JDBCConnectionConfiguration jdbcConnectionConfiguration = getJDBCConnectionConfiguration();
  67.       context.setJdbcConnectionConfiguration(jdbcConnectionConfiguration);
  69.       PluginConfiguration pluginConfiguration = getPluginConfiguration();
  70.       context.addPluginConfiguration(pluginConfiguration);
  72.       JavaModelGeneratorConfiguration javaModelGeneratorConfiguration = getJavaModelGeneratorConfiguration();
  73.       context.setJavaModelGeneratorConfiguration(javaModelGeneratorConfiguration);
  75.       SqlMapGeneratorConfiguration sqlMapGeneratorConfiguration = getSqlMapGeneratorConfiguration();
  76.       context.setSqlMapGeneratorConfiguration(sqlMapGeneratorConfiguration);
  78.       JavaClientGeneratorConfiguration javaClientGeneratorConfiguration =getJavaClientGeneratorConfiguration();
  79.       context.setJavaClientGeneratorConfiguration(javaClientGeneratorConfiguration);
  81.       TableConfiguration tableConfiguration = new TableConfiguration(context);
  82.       tableConfiguration.setTableName(tableName);
  83.       tableConfiguration.setDomainObjectName(modelName);
  84.       context.addTableConfiguration(tableConfiguration);
  86.       List<String> warnings;
  87.       MyBatisGenerator generator;
  88.       try {
  89.          Configuration config = new Configuration();
  90.          config.addContext(context);
  91.          config.validate();
  92.          boolean overwrite = true;
  93.          DefaultShellCallback callback = new DefaultShellCallback(overwrite);
  94.          warnings = new ArrayList<>();
  95.          generator = new MyBatisGenerator(config, callback, warnings);
  96.          generator.generate(null);
  97.       } catch (Exception e) {
  98.          throw new RuntimeException("生成Model和Mapper失败", e);
  99.       }
  101.       if (generator.getGeneratedJavaFiles().isEmpty() || generator.getGeneratedXmlFiles().isEmpty()) {
  102.          throw new RuntimeException("生成Model和Mapper失败：" + warnings);
  103.       }
  104.       if (StringUtils.isEmpty(modelName)){
  105.          modelName = tableNameConvertUpperCamel(tableName);
  106.       }
  107.       System.out.println(modelName + ".java 生成成功");
  108.       System.out.println(modelName + "Mapper.java 生成成功");
  109.       System.out.println(modelName + "Mapper.xml 生成成功");
  110.    }
  112.    private static Context getContext(){
  113.       Context context = new Context(ModelType.FLAT);
  114.       context.setId("Potato");
  115.       context.setTargetRuntime("MyBatis3Simple");
  116.       context.addProperty(PropertyRegistry.CONTEXT_BEGINNING_DELIMITER, "`");
  117.       context.addProperty(PropertyRegistry.CONTEXT_ENDING_DELIMITER, "`");
  118.       return context;
  119.    }
  121.    private static JDBCConnectionConfiguration getJDBCConnectionConfiguration(){
  122.       JDBCConnectionConfiguration jdbcConnectionConfiguration = new JDBCConnectionConfiguration();
  123.       jdbcConnectionConfiguration.setConnectionURL(JDBC_URL);
  124.       jdbcConnectionConfiguration.setUserId(JDBC_USERNAME);
  125.       jdbcConnectionConfiguration.setPassword(JDBC_PASSWORD);
  126.       jdbcConnectionConfiguration.setDriverClass(JDBC_DIVER_CLASS_NAME);
  127.       return jdbcConnectionConfiguration;
  128.    }
  130.    private static PluginConfiguration getPluginConfiguration(){
  131.       PluginConfiguration pluginConfiguration = new PluginConfiguration();
  132.       pluginConfiguration.setConfigurationType("tk.mybatis.mapper.generator.MapperPlugin");
  133.       pluginConfiguration.addProperty("mappers", ProjectConstant.MAPPER_INTERFACE_REFERENCE);
  134.       return pluginConfiguration;
  135.    }
  137.    private static JavaModelGeneratorConfiguration getJavaModelGeneratorConfiguration(){
  138.       JavaModelGeneratorConfiguration javaModelGeneratorConfiguration = new JavaModelGeneratorConfiguration();
  139.       javaModelGeneratorConfiguration.setTargetProject(JAVA_PATH);
  140.       javaModelGeneratorConfiguration.setTargetPackage(ProjectConstant.MODEL_PACKAGE);
  141.       javaModelGeneratorConfiguration.addProperty("enableSubPackages","true");
  142.       javaModelGeneratorConfiguration.addProperty("trimStrings","true");
  143.       return javaModelGeneratorConfiguration;
  144.    }
  146.    private static SqlMapGeneratorConfiguration getSqlMapGeneratorConfiguration(){
  147.       SqlMapGeneratorConfiguration sqlMapGeneratorConfiguration = new SqlMapGeneratorConfiguration();
  148.       sqlMapGeneratorConfiguration.setTargetProject(RESOURCES_PATH);
  149.       sqlMapGeneratorConfiguration.setTargetPackage("mapper");
  150.       return sqlMapGeneratorConfiguration;
  151.    }
  153.    private static JavaClientGeneratorConfiguration getJavaClientGeneratorConfiguration(){
  154.       JavaClientGeneratorConfiguration javaClientGeneratorConfiguration = new JavaClientGeneratorConfiguration();
  155.       javaClientGeneratorConfiguration.setTargetProject(JAVA_PATH);
  156.       javaClientGeneratorConfiguration.setTargetPackage(ProjectConstant.MAPPER_PACKAGE);
  157.       javaClientGeneratorConfiguration.setConfigurationType("XMLMAPPER");
  158.       return javaClientGeneratorConfiguration;
  159.    }
  161.    private static String tableNameConvertUpperCamel(String tableName) {
  162.       return CaseFormat.LOWER_UNDERSCORE.to(CaseFormat.UPPER_CAMEL, tableName.toLowerCase());
  163.    }
  164. }

五：功能测试

在CodeGenerator中右键run

format_png

format_png 1

ok，创建成功

发表评论

表情：
评论列表 （有 0 条评论，221人围观）

还没有评论，来说两句吧...

相关阅读