{
"author" : "ljj",
"version" : "1.2.6",
"userSecure" : "",
"currTypeMapperGroupName" : "Default",
"currTemplateGroupName" : "Default",
"currColumnConfigGroupName" : "Default",
"currGlobalConfigGroupName" : "Default",
"typeMapper" : {
"Default" : {
"name" : "Default",
"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.lang.Double"
}, {
"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" : {
"Default" : {
"name" : "Default",
"elementList" : [ {
"name" : "controller.java.vm",
"code" : "##定义初始变量\n#set($tableName = $tool.append($tableInfo.name, \"Controller\"))\n##设置回调\n$!callback.setFileName($tool.append($tableName, \".java\"))\n$!callback.setSavePath($tool.append($tableInfo.savePath, \"/controller\"))\n##拿到主键\n#if(!$tableInfo.pkColumn.isEmpty())\n #set($pk = $tableInfo.pkColumn.get(0))\n#end\n\n#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}controller;\n\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\n## 我的\nimport org.springframework.web.bind.annotation.*;\nimport $!{tableInfo.savePackageName}.common.R;\nimport javax.validation.Valid;\nimport io.swagger.annotations.Api;\nimport io.swagger.annotations.ApiOperation;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}DTO;\nimport $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}QueryVo;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}InsertDto;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}UpdateDto;\nimport java.util.List;\n\n/**\n * 控制层\n *\n * @author $!author\n * @since $!time.currTime()\n */\n@RestController\n@RequestMapping(\"/\")\n@Api(tags = {\"\"})\n@SuppressWarnings(\"unchecked\")\npublic class $!{tableName} {\n /**\n * 服务对象\n */\n @Autowired\n private $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;\n\t\n /**\n * 查询单条数据\n *\n * @param $!{tableInfo.name}Id 主键\n * @return 单条数据\n */\n @ApiOperation(value=\"通过id\",response = $!{tableInfo.name}QueryVo.class)\n @RequestMapping(value = \"/get$!{tableInfo.name}ById\", method = RequestMethod.GET)\n public R<$!{tableInfo.name}QueryVo> get$!{tableInfo.name}ById(@RequestParam(\"$!{tableInfo.name}Id\") String $!{tableInfo.name}Id) {\n return $!{tool.firstLowerCase($tableInfo.name)}Service.get$!{tableInfo.name}ById($!{tableInfo.name}Id);\n }\n \n /**\n * 通过参数查询列表数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}DTO 查询参数\n * @return 多条数据\n */\n @ApiOperation(value = \"查询列表数据\",response = $!{tableInfo.name}QueryVo.class)\n @RequestMapping(value = \"/query$!{tableInfo.name}List\", method = RequestMethod.POST)\n public R<List<$!{tableInfo.name}QueryVo>> query$!{tableInfo.name}List(@Valid @RequestBody $!{tableInfo.name}DTO $!{tool.firstLowerCase($tableInfo.name)}DTO) {\n return $!{tool.firstLowerCase($tableInfo.name)}Service.query$!{tableInfo.name}List($!{tool.firstLowerCase($tableInfo.name)}DTO);\n }\n \n /**\n * 通过参数添加数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}InsertDto 添加参数\n * @return True or False\n */\n @ApiOperation(value = \"添加数据\",response = Boolean.class)\n @RequestMapping(value = \"/insert$!{tableInfo.name}\", method = RequestMethod.POST)\n public R insert(@Valid @RequestBody $!{tableInfo.name}InsertDto $!{tool.firstLowerCase($tableInfo.name)}InsertDto) {\n return $!{tool.firstLowerCase($tableInfo.name)}Service.insert$!{tableInfo.name}($!{tool.firstLowerCase($tableInfo.name)}InsertDto);\n }\n \n /**\n * 通过参数修改数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}UpdateDto 修改参数\n * @return True or False\n */\n @ApiOperation(value = \"修改数据\",response = Boolean.class)\n @RequestMapping(value = \"/update$!{tableInfo.name}\", method = RequestMethod.POST)\n public R update$!{tableInfo.name}(@Valid @RequestBody $!{tableInfo.name}UpdateDto $!{tool.firstLowerCase($tableInfo.name)}UpdateDto) {\n return $!{tool.firstLowerCase($tableInfo.name)}Service.update$!{tableInfo.name}($!{tool.firstLowerCase($tableInfo.name)}UpdateDto);\n }\n \n /**\n * 删除单条数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}Id 主键\n * @return True or False\n */\n @ApiOperation(value = \"删除数据通过ID\",response = Boolean.class)\n @RequestMapping(value = \"/delete$!{tableInfo.name}ById\", method = RequestMethod.GET)\n public R delete$!{tableInfo.name}ById(@RequestParam(\"$!{tool.firstLowerCase($tableInfo.name)}Id\") String $!{tool.firstLowerCase($tableInfo.name)}Id) {\n return $!{tool.firstLowerCase($tableInfo.name)}Service.delete$!{tableInfo.name}ById($!{tool.firstLowerCase($tableInfo.name)}Id);\n }\n \n /**\n * 批量删除抄数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}Id 数组\n * @return 是否成功\n */\n @ApiOperation(value = \"批量删除数据\",response = Boolean.class)\n @RequestMapping(value = \"/delete$!{tableInfo.name}Batch\", method = RequestMethod.POST)\n public R delete$!{tableInfo.name}Batch(String[] $!{tool.firstLowerCase($tableInfo.name)}Id) {\n return $!{tool.firstLowerCase($tableInfo.name)}Service.delete$!{tableInfo.name}Batch($!{tool.firstLowerCase($tableInfo.name)}Id);\n }\n \n}\n"
}, {
"name" : "dao.java.vm",
"code" : "##定义初始变量\n#set($tableName = $tool.append($tableInfo.name, \"Mapper\"))\n##设置回调\n$!callback.setFileName($tool.append($tableName, \".java\"))\n$!callback.setSavePath($tool.append($tableInfo.savePath, \"/mapper\"))\n\n##拿到主键\n#if(!$tableInfo.pkColumn.isEmpty())\n #set($pk = $tableInfo.pkColumn.get(0))\n#end\n\n#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}mapper;\n\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name}Po;\n## 我的\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}DTO;\nimport $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}QueryVo;\nimport org.springframework.stereotype.Repository;\nimport java.util.List;\n\n/**\n * 数据库访问层\n *\n * @author $!author\n * @since $!time.currTime()\n */\n @Repository\npublic interface $!{tableName} {\n \n /**\n * 通过ID查询单条数据\n *\n * @param $!{tableInfo.name}Id 主键\n * @return 实例对象\n */\n $!{tableInfo.name}QueryVo get$!{tableInfo.name}ById(String $!{tableInfo.name}Id);\n \n /**\n * 通过条件查询多条数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}DTO 实例对象\n * @return 实例对象\n */\n List<$!{tableInfo.name}QueryVo> query$!{tableInfo.name}List($!{tableInfo.name}DTO $!{tool.firstLowerCase($tableInfo.name)}DTO);\n \n /**\n * 新增数据\n *\n * @param $!tool.firstLowerCase($!{tableInfo.name})Po 实例对象\n * @return 影响行数\n */\n int insert$!{tableInfo.name}($!{tableInfo.name}Po $!tool.firstLowerCase($!{tableInfo.name})Po);\n \n /**\n * 修改数据\n *\n * @param $!tool.firstLowerCase($!{tableInfo.name})Po 实例对象\n * @return 影响行数\n */\n int update$!{tableInfo.name}($!{tableInfo.name}Po $!tool.firstLowerCase($!{tableInfo.name})Po);\n \n /**\n * 通过主键删除数据\n *\n * @param $!{tool.firstLowerCase($!{tableInfo.name})}Id 主键\n * @return 影响行数\n */\n int delete$!{tableInfo.name}ById(String $!{tool.firstLowerCase($!{tableInfo.name})}Id);\n \n}\n"
}, {
"name" : "debug.json.vm",
"code" : "// 禁止将生成结果写入到文件\n$!callback.setWriteFile(false)\n\n//调试表原始对象\n$!tool.debug($tableInfo.obj)\n\n//调试列原始对象\n$!tool.debug($tableInfo.fullColumn.get(0).obj)\n\n//调试列原始列类型\n$!tool.debug($tableInfo.fullColumn.get(0).obj.dataType)\n\n//获取原始列类型中的字段\nsqlType = $!tool.getField($tableInfo.fullColumn.get(0).obj.dataType, \"typeName\")\n\n//执行原始列类型中的方法\nsqlTypeLen = $!tableInfo.fullColumn.get(0).obj.dataType.getLength()\n"
}, {
"name" : "entity.java.vm",
"code" : "##引入宏定义\n$!{define.vm}\n\n##使用宏定义设置回调(保存位置与文件后缀)\n#save(\"/entity\", \"Po.java\")\n\n##使用宏定义设置包后缀\n#setPackageSuffix(\"entity\")\n\n##使用全局变量实现默认包导入\n$!{autoImport.vm}\nimport java.io.Serializable;\n## 我的\nimport org.springframework.format.annotation.DateTimeFormat;\nimport lombok.Data;\nimport lombok.ToString;\nimport io.swagger.annotations.ApiModelProperty;\nimport com.fasterxml.jackson.annotation.JsonFormat;\nimport io.swagger.annotations.ApiModel;\n##使用宏定义实现类注释信息\n#tableComment(\"实体类\")\n@Data\npublic class $!{tableInfo.name}Po implements Serializable {\n private static final long serialVersionUID = $!tool.serial();\n#foreach($column in $tableInfo.fullColumn)\n #if(${column.comment})\n /**\n * ${column.comment}\n */#end\n\t\n #if($tool.newHashSet(\"java.util.Date\", \"java.sql.Timestamp\", \"java.time.Instant\", \"java.time.LocalDateTime\", \"java.time.OffsetDateTime\", \"\tjava.time.ZonedDateTime\").contains($column.type))\n @JsonFormat(pattern = \"yyyy-MM-dd HH:mm:ss\" ,timezone=\"GMT+8\")\n #end\n @ApiModelProperty(value = \"${column.comment}\")\n private $!{tool.getClsNameByFullName($column.type)} $!{column.name};\n#end\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 \n <!--查询单个-->\n <select id=\"get$!{tableInfo.name}ById\" resultType=\"$!{tableInfo.savePackageName}.vo.$!{tableInfo.name}QueryVo\">\n select\n #allSqlColumn()\n from $!tableInfo.obj.name\n where $!pk.obj.name = #{$!{tableInfo.name}Id}\n </select>\n \n <!--通过实体作为筛选条件查询-->\n <select id=\"query$!{tableInfo.name}List\" resultType=\"$!{tableInfo.savePackageName}.vo.$!{tableInfo.name}QueryVo\">\n select\n #allSqlColumn()\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$!{tableInfo.name}\">\n insert into $!{tableInfo.obj.name}(#foreach($column in $tableInfo.fullColumn)$!column.obj.name#if($velocityHasNext), #end#end)\n values (#foreach($column in $tableInfo.fullColumn)#{$!{column.name}}#if($velocityHasNext), #end#end)\n </insert>\n \n <!--通过主键修改数据-->\n <update id=\"update$!{tableInfo.name}\">\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=\"delete$!{tableInfo.name}ById\">\n update $!{tableInfo.obj.name} set DEL_STATE = '02'\n where $!pk.obj.name = #{$!pk.name}\n </delete>\n \n\n</mapper>\n"
}, {
"name" : "service.java.vm",
"code" : "##定义初始变量\n#set($tableName = $tool.append($tableInfo.name, \"Service\"))\n##设置回调\n$!callback.setFileName($tool.append($tableName, \".java\"))\n$!callback.setSavePath($tool.append($tableInfo.savePath, \"/service\"))\n\n##拿到主键\n#if(!$tableInfo.pkColumn.isEmpty())\n #set($pk = $tableInfo.pkColumn.get(0))\n#end\n\n#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service;\n\n## 我的\nimport $!{tableInfo.savePackageName}.common.R;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}DTO;\nimport $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}QueryVo;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}InsertDto;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}UpdateDto;\nimport java.util.List;\n\n/**\n * 服务接口\n *\n * @author $!author\n * @since $!time.currTime()\n */\npublic interface $!{tableName} {\n \n /**\n * 通过ID查询\n *\n * @param $!{tableInfo.name}Id 主键\n * @return 实例对象\n */\n R<$!{tableInfo.name}QueryVo> get$!{tableInfo.name}ById(String $!{tableInfo.name}Id);\n \n /**\n * 通过参数查询列表数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}DTO 查询参数\n * @return 实例对象\n */\n R<List<$!{tableInfo.name}QueryVo>> query$!{tableInfo.name}List($!{tableInfo.name}DTO $!{tool.firstLowerCase($tableInfo.name)}DTO);\n /**\n * 新增数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}InsertDto 实例对象\n * @return 实例对象\n */\n R insert$!{tableInfo.name}($!{tableInfo.name}InsertDto $!{tool.firstLowerCase($tableInfo.name)}InsertDto);\n \n /**\n * 修改数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}UpdateDto 实例对象\n * @return 实例对象\n */\n R update$!{tableInfo.name}($!{tableInfo.name}UpdateDto $!{tool.firstLowerCase($tableInfo.name)}UpdateDto);\n \n /**\n * 通过主键删除数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}Id 主键\n * @return 是否成功\n */\n R delete$!{tableInfo.name}ById(String $!{tool.firstLowerCase($tableInfo.name)}Id);\n \n /**\n * 批量删除数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}Id 数组\n * @return 是否成功\n */\n R delete$!{tableInfo.name}Batch(String[] $!{tool.firstLowerCase($tableInfo.name)}Id);\n \n}"
}, {
"name" : "serviceImpl.java.vm",
"code" : "##定义初始变量\n#set($tableName = $tool.append($tableInfo.name, \"ServiceImpl\"))\n##设置回调\n$!callback.setFileName($tool.append($tableName, \".java\"))\n$!callback.setSavePath($tool.append($tableInfo.savePath, \"/service/impl\"))\n\n##拿到主键\n#if(!$tableInfo.pkColumn.isEmpty())\n #set($pk = $tableInfo.pkColumn.get(0))\n#end\n\n#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service.impl;\n\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name}Po;\nimport $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\nimport org.springframework.stereotype.Service;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport $!{tableInfo.savePackageName}.common.R;\nimport $!{tableInfo.savePackageName}.common.ResultUtils;\n## 我的\nimport org.springframework.transaction.annotation.Transactional;\nimport cn.hutool.core.util.IdUtil;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}DTO;\nimport $!{tableInfo.savePackageName}.vo.$!{tableInfo.name}QueryVo;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}InsertDto;\nimport $!{tableInfo.savePackageName}.dto.$!{tableInfo.name}UpdateDto;\nimport java.util.List;\nimport $!{tableInfo.savePackageName}.utils.PageUtils;\nimport $!{tableInfo.savePackageName}.utils.BeanConvertUtils;\nimport com.github.pagehelper.PageInfo;\n\n/**\n * 服务实现类\n *\n * @author $!author\n * @since $!time.currTime()\n */\n@Service(\"$!tool.firstLowerCase($!{tableInfo.name})Service\")\npublic class $!{tableName} implements $!{tableInfo.name}Service {\n \n @Autowired\n private $!{tableInfo.name}Mapper $!tool.firstLowerCase($!{tableInfo.name})Mapper;\n \n /**\n * 通过ID查询\n *\n * @param Id 主键\n * @return 实例对象\n */\n @Override\n public R<$!{tableInfo.name}QueryVo> get$!{tableInfo.name}ById(String Id) {\n $!{tableInfo.name}QueryVo $!tool.firstLowerCase($!{tableInfo.name})QueryVO = $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.get$!{tableInfo.name}ById(Id);\n return ResultUtils.determineData($!tool.firstLowerCase($!{tableInfo.name})QueryVO,\"该ID不存在!\");\n }\n \n /**\n * 通过参数列表数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}DTO 查询参数\n * @return 实例对象\n */\n @Override\n public R<List<$!{tableInfo.name}QueryVo>> query$!{tableInfo.name}List($!{tableInfo.name}DTO $!{tool.firstLowerCase($tableInfo.name)}DTO){\n // 是否分页\n PageUtils.startPage($!{tool.firstLowerCase($tableInfo.name)}DTO.getPageNo(),$!{tool.firstLowerCase($tableInfo.name)}DTO.getPageSize());\n // 查询列表\n List<$!{tableInfo.name}QueryVo> $!tool.firstLowerCase($!{tableInfo.name})QueryVoList = $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.query$!{tableInfo.name}List($!{tool.firstLowerCase($tableInfo.name)}DTO);\n // 返回结果\n return PageUtils.resultPage($!tool.firstLowerCase($!{tableInfo.name})QueryVoList, (int) new PageInfo<>($!tool.firstLowerCase($!{tableInfo.name})QueryVoList).getTotal());\n }\n \n /**\n * 新增数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}InsertDto 实例对象\n * @return 实例对象\n */\n @Override\n @Transactional(rollbackFor = Exception.class)\n public R insert$!{tableInfo.name}($!{tableInfo.name}InsertDto $!{tool.firstLowerCase($tableInfo.name)}InsertDto) {\n String $!{tool.firstLowerCase($tableInfo.name)}Id = IdUtil.simpleUUID();\n // 转换成实体对象进行新增\n $!{tableInfo.name}Po $!tool.firstLowerCase($!{tableInfo.name})Po = BeanConvertUtils.convertTo($!{tool.firstLowerCase($tableInfo.name)}InsertDto, $!{tableInfo.name}Po::new, (x, y) -> {\n \n \n });\n int blag = $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.insert$!{tableInfo.name}($!tool.firstLowerCase($!{tableInfo.name})Po);\n \n return ResultUtils.determineBlag(blag,\"插入成功!\",\"插入失败!\");\n }\n \n /**\n * 修改数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}UpdateDto 实例对象\n * @return 实例对象\n */\n @Override\n @Transactional(rollbackFor = Exception.class)\n public R update$!{tableInfo.name}($!{tableInfo.name}UpdateDto $!{tool.firstLowerCase($tableInfo.name)}UpdateDto) {\n // 转换成实体对象进行修改\n $!{tableInfo.name}Po $!tool.firstLowerCase($!{tableInfo.name})Po = BeanConvertUtils.convertTo($!{tool.firstLowerCase($tableInfo.name)}UpdateDto, $!{tableInfo.name}Po::new);\n int blag = $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.update$!{tableInfo.name}($!tool.firstLowerCase($!{tableInfo.name})Po);\n \n return ResultUtils.determineBlag(blag,\"修改成功!\",\"修改失败!\");\n }\n \n /**\n * 通过主键删除数据\n *\n * @param $!{tool.firstLowerCase($!{tableInfo.name})}Id 主键\n * @return 是否成功\n */\n @Override\n @Transactional(rollbackFor = Exception.class)\n public R delete$!{tableInfo.name}ById(String $!{tool.firstLowerCase($!{tableInfo.name})}Id) {\n int blag = $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.delete$!{tableInfo.name}ById($!{tool.firstLowerCase($!{tableInfo.name})}Id);\n return ResultUtils.determineBlag(blag,\"删除成功!\",\"删除失败!\");\n }\n \n /**\n * 批量删除数据\n *\n * @param $!{tool.firstLowerCase($tableInfo.name)}Id 数组\n * @return 是否成功\n */\n @Override\n @Transactional(rollbackFor = Exception.class)\n public R delete$!{tableInfo.name}Batch(String[] $!{tool.firstLowerCase($tableInfo.name)}Id){\n for (int i = 0; i < $!{tool.firstLowerCase($tableInfo.name)}Id.length; i++) {\n $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.delete$!{tableInfo.name}ById($!{tool.firstLowerCase($tableInfo.name)}Id[i]);\n }\n return ResultUtils.success(\"批量删除成功\");\n }\n \n}"
}, {
"name" : "dto.java.vm",
"code" : "##引入宏定义\n$!{define.vm}\n\n##使用宏定义设置回调(保存位置与文件后缀)\n## #save(\"/entity\", \".java\")\n#save(\"/dto\", \"DTO.java\")\n\n##使用宏定义设置包后缀\n#setPackageSuffix(\"dto\")\n\n##使用全局变量实现默认包导入\n$!{autoImport.vm}\nimport java.io.Serializable;\n## 我的\nimport org.springframework.format.annotation.DateTimeFormat;\nimport lombok.Data;\nimport lombok.ToString;\nimport io.swagger.annotations.ApiModelProperty;\nimport com.fasterxml.jackson.annotation.JsonFormat;\nimport io.swagger.annotations.ApiModel;\nimport com.alibaba.excel.annotation.ExcelProperty; ## 1.0\n##使用宏定义实现类注释信息\n#tableComment(\"实体类\")\n@ApiModel(description = \"\")\n@Data\npublic class $!{tableInfo.name}DTO implements Serializable {\n private static final long serialVersionUID = $!tool.serial();\n /**\n * 分页大小\n **/\n @ApiModelProperty(value = \"分页大小\", position = -1, example = \"10\")\n private Integer pageSize;\n /**\n * 分页页码\n **/\n @ApiModelProperty(value = \"页码\", position = -1, example = \"1\")\n private Integer pageNo;\n \n#foreach($column in $tableInfo.fullColumn)\n #if(${column.comment})\n /**\n * ${column.comment}\n */#end\n\t\n #if($tool.newHashSet(\"java.util.Date\", \"java.sql.Timestamp\", \"java.time.Instant\", \"java.time.LocalDateTime\", \"java.time.OffsetDateTime\", \"\tjava.time.ZonedDateTime\").contains($column.type))\n @JsonFormat(pattern = \"yyyy-MM-dd HH:mm:ss\" ,timezone=\"GMT+8\")\n #end\n @ApiModelProperty(value = \"${column.comment}\")\n private $!{tool.getClsNameByFullName($column.type)} $!{column.name};\n#end\n\n}"
}, {
"name" : "queryvo.java.vm",
"code" : "##引入宏定义\n$!{define.vm}\n\n##使用宏定义设置回调(保存位置与文件后缀)\n#save(\"/vo\", \"QueryVo.java\")\n\n##使用宏定义设置包后缀\n#setPackageSuffix(\"vo\")\n\n##使用全局变量实现默认包导入\n$!{autoImport.vm}\nimport java.io.Serializable;\n## 我的\nimport org.springframework.format.annotation.DateTimeFormat;\nimport lombok.Data;\nimport lombok.ToString;\nimport io.swagger.annotations.ApiModelProperty;\nimport com.fasterxml.jackson.annotation.JsonFormat;\nimport io.swagger.annotations.ApiModel;\n##使用宏定义实现类注释信息\n#tableComment(\"实体类\")\n@ApiModel(description = \"返回参数\")\n@Data\npublic class $!{tableInfo.name}QueryVo implements Serializable {\n private static final long serialVersionUID = $!tool.serial();\n#foreach($column in $tableInfo.fullColumn)\n #if(${column.comment})\n /**\n * ${column.comment}\n */#end\n\t\n #if($tool.newHashSet(\"java.util.Date\", \"java.sql.Timestamp\", \"java.time.Instant\", \"java.time.LocalDateTime\", \"java.time.OffsetDateTime\", \"\tjava.time.ZonedDateTime\").contains($column.type))\n @DateTimeFormat\n @JsonFormat(pattern = \"yyyy-MM-dd HH:mm:ss\" ,timezone=\"GMT+8\")\n #end\n @ApiModelProperty(value = \"${column.comment}\")\n private $!{tool.getClsNameByFullName($column.type)} $!{column.name};\n#end\n\n}\n"
}, {
"name" : "QueryDto.java.vm",
"code" : "##引入宏定义\n$!{define.vm}\n\n##使用宏定义设置回调(保存位置与文件后缀)\n#save(\"/dto\", \"QueryDto.java\")\n\n##使用宏定义设置包后缀\n#setPackageSuffix(\"dto\")\n\n##使用全局变量实现默认包导入\n$!{autoImport.vm}\nimport java.io.Serializable;\n## 我的\nimport org.springframework.format.annotation.DateTimeFormat;\nimport lombok.Data;\nimport lombok.ToString;\nimport io.swagger.annotations.ApiModelProperty;\nimport com.fasterxml.jackson.annotation.JsonFormat;\nimport io.swagger.annotations.ApiModel;\n##使用宏定义实现类注释信息\n#tableComment(\"实体类\")\n@ApiModel(description = \"返回参数\")\n@Data\npublic class $!{tableInfo.name}QueryDto implements Serializable {\n private static final long serialVersionUID = $!tool.serial();\n /**\n * 分页大小\n **/\n @ApiModelProperty(value = \"分页大小\", position = -1, example = \"10\")\n private Integer pageSize;\n /**\n * 分页页码\n **/\n @ApiModelProperty(value = \"页码\", position = -1, example = \"1\")\n private Integer pageNo;\n#foreach($column in $tableInfo.fullColumn)\n \n #if(${column.comment})\n /**\n * ${column.comment}\n */#end\n\t\n #if($tool.newHashSet(\"java.util.Date\", \"java.sql.Timestamp\", \"java.time.Instant\", \"java.time.LocalDateTime\", \"java.time.OffsetDateTime\", \"\tjava.time.ZonedDateTime\").contains($column.type))\n @DateTimeFormat\n @JsonFormat(pattern = \"yyyy-MM-dd HH:mm:ss\" ,timezone=\"GMT+8\")\n #end\n @ApiModelProperty(value = \"${column.comment}\")\n private $!{tool.getClsNameByFullName($column.type)} $!{column.name};\n#end\n\n}\n"
}, {
"name" : "InsertDto.java.vm",
"code" : "##引入宏定义\n$!{define.vm}\n\n##使用宏定义设置回调(保存位置与文件后缀)\n#save(\"/dto\", \"InsertDto.java\")\n\n##使用宏定义设置包后缀\n#setPackageSuffix(\"dto\")\n\n##使用全局变量实现默认包导入\n$!{autoImport.vm}\nimport java.io.Serializable;\n## 我的\nimport org.springframework.format.annotation.DateTimeFormat;\nimport lombok.Data;\nimport lombok.ToString;\nimport io.swagger.annotations.ApiModelProperty;\nimport com.fasterxml.jackson.annotation.JsonFormat;\nimport io.swagger.annotations.ApiModel;\n##使用宏定义实现类注释信息\n#tableComment(\"实体类\")\n@ApiModel(description = \"新增参数\")\n@Data\npublic class $!{tableInfo.name}InsertDto implements Serializable {\n private static final long serialVersionUID = $!tool.serial();\n#foreach($column in $tableInfo.fullColumn)\n #if(${column.comment})\n /**\n * ${column.comment}\n */#end\n\t\n #if($tool.newHashSet(\"java.util.Date\", \"java.sql.Timestamp\", \"java.time.Instant\", \"java.time.LocalDateTime\", \"java.time.OffsetDateTime\", \"\tjava.time.ZonedDateTime\").contains($column.type))\n @DateTimeFormat\n @JsonFormat(pattern = \"yyyy-MM-dd HH:mm:ss\" ,timezone=\"GMT+8\")\n #end\n @ApiModelProperty(value = \"${column.comment}\")\n private $!{tool.getClsNameByFullName($column.type)} $!{column.name};\n#end\n\n}"
}, {
"name" : "UpdateDto.java.vm",
"code" : "##引入宏定义\n$!{define.vm}\n\n##使用宏定义设置回调(保存位置与文件后缀)\n#save(\"/dto\", \"UpdateDto.java\")\n\n##使用宏定义设置包后缀\n#setPackageSuffix(\"dto\")\n\n##使用全局变量实现默认包导入\n$!{autoImport.vm}\nimport java.io.Serializable;\n## 我的\nimport org.springframework.format.annotation.DateTimeFormat;\nimport lombok.Data;\nimport lombok.ToString;\nimport io.swagger.annotations.ApiModelProperty;\nimport com.fasterxml.jackson.annotation.JsonFormat;\nimport io.swagger.annotations.ApiModel;\n##使用宏定义实现类注释信息\n#tableComment(\"实体类\")\n@ApiModel(description = \"新增参数\")\n@Data\npublic class $!{tableInfo.name}UpdateDto implements Serializable {\n private static final long serialVersionUID = $!tool.serial();\n#foreach($column in $tableInfo.fullColumn)\n #if(${column.comment})\n /**\n * ${column.comment}\n */#end\n\t\n #if($tool.newHashSet(\"java.util.Date\", \"java.sql.Timestamp\", \"java.time.Instant\", \"java.time.LocalDateTime\", \"java.time.OffsetDateTime\", \"\tjava.time.ZonedDateTime\").contains($column.type))\n @DateTimeFormat\n @JsonFormat(pattern = \"yyyy-MM-dd HH:mm:ss\" ,timezone=\"GMT+8\")\n #end\n @ApiModelProperty(value = \"${column.comment}\")\n private $!{tool.getClsNameByFullName($column.type)} $!{column.name};\n#end\n\n}"
} ]
}
},
"columnConfig" : {
"Default" : {
"name" : "Default",
"elementList" : [ {
"title" : "disable",
"type" : "BOOLEAN",
"selectValue" : ""
}, {
"title" : "support",
"type" : "SELECT",
"selectValue" : "add,edit,query,del,ui"
} ]
}
},
"globalConfig" : {
"Default" : {
"name" : "Default",
"elementList" : [ {
"name" : "autoImport.vm",
"value" : "##自动导入包(仅导入实体属性需要的包,通常用于实体类)\n#foreach($import in $importList)\nimport $!import;\n#end"
}, {
"name" : "define.vm",
"value" : "##(Velocity宏定义)\n\n##定义设置表名后缀的宏定义,调用方式:#setTableSuffix(\"Test\")\n#macro(setTableSuffix $suffix)\n #set($tableName = $!tool.append($tableInfo.name, $suffix))\n#end\n\n##定义设置包名后缀的宏定义,调用方式:#setPackageSuffix(\"Test\")\n#macro(setPackageSuffix $suffix)\n#if($suffix!=\"\")package #end#if($tableInfo.savePackageName!=\"\")$!{tableInfo.savePackageName}.#{end}$!suffix;\n#end\n\n##定义直接保存路径与文件名简化的宏定义,调用方式:#save(\"/entity\", \".java\")\n#macro(save $path $fileName)\n $!callback.setSavePath($tool.append($tableInfo.savePath, $path))\n $!callback.setFileName($tool.append($tableInfo.name, $fileName))\n#end\n\n##定义直接保存路径与文件名简化的宏定义,调用方式:#save(\"/entity\", \".java\") DTO\n## #macro(saveone $path $fileName)\n ## $!callback.setSavePath($tool.append($tableInfo.savePath, $path))\n ## $!callback.setFileName($tool.append.($tool.append($tableInfo.name,\"DTO\"),$fileName))\n## #end\n\n##定义直接保存路径与文件名简化的宏定义,调用方式:#save(\"/entity\", \".java\") QueryVO\n## #macro(savetwo $path $fileName)\n ## $!callback.setSavePath($tool.append($tableInfo.savePath, $path))\n ## $!callback.setFileName($tool.append.($tool.append($tableInfo.name,\"QueryVO\"),$fileName))\n## #end\n\n##定义直接保存路径与文件名简化的宏定义,调用方式:#save(\"/entity\", \".java\") UpdateVO\n## #macro(savetree $path $fileName)\n ## $!callback.setSavePath($tool.append($tableInfo.savePath, $path))\n ## $!callback.setFileName($tool.append.($tool.append($tableInfo.name,\"UpdateVO\"),$fileName))\n## #end\n\n##定义直接保存路径与文件名简化的宏定义,调用方式:#save(\"/entity\", \".java\") CreateVO\n## #macro(savefor $path $fileName)\n ## $!callback.setSavePath($tool.append($tableInfo.savePath, $path))\n ## $!callback.setFileName($tool.append.($tool.append($tableInfo.name,\"CreateVO\"),$fileName))\n## #end\n\n\n\n\n\n##定义表注释的宏定义,调用方式:#tableComment(\"注释信息\")\n#macro(tableComment $desc)\n/**\n * $desc\n *\n * @author $!author\n * @since $!time.currTime()\n */\n#end\n\n##定义GET,SET方法的宏定义,调用方式:#getSetMethod($column)\n#macro(getSetMethod $column)\n\n public $!{tool.getClsNameByFullName($column.type)} get$!{tool.firstUpperCase($column.name)}() {\n return $!{column.name};\n }\n\n public void set$!{tool.firstUpperCase($column.name)}($!{tool.getClsNameByFullName($column.type)} $!{column.name}) {\n this.$!{column.name} = $!{column.name};\n }\n#end"
}, {
"name" : "init.vm",
"value" : "##初始化区域\n\n##去掉表的t_前缀\n$!tableInfo.setName($tool.getClassName($tableInfo.obj.name.replaceFirst(\"book_\",\"\")))\n\n##参考阿里巴巴开发手册,POJO 类中布尔类型的变量,都不要加 is 前缀,否则部分框架解析会引起序列化错误\n#foreach($column in $tableInfo.fullColumn)\n#if($column.name.startsWith(\"is\") && $column.type.equals(\"java.lang.Boolean\"))\n $!column.setName($tool.firstLowerCase($column.name.substring(2)))\n#end\n#end\n\n##实现动态排除列\n#set($temp = $tool.newHashSet(\"testCreateTime\", \"otherColumn\"))\n#foreach($item in $temp)\n #set($newList = $tool.newArrayList())\n #foreach($column in $tableInfo.fullColumn)\n #if($column.name!=$item)\n ##带有反回值的方法调用时使用$tool.call来消除返回值\n $tool.call($newList.add($column))\n #end\n #end\n ##重新保存\n $tableInfo.setFullColumn($newList)\n#end\n\n##对importList进行篡改\n#set($temp = $tool.newHashSet())\n#foreach($column in $tableInfo.fullColumn)\n #if(!$column.type.startsWith(\"java.lang.\"))\n ##带有反回值的方法调用时使用$tool.call来消除返回值\n $tool.call($temp.add($column.type))\n #end\n#end\n##覆盖\n#set($importList = $temp)\n"
}, {
"name" : "mybatisSupport.vm",
"value" : "##针对Mybatis 进行支持,主要用于生成xml文件\n#foreach($column in $tableInfo.fullColumn)\n ##储存列类型\n $tool.call($column.ext.put(\"sqlType\", $tool.getField($column.obj.dataType, \"typeName\")))\n #if($tool.newHashSet(\"java.lang.String\").contains($column.type))\n #set($jdbcType=\"VARCHAR\")\n #elseif($tool.newHashSet(\"java.lang.Boolean\", \"boolean\").contains($column.type))\n #set($jdbcType=\"BOOLEAN\")\n #elseif($tool.newHashSet(\"java.lang.Byte\", \"byte\").contains($column.type))\n #set($jdbcType=\"BYTE\")\n #elseif($tool.newHashSet(\"java.lang.Integer\", \"int\", \"java.lang.Short\", \"short\").contains($column.type))\n #set($jdbcType=\"INTEGER\")\n #elseif($tool.newHashSet(\"java.lang.Long\", \"long\").contains($column.type))\n #set($jdbcType=\"INTEGER\")\n #elseif($tool.newHashSet(\"java.lang.Float\", \"float\", \"java.lang.Double\", \"double\").contains($column.type))\n #set($jdbcType=\"NUMERIC\")\n #elseif($tool.newHashSet(\"java.util.Date\", \"java.sql.Timestamp\", \"java.time.Instant\", \"java.time.LocalDateTime\", \"java.time.OffsetDateTime\", \"\tjava.time.ZonedDateTime\").contains($column.type))\n #set($jdbcType=\"TIMESTAMP\")\n #elseif($tool.newHashSet(\"java.sql.Date\", \"java.time.LocalDate\").contains($column.type))\n #set($jdbcType=\"TIMESTAMP\")\n #else\n ##其他类型\n #set($jdbcType=\"VARCHAR\")\n #end\n $tool.call($column.ext.put(\"jdbcType\", $jdbcType))\n#end\n\n##定义宏,查询所有列\n#macro(allSqlColumn)\n #foreach($column in $tableInfo.fullColumn)\n $column.obj.name\n #if($velocityHasNext)\n , \n #end\n #end\n#end\n"
} ]
}
}
}
Easy-Code代码生成模板
最新推荐文章于 2024-06-28 16:18:49 发布