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 org.springframework.data.domain.Page;
import org.springframework.data.domain.PageRequest;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.*;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表控制层
*
* @author $!author
* @since $!time.currTime()
*/
@RestController
@RequestMapping("$!tool.firstLowerCase($tableInfo.name)")
@RequiredArgsConstructor
public class $!{tableName} extends BaseController{
/**
* 依赖注入
*/
private final $!{tableInfo.name}Service $!{tool.firstLowerCase($tableInfo.name)}Service;
/**
* 查询列表
*/
//@PreAuthorize("@ss.hasPermi('$!tool.firstLowerCase($tableInfo.name):list')")
@GetMapping("/list")
public TableDataInfo list($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
startPage();
List<$!{tableInfo.name}> list = $!{tool.firstLowerCase($tableInfo.name)}Service.select$!{tableInfo.name}List($!{tool.firstLowerCase($tableInfo.name)});
return getDataTable(list);
}
/**
* 导出数据
*/
//@PreAuthorize("@ss.hasPermi('$!tool.firstLowerCase($tableInfo.name):export')")
@Log(title = "$!{tableInfo.name}", businessType = BusinessType.EXPORT)
@PostMapping("/export")
public void export(HttpServletResponse response, $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
List<$!{tableInfo.name}> list = $!{tool.firstLowerCase($tableInfo.name)}Service.select$!{tableInfo.name}List($!{tool.firstLowerCase($tableInfo.name)});
ExcelUtil<$!{tableInfo.name}> util = new ExcelUtil<$!{tableInfo.name}>($!{tableInfo.name}.class);
util.exportExcel(response, list, "$!{tableInfo.name}数据");
}
/**
* 获取详细信息
*/
//@PreAuthorize("@ss.hasPermi('$!tool.firstLowerCase($tableInfo.name):query')")
@GetMapping("/{id}")
public AjaxResult getInfo(@PathVariable("id") Long id) {
return success($!{tool.firstLowerCase($tableInfo.name)}Service.select$!{tableInfo.name}ById(id));
}
/**
* 新增数据
*/
//@PreAuthorize("@ss.hasPermi('$!tool.firstLowerCase($tableInfo.name):add')")
@Log(title = "$!{tableInfo.name}", businessType = BusinessType.INSERT)
@PostMapping
public AjaxResult add(@RequestBody $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
return toAjax($!{tool.firstLowerCase($tableInfo.name)}Service.insert$!{tableInfo.name}($!{tool.firstLowerCase($tableInfo.name)}));
}
/**
* 修改数据
*/
//@PreAuthorize("@ss.hasPermi('$!tool.firstLowerCase($tableInfo.name):edit')")
@Log(title = "$!{tableInfo.name}", businessType = BusinessType.UPDATE)
@PutMapping
public AjaxResult edit(@RequestBody $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {
return toAjax($!{tool.firstLowerCase($tableInfo.name)}Service.update$!{tableInfo.name}($!{tool.firstLowerCase($tableInfo.name)}));
}
/**
* 删除数据
*/
//@PreAuthorize("@ss.hasPermi('$!tool.firstLowerCase($tableInfo.name):remove')")
@Log(title = "$!{tableInfo.name}", businessType = BusinessType.DELETE)
@DeleteMapping("/{ids}")
public AjaxResult remove(@PathVariable Long[] ids) {
return toAjax($!{tool.firstLowerCase($tableInfo.name)}Service.delete$!{tableInfo.name}ByIds(ids));
}
}
domain.java.vm
##引入宏定义
$!{define.vm}
##使用宏定义设置回调(保存位置与文件后缀)
#save("/domain", ".java")
##使用宏定义设置包后缀
#setPackageSuffix("domain")
##使用宏定义实现类注释信息
#tableComment("实体类")
@Data
public class $!{tableInfo.name} extends BaseEntity {
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 java.util.List;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服务接口
*
* @author $!author
* @since $!time.currTime()
*/
public interface $!{tableName} {
/**
* 根据主键查询单个实体
*
* @param id 主键
* @return 对应实体对象
*/
$!{tableInfo.name} select$!{tableInfo.name}ById(Long id);
/**
* 查询实体列表
*
* @param $!tool.firstLowerCase($tableInfo.name) 实体对象(可作为筛选条件)
* @return 实体对象集合
*/
List<$!{tableInfo.name}> select$!{tableInfo.name}List($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)});
/**
* 新增实体
*
* @param $!tool.firstLowerCase($tableInfo.name) 要新增的实体对象
* @return 受影响的行数,新增成功通常返回1,失败返回0等
*/
int insert$!{tableInfo.name}($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)});
/**
* 修改实体
*
* @param $!tool.firstLowerCase($tableInfo.name) 要修改的实体对象
* @return 受影响的行数,一般成功修改返回1
*/
int update$!{tableInfo.name}($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)});
/**
* 批量删除实体
*
* @param ids 需要删除的实体主键数组
* @return 受影响的行数,即成功删除的记录数
*/
int delete$!{tableInfo.name}ByIds(Long[] ids);
/**
* 删除单个实体(通过主键删除)
*
* @param id 主键
* @return 受影响的行数,成功删除返回1
*/
int delete$!{tableInfo.name}ById(Long id);
}
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.Param;
import org.springframework.data.domain.Pageable;
import java.util.List;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表数据库访问层
*
* @author $!author
* @since $!time.currTime()
*/
public interface $!{tableName} {
/**
* 查询数据
*
* @param $!pk.name 主键
* @return 实例对象
*/
$!{tableInfo.name} select$!{tableInfo.name}ById(Long id);
/**
* 查询列表
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 查询条件
* @return 对象列表
*/
List<$!{tableInfo.name}> select$!{tableInfo.name}List($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 新增数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 影响行数
*/
int insert$!{tableInfo.name}($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 修改数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 影响行数
*/
int update$!{tableInfo.name}($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));
/**
* 批量删除数据
*
* @param $!pk.name 主键
* @return 影响行数
*/
int delete$!{tableInfo.name}ByIds(Long[] id);
/**
* 删除数据
*
* @param $!pk.name 主键
* @return 影响行数
*/
int delete$!{tableInfo.name}ById(Long id);
}
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 org.springframework.stereotype.Service;
import org.springframework.data.domain.Page;
import org.springframework.data.domain.PageImpl;
import org.springframework.data.domain.PageRequest;
import java.util.List;
/**
* $!{tableInfo.comment}($!{tableInfo.name})表服务实现类
*
* @author $!author
* @since $!time.currTime()
*/
@Service("$!tool.firstLowerCase($!{tableInfo.name})Service")
@RequiredArgsConstructor
public class $!{tableName} implements $!{tableInfo.name}Service {
private final $!{tableInfo.name}Mapper $!tool.firstLowerCase($!{tableInfo.name})Mapper;
/**
* 查询数据
*
* @param id 主键
* @return 实例对象
*/
@Override
public $!{tableInfo.name} select$!{tableInfo.name}ById(Long id) {
return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.select$!{tableInfo.name}ById(id);
}
/**
* 查询列表
*
* @param $!{tool.firstLowerCase($tableInfo.name)} 筛选条件
* @return 查询结果
*/
@Override
public List<$!{tableInfo.name}> select$!{tableInfo.name}List($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {
$!{tableInfo.name} entity = $!tool.firstLowerCase($!{tableInfo.name});
return ($!{tool.firstLowerCase($!{tableInfo.name})}Mapper.select$!{tableInfo.name}List(entity));
}
/**
* 新增数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 受影响的行数,新增成功通常返回1,失败返回0等
*/
@Override
public int insert$!{tableInfo.name}($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {
$!{tableInfo.name} entity = $!tool.firstLowerCase($!{tableInfo.name});
entity.setCreateTime(DateUtils.getNowDate());
return ($!{tool.firstLowerCase($!{tableInfo.name})}Mapper.insert$!{tableInfo.name}(entity));
}
/**
* 修改数据
*
* @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
* @return 受影响的行数,一般成功修改返回1
*/
@Override
public int update$!{tableInfo.name}($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {
$!{tableInfo.name} entity = $!tool.firstLowerCase($!{tableInfo.name});
entity.setUpdateTime(DateUtils.getNowDate());
return ($!{tool.firstLowerCase($!{tableInfo.name})}Mapper.update$!{tableInfo.name}(entity));
}
/**
* 批量删除数据
*
* @param ids 需要删除的主键数组
* @return 受影响的行数,即成功删除的记录数
*/
@Override
public int delete$!{tableInfo.name}ByIds(Long[] ids) {
return ($!{tool.firstLowerCase($!{tableInfo.name})}Mapper.delete$!{tableInfo.name}ByIds(ids));
}
/**
* 通过主键删除数据
*
* @param id 主键
* @return 是否成功(以受影响行数判断,成功返回1等)
*/
@Override
public int delete$!{tableInfo.name}ById(Long id) {
return ($!{tool.firstLowerCase($!{tableInfo.name})}Mapper.delete$!{tableInfo.name}ById(id));
}
}
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}Result">
#foreach($column in $tableInfo.fullColumn)
<result property="$!column.name" column="$!column.obj.name" />
#end
</resultMap>
<!-- 基本字段 -->
<sql id="select$!{tableInfo.name}Vo">
#allSqlColumn()
</sql>
<select id="select$!{tableInfo.name}ById" resultMap="$!{tableInfo.name}Result">
<include refid="select$!{tableInfo.name}Vo"/>
where $!pk.obj.name = #{$!pk.name}
</select>
<select id="select$!{tableInfo.name}List" resultMap="$!{tableInfo.name}Result">
select #allSqlColumn() from $!{tableInfo.obj.getName()}
<where>
#foreach($column in $tableInfo.fullColumn)
#if($column.comment.endsWith("LIKE"))
<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>
#else
<if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">and $!column.obj.name = #{$!column.name} </if>
#end
#end
</where>
</select>
<insert id="insert$!{tableInfo.name}" useGeneratedKeys="true" keyProperty="id" >
insert into $!{tableInfo.obj.name}
<trim prefix="(" suffix=")" suffixOverrides=",">
#foreach($column in $tableInfo.fullColumn)
<if test="$!{column.name} != null">$!column.obj.name,</if>
#end
</trim>
values
<trim prefix="(" suffix=")" suffixOverrides=",">
#foreach($column in $tableInfo.fullColumn)
<if test="$!{column.name} != null">#{$!{column.name}},</if>
#end
</trim>
</insert>
<update id="update$!{tableInfo.name}" >
update $!{tableInfo.obj.name}
<trim prefix="SET" suffixOverrides=",">
#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
</trim>
where $!pk.obj.name = #{$!pk.name}
</update>
<!--通过id单个删除-->
<delete id="delete$!{tableInfo.name}ById" >
delete from $!tableInfo.obj.name
where $!pk.obj.name = #{$!pk.name}
</delete>
<!--通过id批量删除-->
<delete id="delete$!{tableInfo.name}ByIds" parameterType="String">
delete from $!{tableInfo.obj.name} where $!pk.obj.name in
<foreach item="$!pk.name" collection="array" open="(" separator="," close=")">
#{$!pk.name}
</foreach>
</delete>
</mapper>