参考：
https://blog.csdn.net/weixin_45947759/article/details/116805582

1.引入依赖

  1. 1.引入依赖
  2. <!--Mybatis-plus-SpringBoot集成-->
  3. <dependency>
  4.     <groupId>com.baomidou</groupId>
  5.     <artifactId>mybatis-plus-boot-starter</artifactId>
  6.     <version>3.5.1</version>
  7. </dependency>
  9. <!--hutool-->
  10. <dependency>
  11.     <groupId>cn.hutool</groupId>
  12.     <artifactId>hutool-all</artifactId>
  13.     <version>5.7.22</version>
  14. </dependency>
  16. <!--knife4j接口文档-->
  17. <dependency>
  18.     <groupId>com.github.xiaoymin</groupId>
  19.     <artifactId>knife4j-spring-boot-starter</artifactId>
  20.     <version>3.0.3</version>
  21. </dependency>

2.application.yml

  1. # mybaits-plus配置
  2. mybatis-plus:
  3.   mapperLocations: classpath:/mapper/*Mapper.xml
  4.   type-aliases-package: com.xqny.包名
  5.   configuration:
  6.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  7.     map-underscore-to-camel-case: true
  8.   global-config:
  9.     db-config:
  10.       logic-delete-field: isDelete # 全局逻辑删除的实体字段名(since 3.3.0,配置后可以忽略不需要实体类配置@TableLogic)
  11.       logic-delete-value: 1 # 逻辑已删除值(默认为 1)
  12.       logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)

3.Mybatis Plus配置类

  1. import com.baomidou.mybatisplus.annotation.DbType;
  2. import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
  3. import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
  4. import org.mybatis.spring.annotation.MapperScan;
  5. import org.springframework.context.annotation.Bean;
  6. import org.springframework.context.annotation.Configuration;
  8. @Configuration
  9. @MapperScan("com.xqny.包名.mapper")
  10. public class MybatisPlusConfig {
  12.     /**
  13.      * 分页插件,一缓和二缓遵循mybatis的规则
  14.      */
  15.     @Bean
  16.     public MybatisPlusInterceptor mybatisPlusInterceptor() {
  17.         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
  18.         interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
  19.         return interceptor;
  20.     }
  21. }

4.统一R类

  1. @ToString
  2. @Data
  3. @NoArgsConstructor
  4. @AllArgsConstructor
  5. @Accessors(chain = true)
  6. public class R<T> implements Serializable {
  8.     private static final long serialVersionUID = 1L;
  10.     @ApiModelProperty("状态码,0:成功,1:失败")
  11.     private int code;
  13.     @ApiModelProperty("返回信息")
  14.     private String msg;
  16.     @ApiModelProperty("返回数据")
  17.     private T data;
  19.     public static R ok(Object data) {
  20.         return new R(0,"success",data);
  21.     }
  23.     public static R ok(int code, String msg, Object data) {
  24.         return new R().setStatus(code).setMsg(msg).setData(data);
  25.     }
  27.     public static R fail(Object data) {
  28.         return new R(1, "error",data);
  29.     }
  31. }

5.模板

entity

  1. ##定义初始变量
  2. #set($tableName = $tableInfo.name)
  3. ##设置回调
  4. $!callback.setFileName($tool.append($tableName, ".java"))
  5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/entity"))
  7. ##使用全局变量实现默认包导入
  8. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}entity;
  9. import io.swagger.annotations.ApiModel;
  10. import io.swagger.annotations.ApiModelProperty;
  11. import lombok.AllArgsConstructor;
  12. import lombok.Data;
  13. import lombok.NoArgsConstructor;
  14. import com.baomidou.mybatisplus.annotation.IdType;
  15. import com.baomidou.mybatisplus.annotation.TableField;
  16. import com.baomidou.mybatisplus.annotation.TableId;
  17. import com.baomidou.mybatisplus.annotation.TableName;
  18. import java.io.Serializable;
  20. @Data
  21. @TableName("$!tool.hump2Underline($!{tableInfo.name})")
  22. @ApiModel("$!{tableInfo.comment}")
  23. @AllArgsConstructor
  24. @NoArgsConstructor
  25. public class $!{tableInfo.name} implements Serializable {
  27.     private static final long serialVersionUID = $!tool.serial();
  29.     #foreach($column in $tableInfo.fullColumn)
  31.     #if(${column.comment})
  32.     #end
  33.     #if(${column.name} == "id")
  34.     @TableId(value = "id", type = IdType.AUTO)
  35.     #end
  36.     #if(${column.name} != "id")
  37.     @TableField("$!tool.hump2Underline($column.name)")
  38.     #end
  39.     @ApiModelProperty("${column.comment}")
  40.     private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
  41. #end
  43. }

dao(mapper)

  1. ##定义初始变量
  2. #set($tableName = $tool.append($tableInfo.name, "Dao"))
  3. ##设置回调
  4. $!callback.setFileName($tool.append($tableName, ".java"))
  5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/dao"))
  7. ##拿到主键
  8. #if(!$tableInfo.pkColumn.isEmpty())
  9.     #set($pk = $tableInfo.pkColumn.get(0))
  10. #end
  12. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}dao;
  14. import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
  15. import org.apache.ibatis.annotations.Param;
  16. import java.util.List;
  17. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  19. /**
  20.  * $!{tableInfo.comment}($!{tableInfo.name})表数据库访问层
  21.  *
  22.  * @author $!author
  23.  * @since $!time.currTime()
  24.  */
  25. public interface $!{tableName} extends BaseMapper<$!{tableInfo.name}> {
  28. }

service

  1. ##定义初始变量
  2. #set($tableName = $tool.append($tableInfo.name, "Service"))
  3. ##设置回调
  4. $!callback.setFileName($tool.append($tableName, ".java"))
  5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/service"))
  7. ##拿到主键
  8. #if(!$tableInfo.pkColumn.isEmpty())
  9.     #set($pk = $tableInfo.pkColumn.get(0))
  10. #end
  12. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service;
  14. import com.baomidou.mybatisplus.core.metadata.IPage;
  15. import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
  16. import $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}VO;
  17. import java.util.List;
  18. import com.baomidou.mybatisplus.extension.service.IService;
  20. /**
  21.  * $!{tableInfo.comment}($!{tableInfo.name})表服务接口
  22.  *
  23.  * @author $!author
  24.  * @since $!time.currTime()
  25.  */
  26. public interface $!{tableName} extends IService<$!{tableInfo.name}> {
  28.     IPage<$!{tableInfo.name}VO> selectPageVo(Integer pageNum, Integer pageSize);
  31. }

serviceImpl

  1. ##定义初始变量
  2. #set($tableName = $tool.append($tableInfo.name, "ServiceImpl"))
  3. ##设置回调
  4. $!callback.setFileName($tool.append($tableName, ".java"))
  5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/service/impl"))
  7. ##拿到主键
  8. #if(!$tableInfo.pkColumn.isEmpty())
  9.     #set($pk = $tableInfo.pkColumn.get(0))
  10. #end
  12. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service.impl;
  14. import com.baomidou.mybatisplus.core.metadata.IPage;
  15. import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
  16. import $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}VO;
  17. import $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;
  18. import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
  19. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  20. import org.springframework.stereotype.Service;
  21. import javax.annotation.Resource;
  22. import java.util.List;
  24. /**
  25.  * $!{tableInfo.comment}($!{tableInfo.name})表服务实现类
  26.  *
  27.  * @author $!author
  28.  * @since $!time.currTime()
  29.  */
  30. @Service("$!tool.firstLowerCase($!{tableInfo.name})Service")
  31. public class $!{tableName} extends ServiceImpl<$!{tableInfo.name}Dao, $!{tableInfo.name}> implements $!{tableInfo.name}Service {
  33.     @Resource
  34.     private $!{tableInfo.name}Dao $!tool.firstLowerCase($!{tableInfo.name})Dao;
  37.     @Override
  38.     public IPage<$!{tableInfo.name}VO> selectPageVo(Integer pageNum, Integer pageSize) {
  40.         return $tool.append($!tool.firstLowerCase($tableInfo.name), 'Dao.selectPageVo(new Page(pageNum, pageSize));')
  41.     }
  43. }

controller

  1. ##定义初始变量
  2. #set($tableName = $tool.append($tableInfo.name, "Controller"))
  3. ##设置回调
  4. $!callback.setFileName($tool.append($tableName, ".java"))
  5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/controller"))
  6. ##拿到主键
  7. #if(!$tableInfo.pkColumn.isEmpty())
  8.     #set($pk = $tableInfo.pkColumn.get(0))
  9. #end
  11. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}controller;
  13. import cn.hutool.core.bean.BeanUtil;
  14. import cn.hutool.core.util.BooleanUtil;
  15. import $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}DTO;
  16. import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
  17. import $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}VO;
  18. import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
  19. import io.swagger.annotations.*;
  20. import org.springframework.web.bind.annotation.*;
  22. import javax.annotation.Resource;
  24. /**
  25.  * $!{tableInfo.comment}($!{tableInfo.name})表控制层
  26.  *
  27.  * @author $!author
  28.  * @since $!time.currTime()
  29.  */
  30. @RestController
  31. @Api(tags = "$!{tableInfo.comment}($!{tableInfo.name})")
  32. @RequestMapping("/$!tool.firstLowerCase($tableInfo.name)")
  33. public class $!{tableName} {
  34.     /**
  35.      * $!{tableInfo.name}服务对象
  36.      */
  37.     @Resource
  38.     private $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;
  41.     @GetMapping("/$!{tableInfo.name}/{id}")
  42.     @ApiOperation(value = "根据id查询$!{tableInfo.name}")
  43.     @ApiImplicitParams({
  44.             @ApiImplicitParam( name = "id", value = "id",dataTypeClass = String.class,required = true)
  45.     })
  46.     public R<$!{tableInfo.name}VO> $!{tableInfo.name}(@PathVariable("id") String id) {
  47.         $!{tableInfo.name} $!tool.firstLowerCase($tableInfo.name) = $tool.append($!tool.firstLowerCase($tableInfo.name), 'Service.query().eq("id", id).one();')
  48.         $!{tableInfo.name}VO $!tool.firstLowerCase($tableInfo.name)VO = BeanUtil.copyProperties($!tool.firstLowerCase($tableInfo.name), $!{tableInfo.name}VO.class);
  49.         return R.ok($!tool.firstLowerCase($tableInfo.name)VO);
  50.     }
  53.     @PostMapping("/insert")
  54.     @ApiOperation(value = "新增$!{tableInfo.name}")
  55.     public R<$!{tableInfo.name}VO> insert(@RequestBody $!{tableInfo.name}DTO $!tool.firstLowerCase($tableInfo.name)DTO) {
  56.         $!{tableInfo.name} $!tool.firstLowerCase($tableInfo.name) = BeanUtil.copyProperties($!tool.firstLowerCase($tableInfo.name)DTO, $!{tableInfo.name}.class);
  57.         boolean flag = $tool.append($!tool.firstLowerCase($tableInfo.name), "Service.save($!tool.firstLowerCase($tableInfo.name));")
  58.         if (BooleanUtil.isTrue(flag)) {
  59.             return R.ok("");
  60.         }
  61.         return R.fail("插入失败");
  62.     }
  65.     @GetMapping("/page")
  66.     @ApiOperation(value = "分页")
  67.     @ApiImplicitParams({
  68.             @ApiImplicitParam( name = "pageNum", value = "当前页码，默认值1",dataTypeClass = Integer.class,required = false),
  69.             @ApiImplicitParam( name = "pageSize", value = "每页个数，默认值10",dataTypeClass = Integer.class,required = false)
  70.     })
  71.     public R<$!{tableInfo.name}VO> selectPageVo(@RequestParam(required = false,defaultValue ="1") Integer pageNum, @RequestParam(required = false,defaultValue="10") Integer pageSize) {
  72.         IPage<$!{tableInfo.name}VO> $!tool.firstLowerCase($tableInfo.name)PageVO = $tool.append($!tool.firstLowerCase($tableInfo.name), 'Service.selectPageVo(pageNum,pageSize);')
  73.         return R.ok($!tool.firstLowerCase($tableInfo.name)PageVO);
  74.     }
  76. }

mapper.xml

  1. ##引入mybatis支持
  2. $!mybatisSupport
  4. ##设置保存名称与保存位置
  5. $!callback.setFileName($tool.append($!{tableInfo.name}, "Mapper.xml"))
  6. ##$!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper"))
  7. $!callback.setSavePath($tool.append($tableInfo.savePath, "/mapper"))
  9. ##拿到主键
  10. #if(!$tableInfo.pkColumn.isEmpty())
  11.     #set($pk = $tableInfo.pkColumn.get(0))
  12. #end
  14. <?xml version="1.0" encoding="UTF-8"?>
  15. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  16. <mapper namespace="$!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Dao">
  18.     <resultMap id="BaseResultMap" type="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}">
  19.         <!--@Table $!{tableInfo.originTableName}-->
  20. #foreach($column in $tableInfo.fullColumn)
  21.         <result property="$!column.name" column="$!column.obj.name" jdbcType="$!column.ext.jdbcType"/>
  22. #end
  23.     </resultMap>
  25.     <!--<association property="属性名" javaType="对应的Java类型" column="{自定义的参数名=查询的字段名}" select="查询语句所在的路径"></association>-->
  26.     <!--<collection property="属性名" javaType="对应的Java类型" column="{自定义的参数名=查询的字段名}" ofType="关联的对象类型" select="查询语句所在的路径"></collection>-->
  27.     <!--<foreach item="item" index="index" collection="ids.split(',')这里可以接受逗号分隔字符串，也能接受数组" open="(" separator="," close=")">#{item}</foreach>-->
  29. </mapper>

vo

  1. ##定义初始变量
  2. #set($tableName = $tool.append($tableInfo.name, "VO"))
  3. ##设置回调
  4. $!callback.setFileName($tool.append($tableName, ".java"))
  5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/vo"))
  7. ##使用全局变量实现默认包导入
  8. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}vo;
  10. import io.swagger.annotations.ApiModel;
  11. import io.swagger.annotations.ApiModelProperty;
  12. import lombok.AllArgsConstructor;
  13. import lombok.Data;
  14. import lombok.NoArgsConstructor;
  15. import java.io.Serializable;
  18. /**
  19.  * $!{tableInfo.comment}($!{tableInfo.name})VO
  20.  *
  21.  * @author $!author
  22.  * @since $!time.currTime()
  23.  */
  24. @Data
  25. @ApiModel("$!{tableInfo.comment}VO")
  26. @AllArgsConstructor
  27. @NoArgsConstructor
  28. public class $!{tableInfo.name}VO implements Serializable {
  30.     private static final long serialVersionUID = $!tool.serial();
  32.     #foreach($column in $tableInfo.fullColumn)
  34.     @ApiModelProperty("${column.comment}")
  35.     private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
  36. #end
  38. }

dto

  1. ##定义初始变量
  2. #set($tableName = $tool.append($tableInfo.name, "DTO"))
  3. ##设置回调
  4. $!callback.setFileName($tool.append($tableName, ".java"))
  5. $!callback.setSavePath($tool.append($tableInfo.savePath, "/dto"))
  7. ##使用全局变量实现默认包导入
  8. #if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}dto;
  10. import io.swagger.annotations.ApiModel;
  11. import io.swagger.annotations.ApiModelProperty;
  12. import lombok.AllArgsConstructor;
  13. import lombok.Data;
  14. import lombok.NoArgsConstructor;
  15. import java.io.Serializable;
  18. /**
  19.  * $!{tableInfo.comment}($!{tableInfo.name})DTO
  20.  *
  21.  * @author $!author
  22.  * @since $!time.currTime()
  23.  */
  24. @Data
  25. @ApiModel("$!{tableInfo.comment}DTO")
  26. @AllArgsConstructor
  27. @NoArgsConstructor
  28. public class $!{tableInfo.name}DTO implements Serializable {
  30.     private static final long serialVersionUID = $!tool.serial();
  32.     #foreach($column in $tableInfo.fullColumn)
  34.     @ApiModelProperty("${column.comment}")
  35.     private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
  36. #end
  38. }