MP官网:https://baomidou.com/pages/981406/
用途:利用代码生成器可以方便地生成数据库表从mapper、entity、service、controller各层的代码
下面演示生成数据库表user的controller层代码:
1、设置controller层代码模板
可从目录:\repository\com\baomidou\mybatis-plus-generator\3.5.1\mybatis-plus-generator-3.5.1.jar!\templates\controller.java.vm
拷贝模板文件,将Velocity引擎模板文件controller.java.vm(如果是freemarker则是controller.java)放在src/main/resources/templates目录下(或者自定义目录,只要稍后在CodeGenerator类里设置一下就好了)
controller.java.vm文件:
package ${package.Controller};
##导入通用包
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import javax.annotation.Resource;
import java.util.List;
##导入实体类包
import $!{package.Service}.$!{table.serviceName};
import ${package.Entity}.${entity};
#if(${restControllerStyle})
import org.springframework.web.bind.annotation.RestController;
#else
import org.springframework.stereotype.Controller;
#end
#if(${superControllerClassPackage})
import ${superControllerClassPackage};
#end
/**
* <p>
* $!{table.comment} 前端控制器
* </p>
*
* @author ${author}
* @since ${date}
*/
#if(${restControllerStyle})
@RestController
#else
@Controller
#end
@RequestMapping("#if(${package.ModuleName})/${package.ModuleName}#end/#if(${controllerMappingHyphenStyle})${controllerMappingHyphen}#else${table.entityPath}#end" )
#if(${kotlin})
class ${table.controllerName}#if(${superControllerClass}) : ${superControllerClass}()#end
#else
#if(${superControllerClass})
public class ${table.controllerName} extends ${superControllerClass} {
#else
public class ${table.controllerName} {
#end
@Resource
private ${table.serviceName} ${table.entityPath}Service;
//查询所有
@GetMapping
public List<${entity}> findAll() {
return ${table.entityPath}Service.list();
}
//新增或删除接口
@PostMapping
public boolean save(@RequestBody ${entity} ${table.entityPath}){
return ${table.entityPath}Service.saveOrUpdate(${table.entityPath});
}
//删除请求接口
@DeleteMapping("/{id}")
public boolean delete(@PathVariable Integer id) {//这里的“id”必须和DeleteMapping里面的名字一样
return ${table.entityPath}Service.removeById(id);
}
//批量删除请求接口
@PostMapping("/batchDel")
public boolean deleteBatch(@RequestBody List<Integer> ids) {//这里的“id”必须和DeleteMapping里面的名字一样
return ${table.entityPath}Service.removeBatchByIds(ids);
}
//简单条件+分页查询
@GetMapping("/page")
public IPage<${entity}> findPage(
@RequestParam Integer pageNum,
@RequestParam Integer pageSize,
@RequestParam(defaultValue = "") String ${table.entityPath}name) {
IPage<${entity}> page = new Page<>(pageNum, pageSize);
QueryWrapper<${entity}> queryWrapper = new QueryWrapper<>();
if (!"".equals(${table.entityPath}name)) {//加条件判断可以查询null值
queryWrapper.like("${table.entityPath}name", ${table.entityPath}name);
}
queryWrapper.orderByDesc("id");
return ${table.entityPath}Service.page(page, queryWrapper);
}
}
#end
2、创建CodeGenerator.java
package com.shelbourne.schooldelivery.utils;
import com.baomidou.mybatisplus.generator.FastAutoGenerator;
import com.baomidou.mybatisplus.generator.config.OutputFile;
import com.baomidou.mybatisplus.generator.engine.VelocityTemplateEngine;
import java.util.Collections;
//代码生成器
public class CodeGenerator {
public static void main(String[] args) {
generate();
}
private static void generate() {
FastAutoGenerator.create("jdbc:mysql://localhost:3306/school_delivery?serverTimezone=GMT%2b8",
"root", "123456" )
// 全局配置
.globalConfig(builder -> {
builder.author("Shelby" ) // 设置作者
.enableSwagger() // 开启 swagger 模式
.fileOverride() // 覆盖已生成文件
.outputDir("D:\\study\\school_delivery\\src\\main\\java" ); // 指定输出目录
})
// 包配置
.packageConfig(builder -> {
builder.parent("com.shelbourne.schooldelivery" ) // 设置父包名
.moduleName(null) // 设置父包模块名,设为null可以避免@RequestMapping("/user" )出现双斜杠
.pathInfo(Collections.singletonMap(OutputFile.mapperXml, "D:\\study\\school_delivery\\src\\main\\resources\\mapper\\" )); // 设置mapperXml生成路径
})
// 策略配置
.strategyConfig(builder -> {
builder.addInclude("user" ) // 设置需要生成的表名
.addTablePrefix("sys_", "c_" ); // 设置过滤表前缀
})
// 模板配置
.templateConfig(builder -> {
builder.controller("/templates/controller.java.vm" );
})
// 可以使用Freemarker引擎模板,默认的是Velocity引擎模板
.templateEngine(new VelocityTemplateEngine())
.execute();
}
}
3、运行CodeGenerator类
运行结果:
生成的UserController.java文件:
package com.shelbourne.schooldelivery.controller;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.web.bind.annotation.*;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import javax.annotation.Resource;
import java.util.List;
import com.shelbourne.schooldelivery.service.IUserService;
import com.shelbourne.schooldelivery.entity.User;
import org.springframework.stereotype.Controller;
/**
* <p>
* 前端控制器
* </p>
*
* @author Shelby
* @since 2022-02-27
*/
@Controller
@RequestMapping("/user" )
public class UserController {
@Resource
private IUserService userService;
//查询所有
@GetMapping
public List<User> findAll(String username) {
return userService.list();
}
//新增或删除接口
@PostMapping
public boolean save(@RequestBody User user){
return userService.saveOrUpdate(user);
}
//删除请求接口
@DeleteMapping("/{id}")
public boolean delete(@PathVariable Integer id) {//这里的“id”必须和DeleteMapping里面的名字一样
return userService.removeById(id);
}
//批量删除请求接口
@PostMapping("/batchDel")
public boolean deleteBatch(@RequestBody List<Integer> ids) {//这里的“id”必须和DeleteMapping里面的名字一样
return userService.removeBatchByIds(ids);
}
//简单条件+分页查询
@GetMapping("/page")
public IPage<User> findPage(
@RequestParam Integer pageNum,
@RequestParam Integer pageSize,
@RequestParam(defaultValue = "") String username) {
IPage<User> page = new Page<>(pageNum, pageSize);
QueryWrapper<User> queryWrapper = new QueryWrapper<>();
if (!"".equals(username)) {//加条件判断可以查询null值
queryWrapper.like("username", username);
}
queryWrapper.orderByDesc("id");
return userService.page(page, queryWrapper);
}
}