再用mybatis-plus

这个项目又能用mybaits-plus了,太棒了,大大增加开发效率;重新配置下;

(1)引入maven依赖(没写版本号):

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.velocity</groupId>
            <artifactId>velocity-engine-core</artifactId>
        </dependency>

(2)配置参数:

#驼峰命名
mybatis-plus.configuration.map-underscore-to-camel-case=true
#指定实体包
mybatis-plus.type-aliases-package=com.door.domain.entity
#指定xml
mybatis-plus.mapperLocations=classpath*:mapper/*.xml
#逻辑删除指定值
mybatis-plus.global-config.db-config.logic-delete-value=-1
mybatis-plus.global-config.db-config.logic-not-delete-value=1

(3)注入一些组件:

    //分页插件
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }
    
    //乐观锁插件
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor() {
        return new OptimisticLockerInterceptor();
    }

---逻辑删除自定注入了,实现功能删除自动使用指定字段逻辑删除;指定字段注解为:@TableLogic

---乐观锁就是每次更新都会查版本号并加一,例如:update table set  a = 1,version = version+1 where version = version;注解为:@Version

(4)代码生成器(这个是必须用的,大大简化开发):

package com.door.util;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.core.toolkit.StringPool;
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.TableInfo;
import com.baomidou.mybatisplus.generator.config.rules.DateType;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import com.baomidou.mybatisplus.generator.engine.VelocityTemplateEngine;
import org.apache.commons.lang3.StringUtils;

import java.util.ArrayList;
import java.util.List;

/**
 * @Auther: gaoyang
 * @Date: 2019/5/22 17:51
 * @Description:
 */
public class CodeGenerator {

    public static void main(String[] args) {
        String url = "jdbc:MySql://xxxx?characterEncoding=UTF-8&allowMultiQueries=true&useSSL=true";
        //项目实际路径
        String projectPath = "C:\\java\\project\\menpad\\springboot\\door-spring-boot\\door-service";
        //登陆账号
        String username = "root";
        //密码
        String password = "xxxx";
        //要生成的表
        String tables = "tb_ware_house_new";
        //生成代码的包名
        String parent = "com.door";
        //各模块包名
        String entity = "domain.warehouse";
        String service = "service.warehouse";
        String mapper = "dao.warehouse";
        String controller = "";
        //主键类型(下面是用户输入,还有自增啥的)
        IdType idType = IdType.INPUT;
        //逻辑删除字段
        String delete = "yn";
        //乐观锁字段
        String version = "sys_version";
        generator(url, username, password, projectPath, parent, entity, mapper, service, tables, idType, delete, version, controller);
    }

    public static void generator(String url, String username, String password
            , String projectPath, String parent, String entity, String mapper, String service
            , String tables, IdType idType, String delete, String version, String controller) {
        // 代码生成器
        AutoGenerator mpg = new AutoGenerator();

        // 全局配置
        GlobalConfig gc = new GlobalConfig();
        gc.setOutputDir(projectPath + "/src/main/java");
        gc.setAuthor("gaoyang");
        gc.setOpen(false);
        gc.setDateType(DateType.ONLY_DATE);
        gc.setIdType(idType);
        mpg.setGlobalConfig(gc);

        // 数据源配置
        DataSourceConfig dsc = new DataSourceConfig();
        dsc.setUrl(url);
        // dsc.setSchemaName("public");
        dsc.setDriverName("com.mysql.jdbc.Driver");
        dsc.setUsername(username);
        dsc.setPassword(password);
        mpg.setDataSource(dsc);

        // 包配置
        PackageConfig pc = new PackageConfig();
        //  pc.setModuleName("door-service");
        pc.setParent(parent);
        pc.setEntity(entity);
        pc.setServiceImpl(service + ".impl");
        pc.setMapper(mapper);
        pc.setService(service);
        pc.setController(controller);
        pc.setXml("");
        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 + "/src/main/resources/mapper/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
            }
        });
        /*
        cfg.setFileCreate(new IFileCreate() {
            @Override
            public boolean isCreate(ConfigBuilder configBuilder, FileType fileType, String filePath) {
                // 判断自定义文件夹是否需要创建
                checkDir("调用默认方法创建的目录");
                return false;
            }
        });
        */
        cfg.setFileOutConfigList(focList);
        mpg.setCfg(cfg);

        // 配置模板
        TemplateConfig templateConfig = new TemplateConfig();
        // 配置自定义输出模板
        //指定自定义模板路径，注意不要带上.ftl/.vm, 会根据使用的模板引擎自动识别
        // templateConfig.setEntity("templates/entity2.java");
        // templateConfig.setService();
        // templateConfig.setController();
 
      /*  templateConfig.setXml(null);
        templateConfig.setEntity("domain/%.java");
        templateConfig.setMapper("dao/%mapper.java");
        templateConfig.setService("service/%service.java");*/
        mpg.setTemplate(templateConfig);

        // 策略配置
        StrategyConfig strategy = new StrategyConfig();
        strategy.setNaming(NamingStrategy.underline_to_camel);
        strategy.setColumnNaming(NamingStrategy.underline_to_camel);
        //strategy.setSuperEntityClass("com.baomidou.ant.common.BaseEntity");
        strategy.setEntityLombokModel(true);
        strategy.setRestControllerStyle(true);
        //strategy.setSuperControllerClass("com.baomidou.ant.common.BaseController");
        //设置表
        strategy.setInclude(tables);
        // strategy.setSuperEntityColumns("id");
        strategy.setControllerMappingHyphenStyle(true);
        strategy.setTablePrefix(pc.getModuleName() + "_");
        // strategy.setEntityTableFieldAnnotationEnable(true);
        strategy.setLogicDeleteFieldName(delete);
        if (StringUtils.isNotBlank(version)) {
            strategy.setVersionFieldName(version);
        }
        mpg.setStrategy(strategy);
        mpg.setTemplateEngine(new VelocityTemplateEngine());
        mpg.execute();
    }
}