8.mybatis-plus代码生成器

1.mybatis-plus-generator 3.5.1 以下版本

1.1.pom,xml

	 <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.2.1.RELEASE</version>
        <relativePath/> 
    </parent>

	<dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!--web启动器-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>

        <!--mybatis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.3.1</version>
        </dependency>

        <!-- MyBatis代码生成器依赖 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.3.1</version>
        </dependency>
        <!-- MyBatis代码生成器的模板引擎 -->
        <dependency>
            <groupId>org.apache.velocity</groupId>
            <artifactId>velocity-engine-core</artifactId>
            <version>2.3</version>
        </dependency>
        
    </dependencies>

1.2.自动生成器

public class MPCodeGenerator {
    private static final String MP_CONFIG_AUTHOR = "quinhua"; //设置作者
    private static final String MP_CONFIG_MYSQL_NAME = "mybatis_plus"; //设置数据库
    private static final String MP_CONFIG_MYSQL_DRIVERNAME = ".cj"; //设置数据库连接驱动包 [.cj/不填]
    private static final String MP_CONFIG_MYSQL_USERNAME = "root"; //设置数据库连接用户名
    private static final String MP_CONFIG_MYSQL_PASSWORD = "root"; //设置数据库连接密码
    private static final String MP_CONFIG_CLASS_PARENT_NAME = "com.qh"; //设置包名
    private static final String MP_CONFIG_TABLE_PREFIX = "mp_"; //设置表前缀
    private static final String MP_CONFIG_LOGICDELETEFILELDNAME = "is_deleted"; //设置逻辑删除字段

    public static void main(String[] args) {

        // 全局配置
        GlobalConfig gConfig = new GlobalConfig();
        String projectPath = System.getProperty("user.dir");
        gConfig.setOutputDir(projectPath + "/src/main/java")//设置代码生成路径
                .setFileOverride(true)//是否覆盖以前文件
                .setOpen(false)//是否打开生成目录
                .setAuthor(MP_CONFIG_AUTHOR)//设置项目作者名称
                .setIdType(IdType.AUTO)//设置主键策略
                .setBaseResultMap(true)//生成基本ResultMap
                .setBaseColumnList(true)//生成基本ColumnList
                .setServiceName("%sService")//去掉服务默认前缀
                .setDateType(DateType.ONLY_DATE);//设置时间类型

        // 数据源配置
        DataSourceConfig dsConfig = new DataSourceConfig();
        dsConfig
                .setUrl("jdbc:mysql://localhost:3306/" + MP_CONFIG_MYSQL_NAME + "?useSSL=false&serverTimezone=Asia/Shanghai&characterEncoding=utf-8")
                .setDriverName("com.mysql" + MP_CONFIG_MYSQL_DRIVERNAME + ".jdbc.Driver")
                .setUsername(MP_CONFIG_MYSQL_USERNAME)
                .setPassword(MP_CONFIG_MYSQL_PASSWORD);

        // 包配置
        PackageConfig pkConfig = new PackageConfig();
        pkConfig.setParent(MP_CONFIG_CLASS_PARENT_NAME)
                .setMapper("mapper")
                .setXml("mapper.xml")
                .setEntity("pojo")
                .setService("service")
                .setServiceImpl("service.impl")
                .setController("controller");

        //设置自动填充配置
        TableFill gmt_create = new TableFill("create_time", FieldFill.INSERT);
        TableFill gmt_modified = new TableFill("update_time", FieldFill.INSERT_UPDATE);
        ArrayList<TableFill> tableFills = new ArrayList<>();
        tableFills.add(gmt_create);
        tableFills.add(gmt_modified);

        // 策略配置
        StrategyConfig stConfig = new StrategyConfig();
        stConfig.setNaming(NamingStrategy.underline_to_camel)
                .setColumnNaming(NamingStrategy.underline_to_camel)
                .setEntityLombokModel(true)//自动lombok
                .setRestControllerStyle(true)
                .setControllerMappingHyphenStyle(true)
                .setTableFillList(tableFills)
                .setLogicDeleteFieldName(MP_CONFIG_LOGICDELETEFILELDNAME)//设置逻辑删除

                //乐观锁
                .setVersionFieldName("version")
                .setRestControllerStyle(true)//驼峰命名
                .setTablePrefix(MP_CONFIG_TABLE_PREFIX)//设置表名前缀
                .setInclude(scanner("表名  -【多个表名请用英文逗号分割】").split(","));

        // 代码生成器
        AutoGenerator mpg = new AutoGenerator();
        mpg.setGlobalConfig(gConfig)
                .setDataSource(dsConfig)
                .setPackageInfo(pkConfig)
                .setStrategy(stConfig);

        // 生成代码
        mpg.execute();
    }

    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 + "！");
    }

}

1.3.修改

生成代码后需要在主启动类上添加`@MapperScan("mapper包全路径")`
或者在每个`mapper接口`中添加`@Mapper`注解，否则测试报错