easycode模板
controller.java.vm
##定义初始变量
#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}.domain.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import $!{tableInfo.savePackageName}.util.R;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表控制层
*
* @author 纪惠婷
* @since $!time.currTime()
*/
@RestController
@RequestMapping("/$!tool.firstLowerCase($tableInfo.name)")
public class $!{tableName} {
/**
* 服务对象
*/
@Resource
private $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;
/**
* 全查询
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 筛选条件
* @return 查询结果
*/
@GetMapping
public R queryAll($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.queryAll($!{tool.firstLowerCase($tableInfo.name)});
}
/**
* 分页查询
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 筛选条件
* @param pageSize 每页多少航
* @param page 第几页
* @return 查询结果
*/
@GetMapping("/page")
public R queryAllPage($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}, Integer pageSize, Integer page) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.queryAllPage($!{tool.firstLowerCase($tableInfo.name)},pageSize,page);
}
/**
* 模糊查找
*
* @param searchText 查找关键字
* @return 查询结果
*/
@GetMapping("/search/{searchText}")
public R queryBySearchText(@PathVariable("searchText") String searchText) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.queryBySearchText(searchText);
}
/**
* 通过主键查询单条数据
*
* @param id 主键
* @return 单条数据
*/
@GetMapping("{id}")
public R queryById(@PathVariable("id") $!pk.shortType id) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.queryById(id);
}
/**
* 统计总行数
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 筛选条件
* @return 查询结果
*/
@GetMapping("/count")
public R getCount($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.getCount($!{tool.firstLowerCase($tableInfo.name)});
}
/**
* 新增数据
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 实体
* @return 新增结果
*/
@PostMapping
public R add(@RequestBody $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.insert($!{tool.firstLowerCase($tableInfo.name)});
}
/**
* 更新数据
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 实体
* @return 更新结果
*/
@PutMapping
public R update(@RequestBody $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.update($!{tool.firstLowerCase($tableInfo.name)});
}
/**
* 删除数据
*
* @param id 主键
* @return 删除是否成功
*/
@DeleteMapping
public R deleteById($!pk.shortType id) {
return this.$!{tool.firstLowerCase($tableInfo.name)}Service.deleteById(id);
}
}
domain.java.vm
##引入宏定义
$!{define.vm}
##使用宏定义设置回调(保存位置与文件后缀)
#save("/domain", ".java")
##使用宏定义设置包后缀
#setPackageSuffix("domain")
##使用全局变量实现默认包导入
$!{autoImport.vm}
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.io.Serializable;
##使用宏定义实现类注释信息
#tableComment("实体类")
@Data
@AllArgsConstructor
@NoArgsConstructor
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
}
service.java.vm
##定义初始变量
#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}.domain.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.util.R;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服务接口
*
* @author 纪惠婷
* @since $!time.currTime()
*/
public interface $!{tableName} {
/**
* 通过ID查询单条数据
*
* @param $!pk.name 主键
* @return 实例对象
*/
R queryById($!pk.shortType $!pk.name);
/**
* 全查询
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 筛选条件
* @return 查询结果
*/
R queryAll($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 分页查询
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 筛选条件
* @param pageSize 每页多少航
* @param page 第几页
* @return 查询结果
*/
R queryAllPage($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}), Integer pageSize ,Integer page);
/**
* 模糊查找
*
* @param searchText 查找关键字
* @return 查询结果
*/
R queryBySearchText(String searchText);
/**
* 统计总行数
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 筛选条件
* @return 查询结果
*/
R getCount($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 新增数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 实例对象
*/
R insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 修改数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 实例对象
*/
R update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 通过主键删除数据
*
* @param $!pk.name 主键
* @return 是否成功
*/
R deleteById($!pk.shortType $!pk.name);
}
serviceimpl.java.vm
##定义初始变量
#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}.domain.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import $!{tableInfo.savePackageName}.util.R;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服务实现类
*
* @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 R queryById($!pk.shortType $!pk.name) {
return R.ok().setData(this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryById($!pk.name));
}
/**
* 分页查询
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 筛选条件
* @param pageSize 每页多少航
* @param page 第几页
* @return 查询结果
*/
@Override
public R queryAllPage($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)},Integer pageSize, Integer page) {
return R.ok().setData(this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryAllPage($!{tool.firstLowerCase($tableInfo.name)},pageSize,page));
}
/**
* 全查询
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 筛选条件
* @return 查询结果
*/
@Override
public R queryAll($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
return R.ok().setData(this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryAll($!{tool.firstLowerCase($tableInfo.name)}));
}
/**
* 模糊查找
*
* @param searchText 查找关键字
* @return 查询结果
*/
@Override
public R queryBySearchText(String searchText){
return R.ok().setData(this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryBySearchText(searchText));
}
/**
* 统计总行数
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 筛选条件
* @return 查询结果
*/
@Override
public R getCount($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
return R.ok().setData(this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.count($!{tool.firstLowerCase($tableInfo.name)}));
}
/**
* 新增数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 实例对象
*/
@Override
public R insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {
if($!{tool.firstLowerCase($!{tableInfo.name})}.get$!tool.firstUpperCase($pk.name)()!=null && this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.queryById( $!{tool.firstLowerCase($!{tableInfo.name})}.get$!tool.firstUpperCase($pk.name)() ) == null )
return R.error("已经存在");
this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.insert($!tool.firstLowerCase($!{tableInfo.name}));
return R.ok().setData($!tool.firstLowerCase($!{tableInfo.name}));
}
/**
* 修改数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 实例对象
*/
@Override
public R update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {
this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.update($!tool.firstLowerCase($!{tableInfo.name}));
return R.ok().setData(this.queryById($!{tool.firstLowerCase($!{tableInfo.name})}.get$!tool.firstUpperCase($pk.name)()));
}
/**
* 通过主键删除数据
*
* @param $!pk.name 主键
* @return 是否成功
*/
@Override
public R deleteById($!pk.shortType $!pk.name) {
boolean del = this.$!{tool.firstLowerCase($!{tableInfo.name})}Mapper.deleteById($!pk.name) > 0;
return R.ok().setData(del);
}
}
mapper.java.vm
##定义初始变量
#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}.domain.$!{tableInfo.name};
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表数据库访问层
*
* @author 纪惠婷
* @since $!time.currTime()
*/
@Mapper
public interface $!{tableName} {
/**
* 通过ID查询单条数据
*
* @param $!pk.name 主键
* @return 实例对象
*/
$!{tableInfo.name} queryById($!pk.shortType $!pk.name);
/**
* 全查询
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 查询条件
* @return 对象列表
*/
List<$!{tableInfo.name}> queryAll($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 分页查询
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 查询条件
* @param pageSize 每页多少航
* @param page 第几页
* @return 对象列表
*/
List<$!{tableInfo.name}> queryAllPage(@Param("$!tool.firstLowerCase($!{tableInfo.name})")$!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}),
@Param("pageSize") Integer pageSize ,@Param("page") Integer page);
/**
* 模糊查找
*
* @param searchText 查找关键字
* @return 查询结果
*/
List<$!{tableInfo.name}> queryBySearchText(String searchText);
/**
* 统计总行数
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 查询条件
* @return 总行数
*/
long count($!{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 影响行数
* @throws org.springframework.jdbc.BadSqlGrammarException 入参是空List的时候会抛SQL语句错误的异常,请自行校验入参
*/
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);
}
mapper.xml.vm
##引入mybatis支持
$!{mybatisSupport.vm}
##设置保存名称与保存位置
$!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}.domain.$!{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>
<!--ID 查询-->
<select id="queryById" resultMap="$!{tableInfo.name}Map">
select
#allSqlColumn()
from $!tableInfo.obj.name
where $!pk.obj.name = #{$!pk.name}
</select>
<!--全查询-->
<select id="queryAll" resultMap="$!{tableInfo.name}Map">
select
#allSqlColumn()
from $!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>
<!--分页查询-->
<select id="queryAllPage" resultMap="$!{tableInfo.name}Map">
select
#allSqlColumn()
from $!tableInfo.obj.name
<where>
#foreach($column in $tableInfo.fullColumn)
<if test="$!tool.firstLowerCase($!{tableInfo.name}).$!column.name != null#if($column.type.equals("java.lang.String")) and $!tool.firstLowerCase($!{tableInfo.name}).$!column.name != ''#end">
and $!column.obj.name = #{$!tool.firstLowerCase($!{tableInfo.name}).$!column.name}
</if>
#end
</where>
<if test="page != null and pageSize != null">
<bind name="start" value="(page - 1) * pageSize" />
limit #{start}, #{pageSize}
</if>
</select>
<!--模糊查找-->
<select id="queryBySearchText" resultMap="$!{tableInfo.name}Map">
select
#allSqlColumn()
from $!tableInfo.obj.name
<where>
#foreach($column in $tableInfo.fullColumn)
or $!column.obj.name like concat("%", #{searchText},"%")
#end
</where>
</select>
<!--统计总行数-->
<select id="count" resultType="java.lang.Long">
select count(*)
from $!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 -->
<insert id="insert" keyProperty="$!pk.name" useGeneratedKeys="true">
insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
values (#foreach($column in $tableInfo.otherColumn)#{$!{column.name}}#if($velocityHasNext), #end#end)
</insert>
<insert id="insertBatch" keyProperty="$!pk.name" useGeneratedKeys="true">
insert into $!{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.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 -->
<update id="update">
update $!{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 -->
<delete id="deleteById">
delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}
</delete>
</mapper>
r.java.vm
##设置回调
$!callback.setFileName($tool.append("R.java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/util"))
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}util;
import lombok.Data;
import java.io.Serializable;
/**
* 统一返回对象R
*
* @author 纪惠婷
* @since $!time.currTime()
*/
@Data
public class R implements Serializable {
private static final long serialVersionUID = $!tool.serial();
private int code;
private String message;
private Object data;
/**
* 设置数据
*
* @param data 数据
* @return R
*/
public R setData(Object data) {
this.data = data;
return this;
}
/**
* 操作成功
*
* @return R
*/
public static R ok() {
R r = new R();
r.code = 200;
r.message = "OK";
return r;
}
/**
* 认证授权失败。 包括密钥信息不正确;数字签名错误;授权已超时
*
* @return R
*/
public static R fail() {
R r = new R();
r.code = 401;
r.message = "fail";
return r;
}
/**
* 系统异常
*
* @return R
*/
public static R exp() {
R r = new R();
r.code = 500;
r.message = "exception";
return r;
}
/**
* 自定义错误
*
* @return R
*/
public static R error(String error) {
R r = new R();
r.code = 111;
r.message = error;
return r;
}
}
CORSFilter.java.vm
##设置回调
$!callback.setFileName($tool.append("CORSFilter.java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/util"))
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}util;
import org.springframework.web.filter.OncePerRequestFilter;
import javax.servlet.FilterChain;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import org.springframework.stereotype.Component;
@Component
public class CORSFilter extends OncePerRequestFilter
{
@Override
protected void doFilterInternal(HttpServletRequest request, HttpServletResponse response, FilterChain filterChain)
throws ServletException, IOException
{
response.setHeader("Access-Control-Allow-Origin", "*");
response.setHeader("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS");
response.setHeader("Access-Control-Allow-Headers", "Authorization,Content-Type,Cache-Control,Accept,X-Requested-With,Access-Control-Allow-Origin,X-Session-Token");
response.setHeader("Access-Control-Max-Age", "86400");
if (request.getMethod().equals("OPTIONS"))
{
response.setStatus(HttpServletResponse.SC_OK);
return;
}
filterChain.doFilter(request, response);
}
}
application.properties
##设置回调
$!callback.setFileName($tool.append("application.properties"))
$!callback.setSavePath($tool.append($modulePath, "/src/main/resources"))
# 应用服务 WEB 访问端口
server.port=8081
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://Localhost:3306/library?serverTimezone=GMT%2b8
spring.datasource.username=root
spring.datasource.password=123456
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
spring.mvc.pathmatch.matching-strategy= ant_path_matcher
spring.jpa.database-platform = org.hibernate.dialect.MySQL5Dialect
mybatis.mapper-locations = classpath:mapper/*.xml