说明: 使用的是mybatis 分页使用的是插件pageHelper
一、boot-Mybaties配置
0、前提
1、依赖
<!--引入pageHelper分页插件-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
<!--mybatis-plus-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.alibaba/druid-spring-boot-starter -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.22</version>
</dependency>
<!-- https://mvnrepository.com/artifact/log4j/log4j -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
2、常用类
StudentVo
package com.example.vo;
import com.example.po.Student;
import lombok.Data;
import lombok.EqualsAndHashCode;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
/**
* Author:xd
* Description:
*/
@Data
@EqualsAndHashCode
public class StudentVo extends Student {
private Integer page=1;
private Integer limit=10;
//接受多个ID
private Integer[] ids;
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date startTime;
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date endTime;
}
DataGridView
package com.example.respones;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class DataGridView {
/**
* 封装LayUI数据表格的数据对象
*/
private Integer code=200;
private String msg="操作成功!";
private Long count;
private Object data;
/**
* 携带数据
* @param data 数据
*/
public DataGridView(Object data) {
super();
this.data = data;
}
/**
* 分页专属
* @param count
* @param data
*/
public DataGridView(Long count, Object data) {
super();
this.count = count;
this.data = data;
}
}
1、映射
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-GguRjgup-1610852336297)(…/images/image-20210117104923044.png)]
2、entity.java
##引入宏定义
$!define
##使用宏定义设置回调(保存位置与文件后缀)
#save("/po", ".java")
##使用宏定义设置包后缀
#setPackageSuffix("po")
##使用全局变量实现默认包导入
$!autoImport
import java.io.Serializable;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import com.example.vo.StudentVo;
##使用宏定义实现类注释信息
#tableComment("实体类")
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class $!{tableInfo.name} implements Serializable {
private static final long serialVersionUID = $!tool.serial();
#foreach($column in $tableInfo.fullColumn)
#if(${column.comment})/**
* ${column.comment}
*/#end
private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
#end
###foreach($column in $tableInfo.fullColumn)
####使用宏定义实现get,set方法
###getSetMethod($column)
###end
}
3、dao.java
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "Mapper"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/mapper"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}mapper;
import $!{tableInfo.savePackageName}.po.$!{tableInfo.name};
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表数据库访问层
*
* @author $!author
* @since $!time.currTime()
*/
public interface $!{tableName} {
/**
* 通过ID查询单条数据
*
* @param $!pk.name 主键
* @return 实例对象
*/
$!{tableInfo.name} queryById($!pk.shortType $!pk.name);
/**
* 通过实体作为筛选条件查询
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 对象列表
*/
List<$!{tableInfo.name}> queryLikeAll($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 通过实体作为筛选条件查询
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 对象列表
*/
List<$!{tableInfo.name}> queryAll($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 新增数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 影响行数
*/
int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 批量新增数据(MyBatis原生foreach方法)
*
* @param entities List<$!{tableInfo.name}> 实例对象列表
* @return 影响行数
*/
int insertBatch(@Param("entities") List<$!{tableInfo.name}> entities);
/**
* 批量新增或按主键更新数据(MyBatis原生foreach方法)
*
* @param entities List<$!{tableInfo.name}> 实例对象列表
* @return 影响行数
*/
int insertOrUpdateBatch(@Param("entities") List<$!{tableInfo.name}> entities);
/**
* 修改数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 影响行数
*/
int update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 通过主键删除数据
*
* @param $!pk.name 主键
* @return 影响行数
*/
int deleteById($!pk.shortType $!pk.name);
}
4、service.java
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "Service"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/service"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service;
import $!{tableInfo.savePackageName}.po.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}Vo;
import java.util.List;
import $!{tableInfo.savePackageName}.response.DataGridView;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服务接口
*
* @author $!author
* @since $!time.currTime()
*/
public interface $!{tableName} {
/**
* 通过ID查询单条数据
*
* @param $!pk.name 主键
* @return 实例对象
*/
$!{tableInfo.name} queryById($!pk.shortType $!pk.name);
## /**
## * 查询多条数据
## *
## * @param offset 查询起始位置
## * @param limit 查询条数
## * @return 对象列表
## */
## List<$!{tableInfo.name}> queryAllByLimit(int offset, int limit);
/**
* 精准查询所有
*
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo 实例对象
* @return 实例对象
*/
public DataGridView selectAll($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo);
/**
* 模糊查询所有
*
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo 实例对象
* @return 实例对象
*/
public DataGridView selectLikeAll($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo);
/**
* 新增数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo 实例对象
* @return 实例对象
*/
public void insert($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo);
/**
* 修改数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo 实例对象
* @return 实例对象
*/
public void update($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo);
/**
* 通过主键删除数据
*
* @param $!pk.name 主键
* @return 是否成功
*/
public void deleteById($!pk.shortType $!pk.name);
}
5、serviceImpl.java
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "ServiceImpl"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/service/impl"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service.impl;
import $!{tableInfo.savePackageName}.po.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import org.springframework.stereotype.Service;
import $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}Vo;
import $!{tableInfo.savePackageName}.response.DataGridView;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import javax.annotation.Resource;
import java.util.List;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服务实现类
*
* @author $!author
* @since $!time.currTime()
*/
@Service("$!tool.firstLowerCase($!{tableInfo.name})Service")
public class $!{tableName} implements $!{tableInfo.name}Service {
@Resource
private $!{tableInfo.name}Mapper $!tool.firstLowerCase($!{tableInfo.name})Mapper;
/**
* 通过ID查询单条数据
*
* @param $!pk.name 主键
* @return 实例对象
*/
@Override
public $!{tableInfo.name} queryById($!pk.shortType $!pk.name) {
return this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryById($!pk.name);
}
/**
* 查询多条数据
*
* @param offset 查询起始位置
* @param limit 查询条数
* @return 对象列表
*/
## @Override
## public List<$!{tableInfo.name}> queryAllByLimit(int offset, int limit) {
## return this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryAllByLimit(offset, limit);
## }
/**
* 精准分页查询
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo 实例对象
* @return
*/
@Override
public DataGridView selectAll($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
Page<Object> page = PageHelper.startPage($!tool.firstLowerCase($!{tableInfo.name})$!tool.firstUpperCase("Vo.getPage()"),$!tool.firstLowerCase($!{tableInfo.name})$!tool.firstUpperCase("Vo.getLimit()"));
List<$!{tableInfo.name}> data = this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryAll($!tool.firstLowerCase($!{tableInfo.name})Vo);
return new DataGridView(page.getTotal(),data);
}
/**
* 模糊分页查询
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo 实例对象
* @return
*/
@Override
public DataGridView selectLikeAll($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
Page<Object> page = PageHelper.startPage($!tool.firstLowerCase($!{tableInfo.name})$!tool.firstUpperCase("Vo.getPage()"),$!tool.firstLowerCase($!{tableInfo.name})$!tool.firstUpperCase("Vo.getLimit()"));
List<$!{tableInfo.name}> data = this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryLikeAll($!tool.firstLowerCase($!{tableInfo.name})Vo);
return new DataGridView(page.getTotal(),data);
}
/**
* 新增数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo 实例对象
* @return 实例对象
*/
@Override
public void insert($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.insert($!tool.firstLowerCase($!{tableInfo.name})Vo);
}
/**
* 修改数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo 实例对象
* @return 实例对象
*/
@Override
public void update($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.update($!tool.firstLowerCase($!{tableInfo.name})Vo);
}
/**
* 通过主键删除数据
*
* @param $!pk.name 主键
* @return 是否成功
*/
@Override
public void deleteById($!pk.shortType $!pk.name) {
this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.deleteById($!pk.name);
}
}
6、controller.java
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "Controller"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/controller"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}controller;
import $!{tableInfo.savePackageName}.po.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}Vo;
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import $!{tableInfo.savePackageName}.response.DataGridView;
import org.springframework.web.bind.annotation.*;
import org.springframework.util.ObjectUtils;
import javax.annotation.Resource;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表控制层
*
* @author $!author
* @since $!time.currTime()
*/
@RestController
@RequestMapping("$!tool.firstLowerCase($tableInfo.name)")
public class $!{tableName} {
/**
* 服务对象
*/
@Resource
private $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;
/**
* 通过主键查询单条数据
*
* @param id 主键
* @return 单条数据
*/
@GetMapping("selectOne")
public $!{tableInfo.name} selectOne($!pk.shortType id) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.queryById(id);
}
/**
* 通过id删除
* @param id
* @return
*/
@PostMapping("deleteById")
public DataGridView deleteById($!pk.shortType id) {
this.$!{tool.firstLowerCase($tableInfo.name)}Service.deleteById(id);
return new DataGridView();
}
/**
* 通过ids批量删除
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@PostMapping("deleteBatch")
public DataGridView deleteBatch($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
String[] ids = $!tool.firstLowerCase($!{tableInfo.name})Vo$!tool.firstUpperCase(".getIds()");
for(String id : ids){
this.$!{tool.firstLowerCase($tableInfo.name)}Service.deleteById(id);
}
return new DataGridView();
}
/**
* 插入
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@PostMapping("insert")
public DataGridView insert($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
if (!ObjectUtils.isEmpty(this.$!{tool.firstLowerCase($tableInfo.name)}Service$!tool.firstUpperCase(".")selectAll($!tool.firstLowerCase($!{tableInfo.name})Vo)$!tool.firstUpperCase(".")getData())) {
return new DataGridView("有同名,无法添加!");
}
this.$!{tool.firstLowerCase($tableInfo.name)}Service.insert($!tool.firstLowerCase($!{tableInfo.name})Vo);
return new DataGridView();
}
/**
* 精准查询所有
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@GetMapping("selectAll")
public DataGridView selectAll($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.selectAll($!tool.firstLowerCase($!{tableInfo.name})Vo);
}
/**
* 模糊查询所有
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@GetMapping("selectLikeAll")
public DataGridView selectLikeAll($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.selectLikeAll($!tool.firstLowerCase($!{tableInfo.name})Vo);
}
/**
* 更改
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@PostMapping("update")
public DataGridView update($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
this.$!{tool.firstLowerCase($tableInfo.name)}Service.update($!tool.firstLowerCase($!{tableInfo.name})Vo);
return new DataGridView();
}
}
7、mapper.xml
##引入mybatis支持
$!mybatisSupport
##设置保存名称与保存位置
$!callback.setFileName($tool.append($!{tableInfo.name}, "Mapper.xml"))
$!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="$!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper">
<resultMap type="$!{tableInfo.savePackageName}.po.$!{tableInfo.name}" id="$!{tableInfo.name}Map">
#foreach($column in $tableInfo.fullColumn)
<result property="$!column.name" column="$!column.obj.name" jdbcType="$!column.ext.jdbcType"/>
#end
</resultMap>
<!--查询单个-->
<select id="queryById" resultMap="$!{tableInfo.name}Map">
select
#allSqlColumn()
from `$!{tableInfo.obj.parent.name}`.$!tableInfo.obj.name
where $!pk.obj.name = #{$!pk.name}
</select>
<!--模糊查询-->
<select id="queryLikeAll" resultMap="$!{tableInfo.name}Map">
select
#allSqlColumn()
from `$!{tableInfo.obj.parent.name}`.$!tableInfo.obj.name
<where>
#foreach($column in $tableInfo.fullColumn)
<if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
and $!column.obj.name like concat("%",#{$!column.name},"%")
</if>
#end
</where>
</select>
## <!--查询指定行数据-->
## <select id="queryAllByLimit" resultMap="$!{tableInfo.name}Map">
## select
## #allSqlColumn()
##
## from $!{tableInfo.obj.parent.name}.$!tableInfo.obj.name
## limit #{offset}, #{limit}
## </select>
<!--通过实体作为筛选条件查询-->
<select id="queryAll" resultMap="$!{tableInfo.name}Map">
select
#allSqlColumn()
from `$!{tableInfo.obj.parent.name}`.$!tableInfo.obj.name
<where>
#foreach($column in $tableInfo.fullColumn)
<if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
and $!column.obj.name = #{$!column.name}
</if>
#end
</where>
</select>
<!--新增所有列-->
<insert id="insert" keyProperty="$!pk.name" useGeneratedKeys="true">
insert into `$!{tableInfo.obj.parent.name}`.$!{tableInfo.obj.name}(id,#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
values (#{id},#foreach($column in $tableInfo.otherColumn)#{$!{column.name}}#if($velocityHasNext), #end#end)
</insert>
<insert id="insertBatch" keyProperty="$!pk.name" useGeneratedKeys="true">
insert into `$!{tableInfo.obj.parent.name}`.$!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
values
<foreach collection="entities" item="entity" separator=",">
(#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($velocityHasNext), #end#end)
</foreach>
</insert>
<insert id="insertOrUpdateBatch" keyProperty="$!pk.name" useGeneratedKeys="true">
insert into `$!{tableInfo.obj.parent.name}`.$!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
values
<foreach collection="entities" item="entity" separator=",">
(#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($velocityHasNext), #end#end)
</foreach>
on duplicate key update
#foreach($column in $tableInfo.otherColumn)$!column.obj.name = values($!column.obj.name) #if($velocityHasNext), #end#end
</insert>
<!--通过主键修改数据-->
<update id="update">
update `$!{tableInfo.obj.parent.name}`.$!{tableInfo.obj.name}
<set>
#foreach($column in $tableInfo.otherColumn)
<if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">
$!column.obj.name = #{$!column.name},
</if>
#end
</set>
where $!pk.obj.name = #{$!pk.name}
</update>
<!--通过主键删除-->
<delete id="deleteById">
delete from `$!{tableInfo.obj.parent.name}`.$!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}
</delete>
</mapper>
8、entityVo.java
##引入宏定义
$!define
##使用宏定义设置回调(保存位置与文件后缀)
#save("/vo", ".java")
##使用宏定义设置包后缀
#setPackageSuffix("vo")
##使用全局变量实现默认包导入
$!autoImport
import java.io.Serializable;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
##使用宏定义实现类注释信息
#tableComment("视图类")
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class $!{tableInfo.name}VO extends $!{tableInfo.name} implements Serializable {
private static final long serialVersionUID = $!tool.serial();
private Integer page;
private Integer limit;
private String ids[];
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date startTime;
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date endTime;
}
二、boot-Plus配置
0、前提
1、依赖
<!--mybatis-plus-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.0</version>
</dependency>
<!-- 集成RESTFUL API文档插件依赖 -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.9.2</version>
</dependency>
<!-- 集成swagger-bootstrap-ui文档插件依赖 -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.9.2</version>
</dependency>
<!-- lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
2、常用类
1、映射
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-uB1hO4NF-1610852336308)(…/images/image-20210117104923044.png)]
2、entity
##引入宏定义
$!define
##使用宏定义设置回调(保存位置与文件后缀)
#save("/po", ".java")
##使用宏定义设置包后缀
#setPackageSuffix("po")
##使用全局变量实现默认包导入
$!autoImport
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
import java.util.Date;
##使用宏定义实现类注释信息
#tableComment("实体类")
@ApiModel(value = "$!{tableInfo.savePackageName}.po.$!{tableInfo.name}")
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@TableName(value = "$!{tool.hump2Underline($!{tableInfo.name})}")
public class $!{tableInfo.name} implements Serializable {
private static final long serialVersionUID = $!tool.serial();
## 主键列
#foreach($column in $tableInfo.pkColumn)
#if(${column.comment})/**
* ${column.comment}
*/#end
@ApiModelProperty(value="$!{column.comment}")
@TableId(value = "$!{tool.hump2Underline($!{column.name})}",type = IdType.ASSIGN_UUID)
private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
#end
## 其他列
#foreach($column in $tableInfo.otherColumn)
#if(${column.comment})/**
* ${column.comment}
*/#end
@ApiModelProperty(value="$!{column.comment}")
@TableField(value="$!{tool.hump2Underline($!{column.name})}")
private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
#end
###foreach($column in $tableInfo.fullColumn)
####使用宏定义实现get,set方法
###getSetMethod($column)
###end
}
3、dao
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "Mapper"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/mapper"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}mapper;
import $!{tableInfo.savePackageName}.po.$!{tableInfo.name};
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表数据库访问层
*
* @author XD
* @since $!time.currTime()
*/
public interface $!{tableName} extends BaseMapper<$!{tableInfo.name}> {
}
4、service
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "Service"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/service"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service;
import $!{tableInfo.savePackageName}.po.$!{tableInfo.name};
import com.baomidou.mybatisplus.extension.service.IService;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服务接口
*
* @author XD
* @since $!time.currTime()
*/
public interface $!{tableName} extends IService<$!{tableInfo.name}> {
}
5、serviceImpl
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "ServiceImpl"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/service/impl"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service.impl;
import $!{tableInfo.savePackageName}.po.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import javax.annotation.Resource;
import java.util.List;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服务实现类
*
* @author XD
* @since $!time.currTime()
*/
@Service("$!tool.firstLowerCase($!{tableInfo.name})Service")
public class $!{tableName} extends ServiceImpl<$!{tableInfo.name}Mapper, $!{tableInfo.name}> implements $!{tableInfo.name}Service {
@Resource
private $!{tableInfo.name}Mapper $!tool.firstLowerCase($!{tableInfo.name})Mapper;
}
6、controller
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "Controller"))
##设置回调
$!callback.setFileName($tool.append($tableName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/controller"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}controller;
import $!{tableInfo.savePackageName}.po.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}Vo;
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import $!{tableInfo.savePackageName}.response.DataGridView;
import org.springframework.web.bind.annotation.*;
import org.springframework.util.ObjectUtils;
import javax.annotation.Resource;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表控制层
*
* @author $!author
* @since $!time.currTime()
*/
@RestController
@RequestMapping("$!tool.firstLowerCase($tableInfo.name)")
public class $!{tableName} {
/**
* 服务对象
*/
@Resource
private $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;
/**
* 通过主键查询单条数据
*
* @param id 主键
* @return 单条数据
*/
@GetMapping("selectOne")
public $!{tableInfo.name} selectOne($!pk.shortType id) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.queryById(id);
}
/**
* 通过id删除
* @param id
* @return
*/
@PostMapping("deleteById")
public DataGridView deleteById($!pk.shortType id) {
this.$!{tool.firstLowerCase($tableInfo.name)}Service.deleteById(id);
return new DataGridView();
}
/**
* 通过ids批量删除
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@PostMapping("deleteBatch")
public DataGridView deleteBatch($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
String[] ids = $!tool.firstLowerCase($!{tableInfo.name})Vo$!tool.firstUpperCase(".getIds()");
for(String id : ids){
this.$!{tool.firstLowerCase($tableInfo.name)}Service.deleteById(id);
}
return new DataGridView();
}
/**
* 插入
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@PostMapping("insert")
public DataGridView insert($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
if (!ObjectUtils.isEmpty(this.$!{tool.firstLowerCase($tableInfo.name)}Service$!tool.firstUpperCase(".")selectAll($!tool.firstLowerCase($!{tableInfo.name})Vo)$!tool.firstUpperCase(".")getData())) {
return new DataGridView("有同名,无法添加!");
}
this.$!{tool.firstLowerCase($tableInfo.name)}Service.insert($!tool.firstLowerCase($!{tableInfo.name})Vo);
return new DataGridView();
}
/**
* 精准查询所有
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@GetMapping("selectAll")
public DataGridView selectAll($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.selectAll($!tool.firstLowerCase($!{tableInfo.name})Vo);
}
/**
* 模糊查询所有
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@GetMapping("selectLikeAll")
public DataGridView selectLikeAll($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.selectLikeAll($!tool.firstLowerCase($!{tableInfo.name})Vo);
}
/**
* 更改
* @param $!tool.firstLowerCase($!{tableInfo.name})Vo
* @return
*/
@PostMapping("update")
public DataGridView update($!{tableInfo.name}Vo $!tool.firstLowerCase($!{tableInfo.name})Vo) {
this.$!{tool.firstLowerCase($tableInfo.name)}Service.update($!tool.firstLowerCase($!{tableInfo.name})Vo);
return new DataGridView();
}
}
7、mapper
##引入mybatis支持
$!mybatisSupport
##设置保存名称与保存位置
$!callback.setFileName($tool.append($!{tableInfo.name}, "Mapper.xml"))
$!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper"))
##拿到主键
#if(!$tableInfo.pkColumn.isEmpty())
#set($pk = $tableInfo.pkColumn.get(0))
#end
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="$!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper">
<resultMap type="$!{tableInfo.savePackageName}.po.$!{tableInfo.name}" id="$!{tableInfo.name}Map">
#foreach($column in $tableInfo.fullColumn)
<result property="$!column.name" column="$!column.obj.name" jdbcType="$!column.ext.jdbcType"/>
#end
</resultMap>
<sql id="Base_Column_List">
#allSqlColumn()
</sql>
</mapper>