idea插件EasyCode生成springboot的controller、service、serviceImpl、dao、mapper、entity代码

Meta39

已于 2023-07-26 19:51:49 修改

阅读量3.3k

点赞数 1

分类专栏： # Spring Boot 文章标签： spring boot intellij-idea

于 2021-11-12 17:46:36 首次发布

本文链接：https://blog.csdn.net/weixin_43933728/article/details/121292253

版权

Spring Boot 专栏收录该内容

79 篇文章 0 订阅

订阅专栏

在这里插入图片描述

Boolean生成的实体类会有问题。要自己手动删一下。

在这里插入图片描述

mysql数据库类型bigint类型生成jdbcType=INTEGER是错误的，要手动改成BIGINT

在这里插入图片描述

配置数据库
在这里插入图片描述

在这里插入图片描述
第一种：生成controller、serviceimpl、service、dao、mapper、entity的配置

新建EasyCodeConfig.json文件，然后导入本地配置。

{"author":"fu","version":"1.2.4","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":"bigint","javaType":"java.lang.Long"}]}},"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 com.github.pagehelper.PageHelper;\nimport com.github.pagehelper.PageSerializable;\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.serviceimpl.$!{tableInfo.name}ServiceImpl;\nimport org.springframework.web.bind.annotation.*;\n\nimport javax.annotation.Resource;\nimport javax.validation.Valid;\nimport java.util.List;\n\n##表注释\n/**\n * #if(${tableInfo.comment})${tableInfo.comment}#end\n */\n@RestController\n@RequestMapping(\"$!tool.firstLowerCase($tableInfo.name)\")\npublic class $!{tableName} {\n\n    @Resource\n    private $!{tableInfo.name}ServiceImpl $!tool.firstLowerCase($tableInfo.name)ServiceImpl;\n\n    /**\n     * 根据ID查询\n\t * @param id\n     */\n    @GetMapping(\"select\")\n    public $!{tableInfo.name} select(@RequestParam $!pk.shortType id) {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.select(id);\n    }\n\t\n\t/**\n     * 查询全部\n     */\n    @GetMapping(\"selectAll\")\n    public List<$!{tableInfo.name}> selectAll() {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.selectAll();\n    }\n\t\n\t/**\n     * 查询全部（分页）\n\t * @param pageNum 起始页\n\t * @param pageSize\t每页数据量\n     */\n    @GetMapping(\"selectPage\")\n    public PageSerializable<$!{tableInfo.name}> selectPage(@RequestParam(defaultValue = \"1\") Integer pageNum,@RequestParam(defaultValue = \"10\") Integer pageSize) {\n\t\tPageHelper.startPage(pageNum, pageSize);\n        return PageSerializable.of($!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.selectAll());\n    }\n\t\n\t/**\n     * 新增\n\t * @param $!{tool.firstLowerCase($tableInfo.name)}\n     */\n    @PostMapping(\"insert\")\n    public Integer insert(@RequestBody @Valid $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.insert($!{tool.firstLowerCase($tableInfo.name)});\n    }\n\n    /**\n     * 修改\n\t * @param $!{tool.firstLowerCase($tableInfo.name)}\n     */\n    @PostMapping(\"update\")\n    public Integer update(@RequestBody @Valid $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.update($!{tool.firstLowerCase($tableInfo.name)});\n    }\n\n    /**\n     * 删除\n\t * @param id\n     */\n    @PostMapping(\"delete\")\n    public Integer delete(@RequestParam $!pk.shortType id) {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.delete(id);\n    }\n\n}\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\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\nimport java.util.List;\n\n\npublic interface $!{tableName}{\n\t\n\t//根据ID查询\n\t$!{tableInfo.name} select($!pk.shortType $!pk.name);\n\t\n\t//查询全部\n\tList<$!{tableInfo.name}> selectAll();\n\t\n\t//新增\n\tInteger insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\t\n\t//更新\n\tInteger update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\t\n\t//删除\n\tInteger delete($!pk.shortType $!pk.name);\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\npublic class $!{tableInfo.name}{\n#foreach($column in $tableInfo.fullColumn)\n\n    private $!{tool.getClsNameByFullName($column.type)} $!{column.name};//#if(${column.comment})${column.comment}#end\n#end\n\n#foreach($column in $tableInfo.fullColumn)\n##实现get,set方法\n\tpublic $!{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} #if($column.type.equals(\"java.lang.Long\"));#elseif($column.type.equals(\"java.lang.Integer\"));#elseif($column.type.equals(\"java.lang.Float\"));#elseif($column.type.equals(\"java.lang.Double\"));#elseif($column.type.equals(\"java.util.Date\"));#else == null ? null : $!{column.name}.trim()#end;\n    }\n#end\n\n}\n"},{"name":"dao.java.vm","code":"##定义初始变量\n#set($tableName = $tool.append($tableInfo.name, \"Dao\"))\n##设置回调\n$!callback.setFileName($tool.append($tableName, \".java\"))\n$!callback.setSavePath($tool.append($tableInfo.savePath, \"/dao\"))\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}dao;\n\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\n\nimport java.util.List;\n\npublic interface $!{tableName} {\n\n\t//根据ID查询\n    $!{tableInfo.name} select($!pk.shortType $!pk.name);\n\t\n\t//查询全部\n\tList<$!{tableInfo.name}> selectAll();\n\n\t//新增\n    int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\n\t//更新\n    int update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\n\t//删除\n    int delete($!pk.shortType $!pk.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}.dao.$!{tableInfo.name}Dao\">\n\n    <resultMap type=\"$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}\" id=\"BaseResultMap\">\n#foreach($column in $tableInfo.fullColumn)\n        <result property=\"$!column.name\" column=\"$!column.obj.name\" jdbcType=\"$!column.ext.jdbcType\"/>\n#end\n    </resultMap>\n\t\n\t<sql id=\"Base_Column_List\">#allSqlColumn()</sql>\n\n\t<!-- 根据ID查询 -->\n    <select id=\"select\" resultMap=\"BaseResultMap\">\n        select\n          <include refid=\"Base_Column_List\" />\n        from $!tableInfo.obj.name\n        where $!pk.obj.name = #{$!pk.name}\n    </select>\n\t\n\t<!-- 查询全部 -->\n\t<select id=\"selectAll\" resultMap=\"BaseResultMap\">\n        select\n          <include refid=\"Base_Column_List\" />\n        from $!tableInfo.obj.name\n        where 1=1\n    </select>\n\t\n\t<!-- 新增 -->\n    <insert id=\"insert\" parameterType=\"$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}\">\n        insert into $!{tableInfo.obj.name}\n\t\t<trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t<if test=\"$!column.name != null\">\n                $!column.obj.name,\n        </if>\n\t\t#end\n\t\t</trim>\n\t\t<trim prefix=\"values (\" suffix=\")\" suffixOverrides=\",\">\n\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t<if test=\"$!column.name != null\">\n                #{$!column.name},\n        </if>\n\t\t#end\n\t\t</trim>\n    </insert>\n\t\n\t<!-- 更新 -->\n    <update id=\"update\" parameterType=\"$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}\">\n        update $!{tableInfo.obj.name}\n        <set>\n\t\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t\t<if test=\"$!column.name != null\">\n\t\t\t\t$!column.obj.name = #{$!column.name},\n\t\t\t</if>\n\t\t\t#end\n\t\t</set>\n\t\twhere $!pk.obj.name = #{$!pk.name}\n    </update>\n\t\n\t<!-- 删除 -->\n    <delete id=\"delete\">\n        delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}\n    </delete>\n\n</mapper>\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, \"/serviceimpl\"))\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}serviceimpl;\n\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.dao.$!{tableInfo.name}Dao;\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\nimport org.springframework.stereotype.Service;\nimport java.util.List;\n\nimport javax.annotation.Resource;\n\n@Service\npublic class $!{tableName} implements $!{tableInfo.name}Service {\n    @Resource\n    private $!{tableInfo.name}Dao $!tool.firstLowerCase($!{tableInfo.name})Dao;\n\t\n\t//根据ID查询\n\t@Override\n    public $!{tableInfo.name} select($!pk.shortType $!pk.name) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Dao.select($!pk.name);\n    }\n\t\n\t//查询全部\n\t@Override\n\tpublic List<$!{tableInfo.name}> selectAll() {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Dao.selectAll();\n    }\n\t\n\t//新增\n\t@Override\n    public Integer insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Dao.insert($!tool.firstLowerCase($!{tableInfo.name}));\n    }\n\n\t//更新\n\t@Override\n    public Integer update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Dao.update($!tool.firstLowerCase($!{tableInfo.name}));\n    }\n\n\t//删除\n\t@Override\n    public Integer delete($!pk.shortType $!pk.name) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Dao.delete($!pk.name);\n    }\n}\n"}]}},"columnConfig":{},"globalConfig":{}}

第二种：生成controller、service、mapper、mapping、entity的配置

{"author":"fu","version":"1.2.4","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":"bigint","javaType":"java.lang.Long"}]}},"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 com.github.pagehelper.PageHelper;\nimport com.github.pagehelper.PageSerializable;\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\nimport org.springframework.web.bind.annotation.*;\n\nimport javax.annotation.Resource;\nimport javax.validation.Valid;\nimport java.util.List;\n\n##表注释\n/**\n * #if(${tableInfo.comment})${tableInfo.comment}#end\n */\n@RestController\n@RequestMapping(\"$!tool.firstLowerCase($tableInfo.name)\")\npublic class $!{tableName} {\n\n    @Resource\n    private $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;\n\n    /**\n     * 根据ID查询\n\t * @param id\n     */\n    @GetMapping(\"select\")\n    public $!{tableInfo.name} select(@RequestParam $!pk.shortType id) {\n        return $!{tool.firstLowerCase($tableInfo.name)}Service.select(id);\n    }\n\t\n\t/**\n     * 查询全部\n     */\n    @GetMapping(\"selectAll\")\n    public List<$!{tableInfo.name}> selectAll() {\n        return $!{tool.firstLowerCase($tableInfo.name)}Service.selectAll();\n    }\n\t\n\t/**\n     * 查询全部（分页）\n\t * @param pageNum 起始页\n\t * @param pageSize\t每页数据量\n     */\n    @GetMapping(\"selectPage\")\n    public PageSerializable<$!{tableInfo.name}> selectPage(@RequestParam(defaultValue = \"1\") Integer pageNum,@RequestParam(defaultValue = \"10\") Integer pageSize) {\n\t\tPageHelper.startPage(pageNum, pageSize);\n        return PageSerializable.of($!{tool.firstLowerCase($tableInfo.name)}Service.selectAll());\n    }\n\t\n\t/**\n     * 新增\n\t * @param $!{tool.firstLowerCase($tableInfo.name)}\n     */\n    @PostMapping(\"insert\")\n    public Integer insert(@RequestBody @Valid $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {\n        return $!{tool.firstLowerCase($tableInfo.name)}Service.insert($!{tool.firstLowerCase($tableInfo.name)});\n    }\n\n    /**\n     * 修改\n\t * @param $!{tool.firstLowerCase($tableInfo.name)}\n     */\n    @PostMapping(\"update\")\n    public Integer update(@RequestBody @Valid $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {\n        return $!{tool.firstLowerCase($tableInfo.name)}Service.update($!{tool.firstLowerCase($tableInfo.name)});\n    }\n\n    /**\n     * 删除\n\t * @param id\n     */\n    @PostMapping(\"delete\")\n    public Integer delete(@RequestParam $!pk.shortType id) {\n        return $!{tool.firstLowerCase($tableInfo.name)}Service.delete(id);\n    }\n\n}\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\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;\nimport org.springframework.stereotype.Service;\nimport java.util.List;\n\nimport javax.annotation.Resource;\n\n@Service\npublic class $!{tableName} {\n    @Resource\n    private $!{tableInfo.name}Mapper $!tool.firstLowerCase($!{tableInfo.name})Mapper;\n\t\n\t//根据ID查询\n    public $!{tableInfo.name} select($!pk.shortType $!pk.name) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.select($!pk.name);\n    }\n\t\n\t//查询全部\n\tpublic List<$!{tableInfo.name}> selectAll() {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.selectAll();\n    }\n\t\n\t//新增\n    public Integer insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.insert($!tool.firstLowerCase($!{tableInfo.name}));\n    }\n\n\t//更新\n    public Integer update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.update($!tool.firstLowerCase($!{tableInfo.name}));\n    }\n\n\t//删除\n    public Integer delete($!pk.shortType $!pk.name) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.delete($!pk.name);\n    }\n}\n"},{"name":"mapper.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};\n\nimport java.util.List;\n\npublic interface $!{tableName} {\n\n\t//根据ID查询\n    $!{tableInfo.name} select($!pk.shortType $!pk.name);\n\t\n\t//查询全部\n\tList<$!{tableInfo.name}> selectAll();\n\n\t//新增\n    int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\n\t//更新\n    int update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\n\t//删除\n    int delete($!pk.shortType $!pk.name);\n\n}\n"},{"name":"mapping.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/mapping\"))\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=\"BaseResultMap\">\n#foreach($column in $tableInfo.fullColumn)\n        <result property=\"$!column.name\" column=\"$!column.obj.name\" jdbcType=\"$!column.ext.jdbcType\"/>\n#end\n    </resultMap>\n\t\n\t<sql id=\"Base_Column_List\">#allSqlColumn()</sql>\n\n\t<!-- 根据ID查询 -->\n    <select id=\"select\" resultMap=\"BaseResultMap\">\n        select\n          <include refid=\"Base_Column_List\" />\n        from $!tableInfo.obj.name\n        where $!pk.obj.name = #{$!pk.name}\n    </select>\n\t\n\t<!-- 查询全部 -->\n\t<select id=\"selectAll\" resultMap=\"BaseResultMap\">\n        select\n          <include refid=\"Base_Column_List\" />\n        from $!tableInfo.obj.name\n        where 1=1\n    </select>\n\t\n\t<!-- 新增 -->\n    <insert id=\"insert\" parameterType=\"$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}\">\n        insert into $!{tableInfo.obj.name}\n\t\t<trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t<if test=\"$!column.name != null\">\n                $!column.obj.name,\n        </if>\n\t\t#end\n\t\t</trim>\n\t\t<trim prefix=\"values (\" suffix=\")\" suffixOverrides=\",\">\n\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t<if test=\"$!column.name != null\">\n                #{$!column.name},\n        </if>\n\t\t#end\n\t\t</trim>\n    </insert>\n\t\n\t<!-- 更新 -->\n    <update id=\"update\" parameterType=\"$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}\">\n        update $!{tableInfo.obj.name}\n        <set>\n\t\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t\t<if test=\"$!column.name != null\">\n\t\t\t\t$!column.obj.name = #{$!column.name},\n\t\t\t</if>\n\t\t\t#end\n\t\t</set>\n\t\twhere $!pk.obj.name = #{$!pk.name}\n    </update>\n\t\n\t<!-- 删除 -->\n    <delete id=\"delete\">\n        delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}\n    </delete>\n\n</mapper>\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\npublic class $!{tableInfo.name}{\n#foreach($column in $tableInfo.fullColumn)\n\n    private $!{tool.getClsNameByFullName($column.type)} $!{column.name};//#if(${column.comment})${column.comment}#end\n#end\n\n#foreach($column in $tableInfo.fullColumn)\n##实现get,set方法\n\tpublic $!{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} #if($column.type.equals(\"java.lang.Long\"));#elseif($column.type.equals(\"java.lang.Integer\"));#elseif($column.type.equals(\"java.lang.Float\"));#elseif($column.type.equals(\"java.lang.Double\"));#elseif($column.type.equals(\"java.util.Date\"));#else == null ? null : $!{column.name}.trim()#end;\n    }\n#end\n\n}\n"}]}},"columnConfig":{},"globalConfig":{}}

第三种：生成controller、serviceimpl、service、mapper、mapping、entity的配置

{"author":"fu","version":"1.2.4","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":"bigint","javaType":"java.lang.Long"}]}},"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 com.github.pagehelper.PageHelper;\nimport com.github.pagehelper.PageSerializable;\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.serviceimpl.$!{tableInfo.name}ServiceImpl;\nimport org.springframework.web.bind.annotation.*;\n\nimport javax.annotation.Resource;\nimport javax.validation.Valid;\nimport java.util.List;\n\n##表注释\n/**\n * #if(${tableInfo.comment})${tableInfo.comment}#end\n */\n@RestController\n@RequestMapping(\"$!tool.firstLowerCase($tableInfo.name)\")\npublic class $!{tableName} {\n\n    @Resource\n    private $!{tableInfo.name}ServiceImpl $!tool.firstLowerCase($tableInfo.name)ServiceImpl;\n\n    /**\n     * 根据ID查询\n\t * @param id\n     */\n    @GetMapping(\"select\")\n    public $!{tableInfo.name} select(@RequestParam $!pk.shortType id) {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.select(id);\n    }\n\t\n\t/**\n     * 查询全部\n     */\n    @GetMapping(\"selectAll\")\n    public List<$!{tableInfo.name}> selectAll() {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.selectAll();\n    }\n\t\n\t/**\n     * 查询全部（分页）\n\t * @param pageNum 起始页\n\t * @param pageSize\t每页数据量\n     */\n    @GetMapping(\"selectPage\")\n    public PageSerializable<$!{tableInfo.name}> selectPage(@RequestParam(defaultValue = \"1\") Integer pageNum,@RequestParam(defaultValue = \"10\") Integer pageSize) {\n\t\tPageHelper.startPage(pageNum, pageSize);\n        return PageSerializable.of($!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.selectAll());\n    }\n\t\n\t/**\n     * 新增\n\t * @param $!{tool.firstLowerCase($tableInfo.name)}\n     */\n    @PostMapping(\"insert\")\n    public Integer insert(@RequestBody @Valid $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.insert($!{tool.firstLowerCase($tableInfo.name)});\n    }\n\n    /**\n     * 修改\n\t * @param $!{tool.firstLowerCase($tableInfo.name)}\n     */\n    @PostMapping(\"update\")\n    public Integer update(@RequestBody @Valid $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.update($!{tool.firstLowerCase($tableInfo.name)});\n    }\n\n    /**\n     * 删除\n\t * @param id\n     */\n    @PostMapping(\"delete\")\n    public Integer delete(@RequestParam $!pk.shortType id) {\n        return $!{tool.firstLowerCase($tableInfo.name)}ServiceImpl.delete(id);\n    }\n\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, \"/serviceimpl\"))\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}serviceimpl;\n\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\nimport $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;\nimport org.springframework.stereotype.Service;\nimport java.util.List;\n\nimport javax.annotation.Resource;\n\n@Service\npublic class $!{tableName}  implements $!{tableInfo.name}Service{\n    @Resource\n    private $!{tableInfo.name}Mapper $!tool.firstLowerCase($!{tableInfo.name})Mapper;\n\t\n\t//根据ID查询\n\t@Override\n    public $!{tableInfo.name} select($!pk.shortType $!pk.name) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.select($!pk.name);\n    }\n\t\n\t//查询全部\n\t@Override\n\tpublic List<$!{tableInfo.name}> selectAll() {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.selectAll();\n    }\n\t\n\t//新增\n\t@Override\n    public Integer insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.insert($!tool.firstLowerCase($!{tableInfo.name}));\n    }\n\n\t//更新\n\t@Override\n    public Integer update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name})) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.update($!tool.firstLowerCase($!{tableInfo.name}));\n    }\n\n\t//删除\n\t@Override\n    public Integer delete($!pk.shortType $!pk.name) {\n        return $!{tool.firstLowerCase($!{tableInfo.name})}Mapper.delete($!pk.name);\n    }\n}\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\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport java.util.List;\n\npublic interface $!{tableName}{\n\t\n\t//根据ID查询\n    $!{tableInfo.name} select($!pk.shortType $!pk.name);\n\t\n\t//查询全部\n\tList<$!{tableInfo.name}> selectAll();\n\t\n\t//新增\n    Integer insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\n\t//更新\n    Integer update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\n\t//删除\n\tInteger delete($!pk.shortType $!pk.name);\n}\n"},{"name":"mapper.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};\n\nimport java.util.List;\n\npublic interface $!{tableName} {\n\n\t//根据ID查询\n    $!{tableInfo.name} select($!pk.shortType $!pk.name);\n\t\n\t//查询全部\n\tList<$!{tableInfo.name}> selectAll();\n\n\t//新增\n    int insert($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\n\t//更新\n    int update($!{tableInfo.name} $!tool.firstLowerCase($!{tableInfo.name}));\n\n\t//删除\n    int delete($!pk.shortType $!pk.name);\n\n}\n"},{"name":"mapping.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/mapping\"))\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=\"BaseResultMap\">\n#foreach($column in $tableInfo.fullColumn)\n        <result property=\"$!column.name\" column=\"$!column.obj.name\" jdbcType=\"$!column.ext.jdbcType\"/>\n#end\n    </resultMap>\n\t\n\t<sql id=\"Base_Column_List\">#allSqlColumn()</sql>\n\n\t<!-- 根据ID查询 -->\n    <select id=\"select\" resultMap=\"BaseResultMap\">\n        select\n          <include refid=\"Base_Column_List\" />\n        from $!tableInfo.obj.name\n        where $!pk.obj.name = #{$!pk.name}\n    </select>\n\t\n\t<!-- 查询全部 -->\n\t<select id=\"selectAll\" resultMap=\"BaseResultMap\">\n        select\n          <include refid=\"Base_Column_List\" />\n        from $!tableInfo.obj.name\n        where 1=1\n    </select>\n\t\n\t<!-- 新增 -->\n    <insert id=\"insert\" parameterType=\"$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}\">\n        insert into $!{tableInfo.obj.name}\n\t\t<trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">\n\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t<if test=\"$!column.name != null\">\n                $!column.obj.name,\n        </if>\n\t\t#end\n\t\t</trim>\n\t\t<trim prefix=\"values (\" suffix=\")\" suffixOverrides=\",\">\n\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t<if test=\"$!column.name != null\">\n                #{$!column.name},\n        </if>\n\t\t#end\n\t\t</trim>\n    </insert>\n\t\n\t<!-- 更新 -->\n    <update id=\"update\" parameterType=\"$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}\">\n        update $!{tableInfo.obj.name}\n        <set>\n\t\t\t#foreach($column in $tableInfo.fullColumn)\n\t\t\t<if test=\"$!column.name != null\">\n\t\t\t\t$!column.obj.name = #{$!column.name},\n\t\t\t</if>\n\t\t\t#end\n\t\t</set>\n\t\twhere $!pk.obj.name = #{$!pk.name}\n    </update>\n\t\n\t<!-- 删除 -->\n    <delete id=\"delete\">\n        delete from $!{tableInfo.obj.name} where $!pk.obj.name = #{$!pk.name}\n    </delete>\n\n</mapper>\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\npublic class $!{tableInfo.name}{\n#foreach($column in $tableInfo.fullColumn)\n\n    private $!{tool.getClsNameByFullName($column.type)} $!{column.name};//#if(${column.comment})${column.comment}#end\n#end\n\n#foreach($column in $tableInfo.fullColumn)\n##实现get,set方法\n\tpublic $!{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} #if($column.type.equals(\"java.lang.Long\"));#elseif($column.type.equals(\"java.lang.Integer\"));#elseif($column.type.equals(\"java.lang.Float\"));#elseif($column.type.equals(\"java.lang.Double\"));#elseif($column.type.equals(\"java.util.Date\"));#else == null ? null : $!{column.name}.trim()#end;\n    }\n#end\n\n}\n"}]}},"columnConfig":{},"globalConfig":{}}

自定义MyBatisPlus分页模型

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.metadata.OrderItem;
import lombok.Data;

import java.util.Collections;
import java.util.List;

@Data
public class PageImpl<T> implements IPage<T> {
    private static final long serialVersionUID = 1L;
    protected long current; //当前页页码
    protected long size; //当前页数据数量
    protected long total; //数据总量
    protected List<T> records; //记录

    public static <T> PageImpl<T> of(long current, long size){
        return of(current,size,0L);
    }

    public static <T> PageImpl<T> of(long current, long size, long total){
        return new PageImpl<>(current,size,total);
    }

    public PageImpl(long current, long size, long total) {
        this.records = Collections.emptyList();
        this.current = Math.max(current, 1L);
        this.size = size;
        this.total = total;
    }

    @Override
    public List<OrderItem> orders() {
        return null;
    }

    @Override
    public List<T> getRecords() {
        return this.records;
    }

    @Override
    public IPage<T> setRecords(List<T> records) {
        this.records = records;
        return this;
    }

    @Override
    public long getTotal() {
        return this.total;
    }

    @Override
    public IPage<T> setTotal(long total) {
        this.total = total;
        return this;
    }

    @Override
    public long getSize() {
        return this.size;
    }

    @Override
    public IPage<T> setSize(long size) {
        this.size = size;
        return this;
    }

    @Override
    public long getCurrent() {
        return this.current;
    }

    @Override
    public IPage<T> setCurrent(long current) {
        this.current = current;
        return this;
    }

}

生成MySQL-MyBatis-Plus（使用Lombok和自定义分页模型PageImpl）代码

{
  "author" : "Meta39",
  "version" : "1.2.8",
  "userSecure" : "",
  "currTypeMapperGroupName" : "MySQL",
  "currTemplateGroupName" : "MySQL-MyBatis-Plus",
  "currColumnConfigGroupName" : "Default",
  "currGlobalConfigGroupName" : "Default",
  "typeMapper" : {
    "MySQL" : {
      "name" : "MySQL",
      "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" : "ORDINARY",
        "columnType" : "integer",
        "javaType" : "java.lang.Integer"
      }, {
        "matchType" : "ORDINARY",
        "columnType" : "int unsigned",
        "javaType" : "java.lang.Integer"
      }, {
        "matchType" : "REGEX",
        "columnType" : "int(\\(\\d+\\))?",
        "javaType" : "java.lang.Integer"
      }, {
        "matchType" : "REGEX",
        "columnType" : "(tiny|small|medium)*int(\\(\\d+\\))?",
        "javaType" : "java.lang.Integer"
      }, {
        "matchType" : "ORDINARY",
        "columnType" : "bigint unsigned",
        "javaType" : "java.lang.Long"
      }, {
        "matchType" : "REGEX",
        "columnType" : "bigint(\\(\\d+\\))?",
        "javaType" : "java.lang.Long"
      }, {
        "matchType" : "REGEX",
        "columnType" : "\\(?=date|datetime|timestamp|time\\)?",
        "javaType" : "java.util.Date"
      } ]
    }
  },
  "template" : {
    "MySQL-MyBatis-Plus" : {
      "name" : "MySQL-MyBatis-Plus",
      "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 lombok.RequiredArgsConstructor;\nimport $!{tableInfo.savePackageName}.config.PageImpl;\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\n##jdk8和jdk17的Resource、Valid包不在同一个地方\nimport javax.validation.Valid;\nimport org.springframework.web.bind.annotation.*;\n\nimport java.util.List;\n\n##表注释\n/**\n * #if(${tableInfo.comment})${tableInfo.comment}#end 相关接口\n \n * @author $!author\n * @since $!time.currTime()\n */\n@RestController\n@RequestMapping(\"$!tool.firstLowerCase($tableInfo.name)\")\n@RequiredArgsConstructor\npublic class $!{tableName} {\n    private final $!{tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;\n    /**\n     * 新增/更新#if(${tableInfo.comment})${tableInfo.comment}#end\n     \n\t * @param $!{tool.firstLowerCase($tableInfo.name)} #if(${tableInfo.comment})${tableInfo.comment}#end实体类\n     */\n    @PostMapping\n    public int save$!{tableInfo.name}(@RequestBody @Valid $!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {\n        return this.$!{tool.firstLowerCase($tableInfo.name)}Service.save$!{tableInfo.name}($!{tool.firstLowerCase($tableInfo.name)});\n    }\n\n    /**\n     * 根据$!pk.name查询#if(${tableInfo.comment})${tableInfo.comment}#end\n     \n\t * @param $!pk.name $!pk.comment\n     */\n    @GetMapping(\"{$!pk.name}\")\n    public $!{tableInfo.name} select$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)(@PathVariable(\"$!pk.name\") $!pk.shortType $!pk.name) {\n        return this.$!{tool.firstLowerCase($tableInfo.name)}Service.select$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)($!pk.name);\n    }\n    \n    /**\n     * 分页查询#if(${tableInfo.comment})${tableInfo.comment}#end 数据\n     * @param page 起始页（不传则默认为首页）\n     * @param size 每页数量（不传则默认为10条）\n     */\n    @GetMapping(\"paging\")\n    public PageImpl<$!{tableInfo.name}> select$!{tableInfo.name}Page (@RequestParam(required = false, defaultValue = \"1\") Long page, @RequestParam(required = false, defaultValue = \"10\") Long size) {\n        return this.$!{tool.firstLowerCase($tableInfo.name)}Service.select$!{tableInfo.name}Page(page, size);\n    }\n    \n    /**\n     * 查询#if(${tableInfo.comment})${tableInfo.comment}#end 列表数据\n     */\n    @GetMapping(\"list\")\n    public List<$!{tableInfo.name}> select$!{tableInfo.name}List() {\n        return this.$!{tool.firstLowerCase($tableInfo.name)}Service.select$!{tableInfo.name}List();\n    }\n    \n    /**\n     * 根据$!pk.name删除#if(${tableInfo.comment})${tableInfo.comment}#end\n     \n\t * @param $!pk.name $!pk.comment\n     */\n    @DeleteMapping(\"{$!pk.name}\")\n    public int delete$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)(@PathVariable $!pk.shortType $!pk.name) {\n        return this.$!{tool.firstLowerCase($tableInfo.name)}Service.delete$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)($!pk.name);\n    }\n    \n    /**\n     * 根据${pk.name}集合删除#if(${tableInfo.comment})${tableInfo.comment}#end\n     \n\t * @param ${pk.name}s ${pk.comment}集合\n     */\n    @DeleteMapping(\"${pk.name}s\")\n    public int delete$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)s(@RequestBody List<$!pk.shortType> ${pk.name}s) {\n        return this.$!{tool.firstLowerCase($tableInfo.name)}Service.delete$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)s(${pk.name}s);\n    }\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\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.config.PageImpl;\nimport com.baomidou.mybatisplus.extension.service.IService;\n##jdk8和jdk17的Resource包不在同一个地方\nimport java.util.List;\n\n/**\n * #if(${tableInfo.comment})${tableInfo.comment}#end 接口\n * @author $!author\n * @since $!time.currTime()\n */\npublic interface $!{tableName} extends IService<$!{tableInfo.name}> {\n\t/**\n     * 新增/更新#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n    int save$!{tableInfo.name}($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)});\n\t\n\t/**\n\t * 根据$!pk.name查询#if(${tableInfo.comment})${tableInfo.comment}\n\t #end*/\n    $!{tableInfo.name} select$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)($!pk.shortType $!pk.name);\n    \n    /**\n     * 分页查询#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n    PageImpl<$!{tableInfo.name}> select$!{tableInfo.name}Page(Long page, Long size);\n     \n    /**\n     * 查询#if(${tableInfo.comment})${tableInfo.comment}#end 列表\n     */\n    List<$!{tableInfo.name}> select$!{tableInfo.name}List();\n    \n    /**\n     * 根据$!pk.name删除#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n    int delete$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)($!pk.shortType $!pk.name);\n    \n    /**\n     * 根据${pk.name}集合删除#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n    int delete$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)s(List<$!pk.shortType> ${pk.name}s); \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\t#set($pkShortType = $tableInfo.pkColumn.get(0).shortType)\n#end\n\n#if($tableInfo.savePackageName)package $!{tableInfo.savePackageName}.#{end}service.impl;\n\nimport lombok.RequiredArgsConstructor;\nimport com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;\nimport $!{tableInfo.savePackageName}.config.PageImpl;\nimport com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\nimport $!{tableInfo.savePackageName}.mapper.$!{tableInfo.name}Mapper;\nimport $!{tableInfo.savePackageName}.service.$!{tableInfo.name}Service;\n##jdk8和jdk17的Resource包不在同一个地方\nimport org.springframework.stereotype.Service;\nimport java.util.List;\n\n/**\n * #if(${tableInfo.comment})${tableInfo.comment}#end 接口实现\n * @author $!author\n * @since $!time.currTime()\n */\n@Service\n@RequiredArgsConstructor\npublic class $!{tableName} extends ServiceImpl<$!{tableInfo.name}Mapper, $!{tableInfo.name}> implements $!{tableInfo.name}Service {\n    private final $!{tableInfo.name}Mapper $!tool.firstLowerCase($!{tableInfo.name})Mapper;\n\t\n\t/**\n     * 新增/更新#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n    @Override\n    public int save$!{tableInfo.name}($!{tableInfo.name} $!{tool.firstLowerCase($tableInfo.name)}) {\n\t\t#if($!pkShortType == 'String')\nif ($!{tool.firstLowerCase($tableInfo.name)}$!tool.append(\".get\")$!{tool.firstUpperCase($pk.name)}() == null || $!{tool.firstLowerCase($tableInfo.name)}$!tool.append(\".get\")$!{tool.firstUpperCase($pk.name)}()$!tool.append(\".trim().length()\") == 0){\n\t\t\treturn this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"insert\")($!{tool.firstLowerCase($tableInfo.name)});\n\t\t}\n\t\t#elseif($!pkShortType == 'Long')\nif ($!{tool.firstLowerCase($tableInfo.name)}$!tool.append(\".get\")$!{tool.firstUpperCase($pk.name)}() == null || $!{tool.firstLowerCase($tableInfo.name)}$!tool.append(\".get\")$!{tool.firstUpperCase($pk.name)}() == 0L){\n\t\t\treturn this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"insert\")($!{tool.firstLowerCase($tableInfo.name)});\n\t\t}\n\t\t#elseif($!pkShortType == 'Integer')\nif ($!{tool.firstLowerCase($tableInfo.name)}$!tool.append(\".get\")$!{tool.firstUpperCase($pk.name)}() == null || $!{tool.firstLowerCase($tableInfo.name)}$!tool.append(\".get\")$!{tool.firstUpperCase($pk.name)}() == 0){\n\t\t\treturn this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"insert\")($!{tool.firstLowerCase($tableInfo.name)});\n\t\t}\n\t\t#else\nif ($!{tool.firstLowerCase($tableInfo.name)}$!tool.append(\".get\")$!{tool.firstUpperCase($pk.name)}() == null){\n\t\t\treturn this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"insert\")($!{tool.firstLowerCase($tableInfo.name)});\n\t\t}\n\t\t#end\nreturn this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"updateById\")($!{tool.firstLowerCase($tableInfo.name)});\n    }\n    \n\t/**\n     * 根据$!pk.name查询#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n\t@Override\n    public $!{tableInfo.name} select$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)($!pk.shortType $!pk.name) {\n        return this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\")selectById($!pk.name);\n    }\n     \n     /**\n     * 分页查询#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n     @Override\n     public PageImpl<$!{tableInfo.name}> select$!{tableInfo.name}Page(Long page, Long size) {\n        LambdaQueryWrapper<$!{tableInfo.name}> lqw = new LambdaQueryWrapper<>();\n        return this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"selectPage\")(PageImpl.of(page,size),lqw);\n     }\n     \n     /**\n     * 查询#if(${tableInfo.comment})${tableInfo.comment}#end 列表\n     */\n     @Override\n     public List<$!{tableInfo.name}> select$!{tableInfo.name}List() {\n        LambdaQueryWrapper<$!{tableInfo.name}> lqw = new LambdaQueryWrapper<>();\n        return this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"selectList\")(lqw);\n     }\n    \n    /**\n     * 根据$!pk.name删除#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n     @Override\n     public int delete$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)($!pk.shortType $!pk.name) {\n        return this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"deleteById\")($!pk.name);\n     }\n     \n     /**\n     * 根据${pk.name}集合删除#if(${tableInfo.comment})${tableInfo.comment}\n     #end*/\n     @Override\n     public int delete$!{tableInfo.name}By$tool.firstUpperCase($!pk.name)s(List<$!pk.shortType> ${pk.name}s) {\n        return this.$!tool.firstLowerCase($!{tableInfo.name})$!tool.append(\"Mapper.\",\"deleteBatchIds\")(${pk.name}s);\n     }\n}"
      }, {
        "name" : "mapper.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 com.baomidou.mybatisplus.core.mapper.BaseMapper;\nimport $!{tableInfo.savePackageName}.entity.$!{tableInfo.name};\n\nimport org.apache.ibatis.annotations.Mapper;\n\n/**\n * #if(${tableInfo.comment})${tableInfo.comment}#end mapper映射\n * @author $!author\n * @since $!time.currTime()\n */\n@Mapper\npublic interface $!{tableName} extends BaseMapper<$!{tableInfo.name}> {\n\t\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</mapper>"
      }, {
        "name" : "entity.java.vm",
        "code" : "##引入宏定义\n$!{define.vm}\n\n##使用宏定义设置回调（保存位置与文件后缀）\n#save(\"/entity\", \".java\")\n\n##使用宏定义设置包后缀\n#setPackageSuffix(\"entity\")\n\n##使用全局变量实现默认包导入\n$!{autoImport.vm}\nimport com.baomidou.mybatisplus.annotation.*;\nimport java.io.Serializable;\nimport lombok.Data;\n\n##表注释\n/**\n * #if(${tableInfo.comment})${tableInfo.comment}#end 实体类\n * @author $!author\n * @since $!time.currTime()\n */\n@Data\n@TableName(\"$tableInfo.obj.name\")\npublic class $!{tableInfo.name} implements Serializable {\n    private static final long serialVersionUID = $!tool.serial();\n    #foreach($column in $tableInfo.pkColumn)\n@TableId(type = IdType.AUTO)\n    private $!{tool.getClsNameByFullName($column.type)} $column.name;#end //主键 #foreach($column in $tableInfo.otherColumn)\n\n    private $!{tool.getClsNameByFullName($column.type)} $!{column.name}; //#if(${column.comment})${column.comment}#end\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##定义表注释的宏定义，调用方式：#tableComment(\"注释信息\")\n#macro(tableComment $desc)\n/**\n * $!{tableInfo.comment}($!{tableInfo.name})$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)"
      }, {
        "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)#foreach($column in $tableInfo.fullColumn)$column.obj.name#if($velocityHasNext), #end#end#end\n"
      } ]
    }
  }
}

Meta39

关注

1
点赞
踩
6

收藏

觉得还不错? 一键收藏
0
评论
idea插件EasyCode生成springboot的controller、service、serviceImpl、dao、mapper、entity代码

idea插件EasyCode生成springboot的controller、service、serviceImpl、dao、mapper、entity代码
复制链接

扫一扫

专栏目录