mybatis plus 及 动态生成器

添加依赖 pom.xml

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

		<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.3</version>
		</dependency>

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

		<!-- mysql -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>${mysql-connector-java.version}</version>
		</dependency>

我这里用的是mysql数据库，其他数据库可以自行更换驱动就行

mybatis plus 代码自动生成器

public class MyBatisPlusGenerator {

    //生成文件所在项目路径
    private static String baseProjectPath = "D:\\javaWeb\\xxl-job-master\\xxl-job-admin\\src\\main\\java";
    //生成path父目录

    //基本包名
    private static String basePackage = "com.xxl.job.admin";
    //作者
    private static String authorName = "kuangjw";
    //要生成的表名
    private static String[] tables = {
			//表名
            "potential_fraud",
            "topic_produce"

    };
    //table前缀
    //private static String prefix = "t_";

    //数据库配置四要素
    private static String driverName = "com.mysql.jdbc.Driver";
    private static String url = "jdbc:mysql://127.0.0.1:3306/xxx(数据库名)?Unicode=true&characterEncoding=UTF-8&useSSL=false";
    private static String username = "root";
    private static String password = "密码";

    public static void main(String[] args) throws SQLException {

        //1. 全局配置
        GlobalConfig config = new GlobalConfig();
        config.setActiveRecord(false) // 是否支持AR模式
                .setAuthor(authorName) // 作者
                //.setOutputDir("D:\\workspace_mp\\mp03\\src\\main\\java") // 生成路径
                .setOutputDir(baseProjectPath) // 生成路径
                .setFileOverride(true)  // 文件覆盖
                .setIdType(IdType.AUTO) // 主键策略
                .setEnableCache(false)// XML 二级缓存
                .setServiceName("%sService")  // 设置生成的service接口的名字的首字母是否为I
                // IEmployeeService
                .setBaseResultMap(true)//生成基本的resultMap
                .setBaseColumnList(true);//生成基本的SQL片段


        //2. 数据源配置
        DataSourceConfig dsConfig = new DataSourceConfig();
        DataSourceConfig dataSourceConfig = dsConfig.setDbType(DbType.MYSQL)  // 设置数据库类型
                .setDriverName(driverName)
                .setUrl(url)
                .setUsername(username)
                .setPassword(password)
                .setTypeConvert(new MySqlTypeConvert() {
                    @Override
                    public IColumnType processTypeConvert(GlobalConfig globalConfig, String fieldType) {
                        System.out.println("转换类型：" + fieldType);
                        //decimal转换成Boolean
                        if (fieldType.toLowerCase().contains("decimal")) {
                            return DbColumnType.BIG_DECIMAL;
                        }
                        if (fieldType.toLowerCase().contains("datetime")) {
                            return DbColumnType.DATE;
                        }
                        if (fieldType.toLowerCase().contains("date")) {
                            return DbColumnType.DATE;
                        }

                        return super.processTypeConvert(globalConfig, fieldType);
                    }
                });

        //3. 策略配置globalConfiguration中
        StrategyConfig stConfig = new StrategyConfig();
        stConfig.setCapitalMode(true) //全局大写命名
                //.setDbColumnUnderline(true)  // 指定表名 字段名是否使用下划线
                .setNaming(NamingStrategy.underline_to_camel) // 数据库表映射到实体的命名策略
                //.setTablePrefix("tbl_")
                .setInclude(tables);  // 生成的表

        //4. 包名策略配置
        PackageConfig pkConfig = new PackageConfig();
        pkConfig.setParent(basePackage)
                .setMapper("dao")//dao
                .setService("service")//servcie
                .setController("controller")//controller
                .setEntity("entity")
                .setXml("mapper");//mapper.xml

        //5. 整合配置
        AutoGenerator ag = new AutoGenerator();
        ag.setGlobalConfig(config)
                .setDataSource(dsConfig)
                .setStrategy(stConfig)
                .setPackageInfo(pkConfig);

        //6. 执行
        ag.execute();
    }

}

点击执行main方法 ，会生成如下文件及 *.java文件，如下图

最后再application.properties 文件处配置一下对应的映射文件地址就可以使用啦

mybatis-plus.mapper-locations=classpath:/mybatis-mapper/*Mapper.xml

mybatis plus 有自带生成的CURD接口，直接调用便可

@RequestMapping("/pageList")
    @ResponseBody
    public PageResultDto listPage(@RequestParam(required = false) @DefaultValue("10") int size,
                                  @RequestParam(required = false)  @DefaultValue("0") int page,
                                  @DefaultValue("") String searchValue){
        IPage<Authorization> page1 = authorizationService.page(
                new Page<>(page, size),
                new LambdaQueryWrapper<Authorization>()//lambda表达式，进行模糊查询语句，动态生成
                  .like(StringUtils.isNotBlank(searchValue), Authorization::getUserName,searchValue)
        );

        return  new PageResultDto (page1);
    }

@RequestMapping("/add")
    @ResponseBody
    public ReturnT<String> save(Authorization authorization){

        if (authorizationService.save(authorization)){
            return ReturnT.SUCCESS;
        }
        return ReturnT.FAIL;
//        return  new ReturnT(500,"新增失败");
    }

    @RequestMapping("/update")
    @ResponseBody
    public ReturnT<String> update(Authorization authorization){

        if (authorizationService.updateById(authorization)){
            return ReturnT.SUCCESS;
        }
        return ReturnT.FAIL;
    }

    @RequestMapping("/remove/{id}")
    @ResponseBody
    public ReturnT<String> delete(@PathVariable int id){

        if (authorizationService.removeById(id)){
            return ReturnT.SUCCESS;
        }
        return ReturnT.FAIL;
    }

具体详情可以查看mybatis plus 官方文档：mybatis 代码生成器配置