<!-- Mybatis-plus 依赖-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.2.0</version>
</dependency>
<!-- Spring Boot pagehelper 依赖 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</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.2</version>
</dependency>
生成代码
/**
* https://gitee.com/yueluo9
* @版权所有
* @作者 fancw
* @时间 2020年4月10日上午9:50:17
*/
package com.dpxdata.backend.db.config;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.InjectionConfig;
import com.baomidou.mybatisplus.generator.config.*;
import com.baomidou.mybatisplus.generator.config.converts.MySqlTypeConvert;
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 java.io.File;
import java.util.*;
/**
* MybatisPlus代码生成器
*/
public class MyGenerator {
/**
* 生成的表
*/
private static String table = "kbt_bank";
/**
* 作者
*/
private static String authorName = "Lish";
/**
* 模块名
*/
private static String packageName = "";
/**
* 自定义包路径
*/
private static String parent = "com.backend";
/**
* 各包名
*/
private static String controller = "controller";
private static String mapper = "mapper";
private static String service = "service";
private static String serviceImpl = "service.impl";
private static String model = "model";
/**
* table前缀
*/
private static String prefix = "";
private static File file = new File("");
private static String path = file.getAbsolutePath() + File.separator + "backend-db";
private static String drivername = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://127.0.0.1:3306/mybatis-plus?useUnicode=true&useSSL=false&serverTimezone=Hongkong&characterEncoding=UTF-8";
private static String username = "root";
private static String password = "root";
public void test() {
TemplateConfig templateConfig = getTemplateConfig();
AutoGenerator autoGenerator = new AutoGenerator();
autoGenerator = setGlobalConfig(autoGenerator);
autoGenerator = setDataSource(autoGenerator);
autoGenerator = setStrategy(autoGenerator);
autoGenerator = setPackageInfo(autoGenerator);
autoGenerator = setCfg(autoGenerator);
autoGenerator.setTemplate(templateConfig);
autoGenerator.execute();
}
public static void main(String[] args) {
TemplateConfig templateConfig = getTemplateConfig();
// 创建代码生成器
AutoGenerator autoGenerator = new AutoGenerator();
//全局配置
autoGenerator = setGlobalConfig(autoGenerator);
//数据源配置
autoGenerator = setDataSource(autoGenerator);
//策略配置
autoGenerator = setStrategy(autoGenerator);
//包配置
autoGenerator = setPackageInfo(autoGenerator);
//注入自定义配置,可以在 VM 中使用 cfg.abc 设置的值
autoGenerator = setCfg(autoGenerator);
// autoGenerator.setCfg(customerConfig());
// 配置模板
// TemplateConfig tc = new TemplateConfig();
// // tc.setEntity("templates/entity.java");
// tc.setController("templates/controller.java");
// // tc.setXml("");
// autoGenerator.setTemplate(tc);
// // 模板引擎
// autoGenerator.setTemplateEngine(new FreemarkerTemplateEngine());
// 生成
autoGenerator.setTemplate(templateConfig);
autoGenerator.execute();
// 打印注入设置,这里演示模板里面怎么获取注入内容【可无】
System.err.println(autoGenerator.getCfg().getMap().get("abc"));
}
/**
* 自定义代码生成模板
*/
private static TemplateConfig getTemplateConfig() {
TemplateConfig templateConfig = new TemplateConfig();
templateConfig
.setEntity("templates/entity.java.vm") // entity模板采用自定义模板
.setMapper("templates/mapper.java.vm")// mapper模板采用自定义模板
.setXml(null) // 不生成xml文件
.setService("templates/service.java.vm") // 生成service接口
.setServiceImpl("templates/serviceImpl.java.vm") // serviceImpl模板采用自定义模板
.setController("templates/controller.java.vm"); // controller模板采用自定义模板
return templateConfig;
}
/**
* 全局配置
*
* @param autoGenerator
* @return
*/
private static AutoGenerator setGlobalConfig(AutoGenerator autoGenerator) {
autoGenerator.setGlobalConfig(
// 全局配置
new GlobalConfig()
//输出目录
.setOutputDir(path + "/src/main/java")
// 是否覆盖文件
.setFileOverride(true)
// 开启 activeRecord 模式
.setActiveRecord(true)
// XML 二级缓存
.setEnableCache(false)
.setEnableCache(false)
// XML ResultMap
.setBaseResultMap(true)
// XML columList
.setBaseColumnList(true)
//生成后打开文件夹
.setOpen(false)
.setAuthor(authorName)
// 自定义文件命名,注意 %s 会自动填充表实体属性!
.setMapperName("%sMapper")
.setXmlName("%sMapper")
.setServiceName("%sService")
.setServiceImplName("%sServiceImpl")
.setControllerName("%sController")
.setIdType(IdType.ID_WORKER_STR)
);
return autoGenerator;
}
/**
* 数据源配置
* @param autoGenerator
* @return
*/
private static AutoGenerator setDataSource(AutoGenerator autoGenerator) {
autoGenerator.setDataSource(
// 数据源配置
new DataSourceConfig()
// 数据库类型
.setDbType(DbType.MYSQL)
.setTypeConvert(new MySqlTypeConvert() {
// 自定义数据库表字段类型转换【可选】
// @Override
// public DbColumnType processTypeConvert(String fieldType) {
// System.out.println("转换类型:" + fieldType);
// // if ( fieldType.toLowerCase().contains( "tinyint" ) ) {
// // return DbColumnType.BOOLEAN;
// // }
// return super.processTypeConvert(fieldType);
// }
})
.setDriverName(drivername)
.setUsername(username)
.setPassword(password)
.setUrl(url)
);
return autoGenerator;
}
/**
* 策略配置
* @param autoGenerator
* @return
*/
private static AutoGenerator setStrategy(AutoGenerator autoGenerator) {
// 自定义需要填充的字段
List<TableFill> tableFillList = new ArrayList<>();
tableFillList.add(new TableFill("ASDD_SS", FieldFill.INSERT_UPDATE));
autoGenerator.setStrategy(
// 策略配置
new StrategyConfig()
// 全局大写命名
// .setCapitalMode(true)
//全局下划线命名
//.setDbColumnUnderline(true)
// 此处可以修改为您的表前缀
.setTablePrefix(new String[]{prefix})
// 表名生成策略
.setNaming(NamingStrategy.underline_to_camel)
// 需要生成的表
//.setInclude(new String[]{table})
//.setRestControllerStyle(true)
.setControllerMappingHyphenStyle(true)
// 排除生成的表
//.setExclude(new String[]{"test"})
// 自定义实体父类
// .setSuperEntityClass("com.baomidou.demo.TestEntity")
// 自定义实体,公共字段
//.setSuperEntityColumns(new String[]{"test_id"})
.setTableFillList(tableFillList)
// 自定义 mapper 父类
// .setSuperMapperClass("com.baomidou.demo.TestMapper")
// 自定义 service 父类
// .setSuperServiceClass("com.baomidou.demo.TestService")
// 自定义 service 实现类父类
// .setSuperServiceImplClass("com.baomidou.demo.TestServiceImpl")
// 自定义 controller 父类
// .setSuperControllerClass("com.unicom."+packageName+".controller.AbstractController")
// 【实体】是否生成字段常量(默认 false)
// public static final String ID = "test_id";
// .setEntityColumnConstant(true)
// 【实体】是否为构建者模型(默认 false)
// public User setName(String name) {this.name = name; return this;}
// .setEntityBuilderModel(true)
// 【实体】是否为lombok模型(默认 false)<a href="https://projectlombok.org/">document</a>
.setEntityLombokModel(true)
// Boolean类型字段是否移除is前缀处理
// .setEntityBooleanColumnRemoveIsPrefix(true)
.setRestControllerStyle(true)
// .setControllerMappingHyphenStyle(true)
);
return autoGenerator;
}
/**
* 包配置
* @param autoGenerator
* @return
*/
private static AutoGenerator setPackageInfo(AutoGenerator autoGenerator) {
autoGenerator.setPackageInfo(
// 包配置
new PackageConfig()
//.setModuleName("User")
// 自定义包路径
.setParent(parent)
// 这里是控制器包名,默认 web
.setController(controller)
.setEntity(model)
.setMapper(mapper)
.setService(service)
.setServiceImpl(serviceImpl)
//.setXml("mapper")
);
return autoGenerator;
}
/**
* 注入自定义配置,可以在 VM 中使用 cfg.abc 设置的值
* @param autoGenerator
* @return
*/
private static AutoGenerator setCfg(AutoGenerator autoGenerator) {
autoGenerator.setCfg(
// 注入自定义配置,可以在 VM 中使用 cfg.abc 设置的值
new InjectionConfig() {
@Override
public void initMap() {
Map<String, Object> map = new HashMap<>();
map.put("abc", this.getConfig().getGlobalConfig().getAuthor() + "-mp");
this.setMap(map);
}
}.setFileOutConfigList(Collections.<FileOutConfig>singletonList(new FileOutConfig("/templates/mapper.xml.vm") {
// 自定义输出文件目录
@Override
public String outputFile(TableInfo tableInfo) {
return path + "/src/main/resources/kbt.mapper/" + tableInfo.getEntityName() + "Mapper.xml";
}
}))
);
return autoGenerator;
}
}
Controller 模板
controller.java.vm
/**
* @作者 Lish
* @时间 ${date}
*/
package ${package.Controller};
import org.springframework.web.bind.annotation.RequestMapping;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.dpxdata.backend.core.api.CommonResult;
#if(${restControllerStyle})
import org.springframework.web.bind.annotation.RestController;
#else
import org.springframework.stereotype.Controller;
#end
#if(${superControllerClassPackage})
import ${superControllerClassPackage};
#end
import ${package.Service}.${table.serviceName};
import ${package.Entity}.${entity};
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import java.util.List;
@Api(value = "$!{table.comment}", tags = { "$!{table.comment}" })
#if(${restControllerStyle})
@RestController
#else
@Controller
#end
@RequestMapping("#if(${package.ModuleName})/${package.ModuleName}#end/#if(${controllerMappingHyphenStyle})${controllerMappingHyphen}#else${table.entityPath}#end")
@Slf4j
#if(${kotlin})
class ${table.controllerName}#if(${superControllerClass}) : ${superControllerClass}()#end
#else
#if(${superControllerClass})
public class ${table.controllerName} extends ${superControllerClass} {
#else
public class ${table.controllerName} {
#end
@Autowired
private ${table.serviceName} ${table.entityPath}Service;
@ApiOperation(value = "添加", notes = "")
@PostMapping("/save")
public CommonResult<?> save(@RequestBody ${entity} entity) {
try{
${table.entityPath}Service.save(entity);
return CommonResult.success("操作成功");
} catch (Exception e) {
log.error(e.getMessage(), e);
return CommonResult.failed("操作失败");
}
}
@ApiOperation(value = "修改", notes = "")
@PostMapping("/update")
public CommonResult<?> update(@RequestBody ${entity} entity) {
try{
${table.entityPath}Service.updateById(entity);
return CommonResult.success("操作成功");
} catch (Exception e) {
log.error(e.getMessage(), e);
return CommonResult.failed("操作失败");
}
}
@ApiOperation(value = "删除", notes = "")
@PostMapping("/delete")
public CommonResult<?> delete(@RequestParam String id) {
try{
${table.entityPath}Service.removeById(id);
return CommonResult.success("操作成功");
} catch (Exception e) {
log.error(e.getMessage(), e);
return CommonResult.failed("操作失败");
}
}
@ApiOperation(value = "根据id查询", notes = "")
@GetMapping(value = "/info")
public CommonResult<${entity}> findById(@RequestParam String id) {
try{
return CommonResult.success(${table.entityPath}Service.getById(id));
} catch (Exception e) {
log.error(e.getMessage(), e);
return CommonResult.failed("操作失败");
}
}
@ApiOperation(value = "分页查询", notes = "")
@GetMapping(value = "/page")
public CommonResult<IPage> pageQuery(
@RequestParam(defaultValue = "1") Integer pageNo,
@RequestParam(defaultValue = "10") Integer pageSize,
@ModelAttribute ${entity} queryModel) {
try {
IPage<${entity}> page = new Page<>(pageNo, pageSize);
return CommonResult.success(${table.entityPath}Service.page(page, new QueryWrapper<>(queryModel)));
} catch (Exception e) {
log.error(e.getMessage(), e);
return CommonResult.failed("操作失败");
}
}
@ApiOperation(value = "列表查询", notes = "")
@GetMapping(value = "/list")
public CommonResult<List<${entity}>> findList(@ModelAttribute ${entity} queryModel) {
try {
return CommonResult.success(${table.entityPath}Service.list(new QueryWrapper<>(queryModel)));
} catch (Exception e) {
log.error(e.getMessage(), e);
return CommonResult.failed("操作失败");
}
}
}
#end
entity.java.vm
/**
* @作者 Lish
* @时间 ${date}
*/
package ${package.Entity};
import com.baomidou.mybatisplus.extension.activerecord.Model;
import java.io.Serializable;
import java.util.Date;
import java.time.LocalDateTime;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.experimental.Accessors;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;
import cn.afterturn.easypoi.excel.annotation.Excel;
import com.baomidou.mybatisplus.annotation.TableField;
import java.util.Date;
@Data
@EqualsAndHashCode(callSuper = false)
@Accessors(chain = true)
public class ${entity} {
private static final long serialVersionUID = 1L;
#foreach($field in ${table.fields})
#if("$!field.comment" != "")
/**
* ${field.comment}
*/
#end
#if(${field.convert})
@TableField("${field.name}")
#end
#if("$field.type" == "date")
@DateTimeFormat(pattern = "yyyy-MM-dd")
@JsonFormat(pattern="yyyy-MM-dd",timezone = "GMT+8")
@TableField(fill = FieldFill.INSERT)
#elseif("$field.type" == "datetime")
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
@TableField(fill = FieldFill.INSERT)
#end
@ApiModelProperty(name = "${field.propertyName}", value = "${field.comment}")
private ${field.propertyType} ${field.propertyName};
#end
}
service.java.vm
/**
* @作者 Lish
* @时间 ${date}
*/
package ${package.Service};
import ${package.Entity}.${entity};
import com.baomidou.mybatisplus.extension.service.IService;
public interface ${table.serviceName} extends IService<${entity}> {
}
serviceImpl.java.vm
/**
* @作者 Lish
* @时间 ${date}
*/
package ${package.ServiceImpl};
import ${package.Entity}.${entity};
import ${package.Mapper}.${table.mapperName};
import ${package.Service}.${table.serviceName};
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.transaction.annotation.Transactional;
@Service
@Transactional(rollbackFor = Exception.class)
public class ${table.serviceImplName} extends ServiceImpl<${table.mapperName}, ${entity}> implements ${entity}Service {
}