init
##初始化区域
##去掉表的t_前缀
#if($tableInfo.obj.name.startsWith("demo_"))
$!tableInfo.setName($tool.getClassName($tableInfo.obj.name.substring(5)))
#end
#set($prefixName = $tool.getClassName($tableInfo.obj.name.split("_")[0]))
##参考阿里巴巴开发手册,POJO 类中布尔类型的变量,都不要加 is 前缀,否则部分框架解析会引起序列化错误
#foreach($column in $tableInfo.fullColumn)
#if($column.name.startsWith("is") && $column.type.equals("java.lang.Boolean"))
$!column.setName($tool.firstLowerCase($column.name.substring(2)))
#end
#end
##实现动态排除列
#set($temp = $tool.newHashSet("testCreateTime", "otherColumn"))
#foreach($item in $temp)
#set($newList = $tool.newArrayList())
#foreach($column in $tableInfo.fullColumn)
#if($column.name!=$item)
##带有反回值的方法调用时使用$tool.call来消除返回值
$tool.call($newList.add($column))
#end
#end
##重新保存
$tableInfo.setFullColumn($newList)
#end
##对importList进行篡改
#set($temp = $tool.newHashSet())
#foreach($column in $tableInfo.fullColumn)
#if(!$column.type.startsWith("java.lang."))
##带有反回值的方法调用时使用$tool.call来消除返回值
$tool.call($temp.add($column.type))
#end
#end
##覆盖
#set($importList = $temp)
DO.java
##引入宏定义
$!init
$!define
##使用宏定义设置回调(保存位置与文件后缀)
#save("/domain", ".java")
##使用宏定义设置包后缀
#setPackageSuffix("domain")
##定义初始变量
#set($modelName = $tool.append($!{tableInfo.name}, "DO"))
##设置回调
$!callback.setFileName($tool.append($modelName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/domain"))
##使用全局变量实现默认包导入
$!autoImport
import com.seal.mall.common.util.AbstractObject;
import java.io.Serializable;
import lombok.ToString;
import lombok.Data;
##使用全局变量实现默认包导入
/**
* @program: seal
* @description: $!{tableInfo.comment}($!{tableInfo.name})DO类
* @author: Kenny.Qiu
* @create: $!time.currTime()
*/
@Data
@ToString
public class ${modelName} extends AbstractObject {
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
}
DTO.java
##引入宏定义
$!init
$!define
##定义初始变量
#set($modelName = $tool.append($!{tableInfo.name}, "DTO"))
##设置回调
$!callback.setFileName($tool.append($modelName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/domain/dto"))
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}domain.dto;
##使用全局变量实现默认包导入
$!autoImport
import com.seal.mall.common.util.AbstractObject;
import java.io.Serializable;
import lombok.ToString;
import lombok.Data;
##使用全局变量实现默认包导入
/**
* @program: seal
* @description: $!{tableInfo.comment}($!{tableInfo.name})DTO类
* @author: Kenny.Qiu
* @create: $!time.currTime()
*/
@Data
@ToString
public class ${modelName} extends AbstractObject {
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
}
VO.java
##引入宏定义
$!init
$!define
##定义初始变量
#set($modelName = $tool.append($!{tableInfo.name}, "VO"))
##设置回调
$!callback.setFileName($tool.append($modelName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/domain/vo"))
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}domain.vo;
##使用全局变量实现默认包导入
$!autoImport
import com.seal.mall.common.util.AbstractObject;
import io.swagger.annotations.ApiModelProperty;
import java.io.Serializable;
import lombok.ToString;
import lombok.Data;
##使用全局变量实现默认包导入
/**
* @program: seal
* @description: $!{tableInfo.comment}($!{tableInfo.name})VO类
* @author: Kenny.Qiu
* @create: $!time.currTime()
*/
@Data
@ToString
public class ${modelName} extends AbstractObject {
private static final long serialVersionUID = $!tool.serial();
#foreach($column in $tableInfo.fullColumn)
#if(${column.comment})
@ApiModelProperty(value = "${column.comment}")
#end
private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
#end
#foreach($column in $tableInfo.fullColumn)
##使用宏定义实现get,set方法
##getSetMethod($column)
#end
}
Query.java
##引入宏定义
$!init
$!define
##定义初始变量
#set($modelName = $tool.append($!{tableInfo.name}, "Query"))
##设置回调
$!callback.setFileName($tool.append($modelName, ".java"))
$!callback.setSavePath($tool.append($tableInfo.savePath, "/domain/query"))
#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}domain.query;
##使用全局变量实现默认包导入
$!autoImport
import com.seal.mall.common.util.AbstractObject;
import io.swagger.annotations.ApiModelProperty;
import java.io.Serializable;
import lombok.ToString;
import lombok.Data;
##使用全局变量实现默认包导入
/**
* @program: seal
* @description: $!{tableInfo.comment}($!{tableInfo.name})Query类
* @author: Kenny.Qiu
* @create: $!time.currTime()
*/
@Data
@ToString
public class ${modelName} extends AbstractObject {
private static final long serialVersionUID = $!tool.serial();
@ApiModelProperty(value = "分页查询起始位置")
private Integer offset;
@ApiModelProperty(value = "每页查询记录数")
private Integer size;
}
Mapper.java
##引入宏定义
$!init
$!define
##定义初始变量
#set($tableName = $tool.append($tableInfo.name, "Mapper"))
#set($tableNameDO = $tool.append($tableInfo.name, "DO"))
#set($tableNameQuery = $tool.append($tableInfo.name, "Query"))
##设置回调
$!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;
##使用全局变量实现默认包导入
$!autoImport
import $!{tableInfo.savePackageName}.domain.query.$!{tableNameQuery};
import $!{tableInfo.savePackageName}.domain.$!{tableNameDO};
import com.seal.mall.common.domain.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
##使用全局变量实现默认包导入
/**
* @program: seal
* @description: $!{tableInfo.comment}($!{tableInfo.name})Mapper组件接口
* @author: Kenny.Qiu
* @create: $!time.currTime()
*/
@Mapper
public interface $!{tableName} extends BaseMapper<$!{tableNameDO}, $!{tableNameQuery}> {
}
Mapper.xml
##引入宏定义
$!init
##引入mybatis支持
$!mybatisSupport
##设置保存名称与保存位置
$!callback.setFileName($tool.append($!{tableInfo.name}, "Mapper.xml"))
$!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper/",$tool.firstLowerCase($prefixName)))
#set($modelName = $tool.append($!{tableInfo.name}, "DO"))
#set($modelNameDO = $tool.append($!{tableInfo.name}, "DO"))
#set($modelNameQuery = $tool.append($!{tableInfo.name}, "Query"))
##拿到主键
#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}.model.$!{modelName}" id="$!{tableInfo.name}Map">
<resultMap type="$!{tableInfo.savePackageName}.domain.$!{modelName}" id="BaseResultMap">
#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>
<!-- 分页查询 -->
<select id="listByPage" parameterType="$!{tableInfo.savePackageName}.domain.query.$!{modelNameQuery}"
resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from $!tableInfo.obj.name
limit #{offset},#{size}
</select>
<!-- 根据主键查询 -->
<select id="getById" parameterType="java.lang.Long" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from $!tableInfo.obj.name
where $!pk.obj.name = #{$!pk.name}
</select>
<!-- 新增 -->
<insert id="save" parameterType="$!{tableInfo.savePackageName}.domain.$!{modelNameDO}"
keyColumn="$!pk.obj.name" keyProperty="$!pk.obj.name" useGeneratedKeys="true">
insert into $!{tableInfo.obj.name}
(#foreach($column in $tableInfo.fullColumn)$!column.obj.name#if($velocityHasNext), #end#end)
values
( #foreach($column in $tableInfo.fullColumn)#{$!{column.name}}#if($velocityHasNext), #end#end)
</insert>
<!-- 更新 -->
<update id="update" parameterType="$!{tableInfo.savePackageName}.domain.$!{modelNameDO}">
UPDATE $!tableInfo.obj.name SET
#foreach($column in $tableInfo.fullColumn) $!column.obj.name=#{$!{column.name}}#if($velocityHasNext), #end#end