前言
欢迎使用本代码生成模板，该模板旨在帮助开发者快速生成符合项目需求的Java实体类代码。通过本模板，开发者可以减少手动编写样板代码的时间，提高开发效率，同时保持代码的一致性和准确性。
声明：本模板为自用模板，并不适用所有场景，请自行甄别
版本信息
- IDEA：2024.2.3 中文版
- EasyCode：1.2.9
使用方法
要使用本模板，请按照以下步骤操作：
- 确保你的IDE支持EasyCode插件。
- 安装并启用EasyCode插件。
- 配置数据库连接信息。
- 选择适当的数据库表。
- 应用本模板并生成代码。
模板配置
1.代码导入
entity.java
##导入宏定义
$!{define.vm}
##保存文件（宏定义）
#save("/entity", ".java")
##包路径（宏定义）
#setPackageSuffix("entity")
##自动导入包（全局变量）
$!{autoImport.vm}
$!{autoImport.vm}
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.Builder;
import lombok.NoArgsConstructor;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import java.io.Serializable;
import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.IdType;
import com.fasterxml.jackson.annotation.JsonFormat;
import org.springframework.format.annotation.DateTimeFormat;
##表注释（宏定义）
#tableComment("表实体类")
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@TableName("$!{tableInfo.obj.name}")
@ApiModel(description = "${tableInfo.comment}")
public class $!{tableInfo.name} implements Serializable {
private static final long serialVersionUID = 1L;
##获取主键
#foreach($column in $tableInfo.pkColumn)
#if(${column.comment})
/**
* ${column.comment}
*/
#end
#if($column.name.equals("id"))
##根据数据库主键类型生成对应type
#if($column.shortType.equals("Integer"))
##IdType.AUTO：数据库自增
@TableId(value = "$column.name", type = IdType.AUTO)
#elseif($column.shortType.equals("Long"))
##IdType.ASSIGN_ID：雪花算法
@TableId(value = "$column.name", type = IdType.ASSIGN_ID)
#end
@ApiModelProperty("主键")
#else
@TableId
@ApiModelProperty("$column.comment")
#end
private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
#end
##其他字段
#foreach($column in $tableInfo.otherColumn)
#if(${column.comment})
/**
* ${column.comment}
*/
#end
#if($column.type.equals("java.util.Date"))
@DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern="yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
#end
#if(${column.comment})
@ApiModelProperty("$column.comment")
#end
private $!{tool.getClsNameByFullName($column.type)} $!{column.name};
#end
#foreach($column in $tableInfo.fullColumn)
#end
}
controller.java
##导入宏定义
$!{define.vm}
##设置表后缀（宏定义）
#setTableSuffix("Controller")
##保存文件（宏定义）
#save("/controller", "Controller.java")
##包路径（宏定义）
#setPackageSuffix("controller")
##定义服务名
#set($serviceName = $!tool.append($!tool.firstLowerCase($!tableInfo.name), "Service"))
##定义实体对象名
#set($entityName = $!tool.firstLowerCase($!tableInfo.name))
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import $!{tableInfo.savePackageName}.entity.$!tableInfo.name;
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import org.springframework.web.bind.annotation.*;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import java.io.Serializable;
import java.util.List;
##表注释（宏定义）
#tableComment("表控制层")
@Slf4j
@RestController
@Api("${tableInfo.comment}")
@RequestMapping("/$!tool.firstLowerCase($!tableInfo.name)")
public class $!{tableName}{
/**
* 服务对象
*/
@Autowired
private $!{tableInfo.name}Service $!{serviceName};
/**
* 分页查询所有数据
*
* @param page 分页对象
* @param $!entityName 查询实体
* @return 所有数据
*/
@ApiOperation("分页查询")
@GetMapping("/page")
public R selectAll(Page<$!tableInfo.name> page, $!tableInfo.name $!entityName) {
return R.success(this.$!{serviceName}.page(page, new QueryWrapper<>($!entityName)));
}
/**
* 通过主键查询单条数据
*
* @param id 主键
* @return 单条数据
*/
@ApiOperation("主键查询")
@GetMapping("{id}")
public R selectOne(@PathVariable Serializable id) {
return R.success(this.$!{serviceName}.getById(id));
}
/**
* 新增数据
*
* @param $!entityName 实体对象
* @return 新增结果
*/
@ApiOperation("新增数据")
@PostMapping("/add")
public R insert(@RequestBody $!tableInfo.name $!entityName) {
return R.success(this.$!{serviceName}.save($!entityName));
}
/**
* 修改数据
*
* @param $!entityName 实体对象
* @return 修改结果
*/
@ApiOperation("修改数据")
@PutMapping
public R update(@RequestBody $!tableInfo.name $!entityName) {
return R.success(this.$!{serviceName}.updateById($!entityName));
}
/**
* 删除数据
*
* @param idList 主键结合
* @return 删除结果
*/
@ApiOperation("删除数据")
@DeleteMapping
public R delete(@RequestParam("idList") List<Long> idList) {
return R.success(this.$!{serviceName}.removeByIds(idList));
}
}
service.java
##导入宏定义
$!{define.vm}
##设置表后缀（宏定义）
#setTableSuffix("Service")
##保存文件（宏定义）
#save("/service", "Service.java")
##包路径（宏定义）
#setPackageSuffix("service")
import com.baomidou.mybatisplus.extension.service.IService;
import $!{tableInfo.savePackageName}.entity.$!tableInfo.name;
##表注释（宏定义）
#tableComment("表服务接口")
public interface $!{tableName} extends IService<$!tableInfo.name> {
}
serviceImpl.java
##导入宏定义
$!{define.vm}
##设置表后缀（宏定义）
#setTableSuffix("ServiceImpl")
##保存文件（宏定义）
#save("/service/impl", "ServiceImpl.java")
##包路径（宏定义）
#setPackageSuffix("service.impl")
##定义Mapper服务名
#set($mapperName = $!tool.append($!tool.firstLowerCase($!tableInfo.name), "Mapper"))
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;
import $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};
import $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;
import org.springframework.stereotype.Service;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
##表注释（宏定义）
#tableComment("表服务实现类")
@Slf4j
@Service("$!tool.firstLowerCase($tableInfo.name)Service")
public class $!{tableName} extends ServiceImpl<$!{tableInfo.name}Mapper, $!{tableInfo.name}> implements $!{tableInfo.name}Service {
@Autowired
private $!{tableInfo.name}Mapper $!{mapperName};
}
mapper.java
##导入宏定义
$!{define.vm}
##设置表后缀（宏定义）
#setTableSuffix("Mapper")
##保存文件（宏定义）
#save("/mapper", "Mapper.java")
##包路径（宏定义）
#setPackageSuffix("mapper")
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import $!{tableInfo.savePackageName}.entity.$!tableInfo.name;
import org.apache.ibatis.annotations.Mapper;
##表注释（宏定义）
#tableComment("表数据库访问层")
@Mapper
public interface $!{tableName} extends BaseMapper<$!tableInfo.name> {
}
mapper.xml
1.使用mybatis-plus模板并不建议生成mapper.xml文件，mapper.xml优先级更高容易覆盖mybatis-plus自带的sql方法
2.如果运行程序提示某个你并未使用的字段不存在，可以试试修改或删除这个文件再次运行
##引入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}.entity.$!{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.name
where $!pk.obj.name = #{$!pk.name}
</select>
<!--查询指定行数据-->
<select id="queryAllByLimit" 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>
limit #{pageable.offset}, #{pageable.pageSize}
</select>
<!--统计总行数-->
<select id="count" resultType="java.lang.Long">
select count(1)
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 id="insert" keyProperty="$!pk.name" useGeneratedKeys="true">
insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($foreach.hasNext), #end#end)
values (#foreach($column in $tableInfo.otherColumn)#{$!{column.name}}#if($foreach.hasNext), #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($foreach.hasNext), #end#end)
values
<foreach collection="entities" item="entity" separator=",">
(#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($foreach.hasNext), #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($foreach.hasNext), #end#end)
values
<foreach collection="entities" item="entity" separator=",">
(#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($foreach.hasNext), #end#end)
</foreach>
on duplicate key update
#foreach($column in $tableInfo.otherColumn)$!column.obj.name = values($!column.obj.name)#if($foreach.hasNext),
#end#end
</insert>
<!--通过主键修改数据-->
<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 id="deleteById">
delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}
</delete>
</mapper>
2.本地导入
使用方法： 1. 新建一个文件，命名为EasyCodeConfig.json（.json为文件类型）
-
将下面的代码复制到文件中，保存
- 打开IDEA，文件—设置—其他设置—EasyCode—从本地导入—选择EasyCodeConfig.json，确认（IDEA版本：2024.2.3 中文版）
{
"author" : "Zhangr132",
"version" : "1.2.8",
"userSecure" : "",
"currTypeMapperGroupName" : "Default",
"currTemplateGroupName" : "MybatisPlus-Zhangr",
"currColumnConfigGroupName" : "Default",
"currGlobalConfigGroupName" : "Default",
"typeMapper" : {
"zhangr" : {
"name" : "zhangr",
"elementList" : [ {
"matchType" : "REGEX",
"columnType" : "varchar(\(\d+\))?",
"javaType" : "java.lang.String"
}, {
"matchType" : "REGEX",
"columnType" : "char(\(\d+\))?",
"javaType" : "java.lang.String"
}, {
"matchType" : "REGEX",
"columnType" : "(tiny|medium|long)*text",
"javaType" : "java.lang.String"
}, {
"matchType" : "REGEX",
"columnType" : "decimal(\(\d+,\d+\))?",
"javaType" : "java.math.BigDecimal"
}, {
"matchType" : "ORDINARY",
"columnType" : "integer",
"javaType" : "java.lang.Integer"
}, {
"matchType" : "REGEX",
"columnType" : "(tiny|small|medium)*int(\(\d+\))?",
"javaType" : "java.lang.Integer"
}, {
"matchType" : "ORDINARY",
"columnType" : "int4",
"javaType" : "java.lang.Integer"
}, {
"matchType" : "ORDINARY",
"columnType" : "int8",
"javaType" : "java.lang.Long"
}, {
"matchType" : "REGEX",
"columnType" : "bigint(\(\d+\))?",
"javaType" : "java.lang.Long"
}, {
"matchType" : "ORDINARY",
"columnType" : "date",
"javaType" : "java.util.Date"
}, {
"matchType" : "ORDINARY",
"columnType" : "datetime",
"javaType" : "java.util.Date"
}, {
"matchType" : "ORDINARY",
"columnType" : "timestamp",
"javaType" : "java.util.Date"
}, {
"matchType" : "ORDINARY",
"columnType" : "time",
"javaType" : "java.time.LocalTime"
}, {
"matchType" : "ORDINARY",
"columnType" : "boolean",
"javaType" : "java.lang.Boolean"
} ]
}
},
"template" : {
"MybatisPlus-Zhangr" : {
"name" : "MybatisPlus-Zhangr",
"elementList" : [ {
"name" : "controller.java.vm",
"code" : "##导入宏定义\n$!{define.vm}\n\n##设置表后缀（宏定义）\n#setTableSuffix("Controller")\n\n##保存文件（宏定义）\n#save("/controller", "Controller.java")\n\n##包路径（宏定义）\n#setPackageSuffix("controller")\n\n##定义服务名\n#set($serviceName = $!tool.append($!tool.firstLowerCase($!tableInfo.name), "Service"))\n\n##定义实体对象名\n#set($entityName = $!tool.firstLowerCase($!tableInfo.name))\n\nimport com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;\nimport com.baomidou.mybatisplus.extension.plugins.pagination.Page;\nimport $!{tableInfo.savePackageName}.entity.$!tableInfo.name;\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\nimport org.springframework.web.bind.annotation.*;\nimport io.swagger.annotations.Api;\nimport io.swagger.annotations.ApiOperation;\nimport lombok.extern.slf4j.Slf4j;\nimport org.springframework.beans.factory.annotation.Autowired;\n\nimport java.io.Serializable;\nimport java.util.List;\n\n##表注释（宏定义）\n#tableComment("表控制层")\n@Slf4j\n@RestController\n@Api("${tableInfo.comment}")\n@RequestMapping("/$!tool.firstLowerCase($!tableInfo.name)")\npublic class $!{tableName}{\n /**\n * 服务对象\n */\n @Autowired\n private $!{tableInfo.name}Service $!{serviceName};\n\n /**\n * 分页查询所有数据\n *\n * @param page 分页对象\n * @param $!entityName 查询实体\n * @return 所有数据\n */\n @ApiOperation("分页查询")\n @GetMapping("/page")\n public R selectAll(Page<$!tableInfo.name> page, $!tableInfo.name $!entityName) {\n return R.success(this.$!{serviceName}.page(page, new QueryWrapper<>($!entityName)));\n }\n\n /**\n * 通过主键查询单条数据\n *\n * @param id 主键\n * @return 单条数据\n */\n @ApiOperation("主键查询")\n @GetMapping("{id}")\n public R selectOne(@PathVariable Serializable id) {\n return R.success(this.$!{serviceName}.getById(id));\n }\n\n /**\n * 新增数据\n *\n * @param $!entityName 实体对象\n * @return 新增结果\n */\n @ApiOperation("新增数据")\n @PostMapping("/add")\n public R insert(@RequestBody $!tableInfo.name $!entityName) {\n return R.success(this.$!{serviceName}.save($!entityName));\n }\n\n /**\n * 修改数据\n *\n * @param $!entityName 实体对象\n * @return 修改结果\n */\n @ApiOperation("修改数据")\n @PutMapping\n public R update(@RequestBody $!tableInfo.name $!entityName) {\n return R.success(this.$!{serviceName}.updateById($!entityName));\n }\n\n /**\n * 删除数据\n *\n * @param idList 主键结合\n * @return 删除结果\n */\n @ApiOperation("删除数据")\n @DeleteMapping\n public R delete(@RequestParam("idList") List<Long> idList) {\n return R.success(this.$!{serviceName}.removeByIds(idList));\n }\n}\n"
}, {
"name" : "entity.java.vm",
"code" : "##导入宏定义\n$!{define.vm}\n\n##保存文件（宏定义）\n#save("/entity", ".java")\n\n##包路径（宏定义）\n#setPackageSuffix("entity")\n\n##自动导入包（全局变量）\n$!{autoImport.vm}\n$!{autoImport.vm}\nimport lombok.AllArgsConstructor;\nimport lombok.Data;\nimport lombok.Builder;\nimport lombok.NoArgsConstructor;\nimport io.swagger.annotations.ApiModel;\nimport io.swagger.annotations.ApiModelProperty;\nimport java.io.Serializable;\nimport com.baomidou.mybatisplus.annotation.TableName;\nimport com.baomidou.mybatisplus.annotation.TableId;\nimport com.baomidou.mybatisplus.annotation.IdType;\nimport com.fasterxml.jackson.annotation.JsonFormat;\nimport org.springframework.format.annotation.DateTimeFormat;\n\n##表注释（宏定义）\n#tableComment("表实体类")\n@Data\n@Builder\n@AllArgsConstructor\n@NoArgsConstructor\n@TableName("$!{tableInfo.obj.name}")\n@ApiModel(description = "${tableInfo.comment}")\npublic class $!{tableInfo.name} implements Serializable {\n private static final long serialVersionUID = 1L;\n##获取主键\n#foreach($column in $tableInfo.pkColumn)\n #if(${column.comment})\n /**\n * ${column.comment}\n */\n #end\n \n #if($column.name.equals("id"))\n##根据数据库主键类型生成对应type\n #if($column.shortType.equals("integer"))\n##IdType.AUTO：数据库自增\n @TableId(value = "$column.name", type = IdType.AUTO)\n #elseif($column.shortType.equals("Long"))\n##IdType.ASSIGN_ID：雪花算法\n @TableId(value = "$column.name", type = IdType.ASSIGN_ID)\n #end\n @ApiModelProperty("主键")\n #else\n @TableId\n @ApiModelProperty("$column.comment")\n #end\n private $!{tool.getClsNameByFullName($column.type)} $!{column.name};\n#end\n##其他字段\n#foreach($column in $tableInfo.otherColumn)\n\n #if(${column.comment})\n /**\n * ${column.comment}\n */\n #end\n #if($column.type.equals("java.util.Date"))\n @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")\n @JsonFormat(pattern="yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")\n #end\n @ApiModelProperty("$column.comment")\n private $!{tool.getClsNameByFullName($column.type)} $!{column.name};\n#end\n\n#foreach($column in $tableInfo.fullColumn)\n#end\n}"
}, {
"name" : "mapper.java.vm",
"code" : "##导入宏定义\n$!{define.vm}\n\n##设置表后缀（宏定义）\n#setTableSuffix("Mapper")\n\n##保存文件（宏定义）\n#save("/mapper", "Mapper.java")\n\n##包路径（宏定义）\n#setPackageSuffix("mapper")\n\nimport com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport $!{tableInfo.savePackageName}.entity.$!tableInfo.name;\nimport org.apache.ibatis.annotations.Mapper;\n\n##表注释（宏定义）\n#tableComment("表数据库访问层")\n@Mapper\npublic interface $!{tableName} extends BaseMapper<$!tableInfo.name> {\n\n}\n"
}, {
"name" : "mapper.xml.vm",
"code" : "##引入mybatis支持\n$!{mybatisSupport.vm}\n\n##设置保存名称与保存位置\n$!callback.setFileName($tool.append($!{tableInfo.name}, "Mapper.xml"))\n$!callback.setSavePath($tool.append($modulePath, "/src/main/resources/mapper"))\n\n##拿到主键\n#if(!$tableInfo.pkColumn.isEmpty())\n #set($pk = $tableInfo.pkColumn.get(0))\n#end\n\n<?xml version="1.0" encoding="UTF-8"?>\n<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">\n<mapper namespace="$!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper">\n\n <resultMap type="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}" id="$!{tableInfo.name}Map">\n#foreach($column in $tableInfo.fullColumn)\n <result property="$!column.name" column="$!column.obj.name" jdbcType="$!column.ext.jdbcType"/>\n#end\n </resultMap>\n\n <!--查询单个-->\n <select id="queryById" resultMap="$!{tableInfo.name}Map">\n select\n #allSqlColumn()\n\n from $!tableInfo.obj.name\n where $!pk.obj.name = #{$!pk.name}\n </select>\n\n <!--查询指定行数据-->\n <select id="queryAllByLimit" resultMap="$!{tableInfo.name}Map">\n select\n #allSqlColumn()\n\n from $!tableInfo.obj.name\n <where>\n#foreach($column in $tableInfo.fullColumn)\n <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">\n and $!column.obj.name = #{$!column.name}\n </if>\n#end\n </where>\n limit #{pageable.offset}, #{pageable.pageSize}\n </select>\n\n <!--统计总行数-->\n <select id="count" resultType="java.lang.Long">\n select count(1)\n from $!tableInfo.obj.name\n <where>\n#foreach($column in $tableInfo.fullColumn)\n <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">\n and $!column.obj.name = #{$!column.name}\n </if>\n#end\n </where>\n </select>\n\n <!--新增所有列-->\n <insert id="insert" keyProperty="$!pk.name" useGeneratedKeys="true">\n insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($foreach.hasNext), #end#end)\n values (#foreach($column in $tableInfo.otherColumn)#{$!{column.name}}#if($foreach.hasNext), #end#end)\n </insert>\n\n <insert id="insertBatch" keyProperty="$!pk.name" useGeneratedKeys="true">\n insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($foreach.hasNext), #end#end)\n values\n <foreach collection="entities" item="entity" separator=",">\n (#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($foreach.hasNext), #end#end)\n </foreach>\n </insert>\n\n <insert id="insertOrUpdateBatch" keyProperty="$!pk.name" useGeneratedKeys="true">\n insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($foreach.hasNext), #end#end)\n values\n <foreach collection="entities" item="entity" separator=",">\n (#foreach($column in $tableInfo.otherColumn)#{entity.$!{column.name}}#if($foreach.hasNext), #end#end)\n </foreach>\n on duplicate key update\n #foreach($column in $tableInfo.otherColumn)$!column.obj.name = values($!column.obj.name)#if($foreach.hasNext),\n #end#end\n\n </insert>\n\n <!--通过主键修改数据-->\n <update id="update">\n update $!{tableInfo.obj.name}\n <set>\n#foreach($column in $tableInfo.otherColumn)\n <if test="$!column.name != null#if($column.type.equals("java.lang.String")) and $!column.name != ''#end">\n $!column.obj.name = #{$!column.name},\n </if>\n#end\n </set>\n where $!pk.obj.name = #{$!pk.name}\n </update>\n\n <!--通过主键删除-->\n <delete id="deleteById">\n delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}\n </delete>\n\n</mapper>\n"
}, {
"name" : "service.java.vm",
"code" : "##导入宏定义\n$!{define.vm}\n\n##设置表后缀（宏定义）\n#setTableSuffix("Service")\n\n##保存文件（宏定义）\n#save("/service", "Service.java")\n\n##包路径（宏定义）\n#setPackageSuffix("service")\n\nimport com.baomidou.mybatisplus.extension.service.IService;\nimport $!{tableInfo.savePackageName}.entity.$!tableInfo.name;\n\n##表注释（宏定义）\n#tableComment("表服务接口")\npublic interface $!{tableName} extends IService<$!tableInfo.name> {\n\n}\n"
}, {
"name" : "serviceImpl.java.vm",
"code" : "##导入宏定义\n$!{define.vm}\n\n##设置表后缀（宏定义）\n#setTableSuffix("ServiceImpl")\n\n##保存文件（宏定义）\n#save("/service/impl", "ServiceImpl.java")\n\n##包路径（宏定义）\n#setPackageSuffix("service.impl")\n\n##定义Mapper服务名\n#set($mapperName = $!tool.append($!tool.firstLowerCase($!tableInfo.name), "Mapper"))\n\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\nimport org.springframework.stereotype.Service;\nimport lombok.extern.slf4j.Slf4j;\nimport org.springframework.beans.factory.annotation.Autowired;\n\n##表注释（宏定义）\n#tableComment("表服务实现类")\n@Slf4j\n@Service("$!tool.firstLowerCase($tableInfo.name)Service")\npublic class $!{tableName} extends ServiceImpl<$!{tableInfo.name}Mapper, $!{tableInfo.name}> implements $!{tableInfo.name}Service {\n @Autowired\n private $!{tableInfo.name}Mapper $!{mapperName};\n \n}\n"
} ]
}
},
"columnConfig" : { },
"globalConfig" : { }
}
