easyCode模板(自用)

刺骨的言语ヽ痛彻心扉 2023-02-28 16:21 679阅读 0赞

# easyCode mybatis template #

### 文章目录 ###

*  easyCode mybatis template
 *   *  entity
     *  dao
     *  xml
     *  service
     *  serviceImpl
     *  controller

## entity ##

##引入宏定义
    $!define
    
    ##使用宏定义设置回调（保存位置与文件后缀）
    #save("/entity", ".java")
    
    ##使用宏定义设置包后缀
    #setPackageSuffix("entity")
    
    ##使用全局变量实现默认包导入
    $!autoImport
    import java.io.Serializable;
    
    ##使用宏定义实现类注释信息
    #tableComment("实体类")
    public class $!{
        tableInfo.name} implements Serializable {
        
        private static final long serialVersionUID = $!tool.serial();
    #foreach($column in $tableInfo.fullColumn)
        #if(${
        column.comment})/**
        * ${column.comment}
        */#end
    
        private $!{
        tool.getClsNameByFullName($column.type)} $!{
        column.name};
    #end
    
    #foreach($column in $tableInfo.fullColumn)
    ##使用宏定义实现get,set方法
    #getSetMethod($column)
    #end
    
    }

## dao ##

##定义初始变量
    #set($tableName = $tool.append($tableInfo.name, "mapper"))
    ##设置回调
    $!callback.setFileName($tool.append($tableName, ".java"))
    $!callback.setSavePath($tool.append($tableInfo.savePath, "/mapper"))
    
    ##拿到主键
    #if(!$tableInfo.pkColumn.isEmpty())
        #set($pk = $tableInfo.pkColumn.get(0))
    #end
    
    #if($tableInfo.savePackageName)package $!{
        tableInfo.savePackageName}.#{
        end}Mapper;
    
    import $!{
        tableInfo.savePackageName}.entity.$!{
        tableInfo.name};
    import org.apache.ibatis.annotations.Param;
    import java.util.List;
    
    /**
     * $!{tableInfo.comment}($!{tableInfo.name})表数据库访问层
     *
     * @author $!author
     * @since $!time.currTime()
     */
    public interface $!{
        tableName} {
        
    
        /**
         * 通过主键查询单条数据
         *
         * @param $!pk.name 主键
         * @return 实例对象
         */
        $!{
        tableInfo.name} queryById($!pk.shortType $!pk.name);
    
        /**
         * 查询指定行数据
         *
         * @param offset 查询起始位置
         * @param limit 查询条数
         * @return 对象列表
         */
        List<$!{
        tableInfo.name}> queryAllByLimit(@Param("offset") int offset, @Param("limit") int limit);
    
     
        /**
         * 新增数据
         *
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
         */
        void insert($!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name}));
    
        /**
         * 修改数据
         *
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
         */
        void update($!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name}));
    
        /**
         * 通过主键删除数据
         * @param $!pk.name 主键
         */
        void deleteById($!pk.shortType $!pk.name);
         
         /**
         * 查询数据条数
         * @return 条数
         */
        int countAll();
        
        /**
         * 通过主键列表删除，列表长度不能为0
         * @param list 集合
         */
        void deleteByIds( List<$!pk.shortType> list);
        
        /**
         * 通过主键修改实体列表，列表长度不能为0，注意：当实体属性为null时，对应的列也会别更新为null
         * @param list 集合
         */
        void updateBatch( List<$!{
        tableInfo.name}> list);
        
         /**
         * 批量新增所有列，列表长度不能为0，且列表id统一为null或者统一不为null
         * @param list 集合
         */
        void insertBatch( List<$!{
        tableInfo.name}> list);
        
         /**
         * 通过实体非空属性删除
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实体
         */
         void deleteByEntity( $!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name}));
    
         /**
         * 通过实体不为空的属性作为筛选条件查询列表
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实体
         * @return list
         */
         List<$!{
        tableInfo.name}> listByEntity($!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name}));
        
         /**
         * 新增实体属性不为null的列
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实体
         */
         void insertSelect( $!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name}));
    
         /**
         * 通过实体不为空的属性作为筛选条件查询单个
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实体
         * @return 单个
         */
         $!{
        tableInfo.name} getByEntity($!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name}));
         
         /**
         * 通过实体不为空的属性作为筛选条件查询单个
         * @param list 实体
         * @return 单个
         */
         List<$!{
        tableInfo.name}> listByIds( List<$!pk.shortType> list);
    
    }

## xml ##

##引入mybatis支持
    $!mybatisSupport
    
    ##设置保存名称与保存位置
    $!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}ResultMap">
    #foreach($column in $tableInfo.fullColumn)
            <result property="$!column.name" column="$!column.obj.name" jdbcType="$!column.ext.jdbcType"/>
    #end
        </resultMap>
        
        <sql id="table_field">
          #allSqlColumn()
        </sql>
    
        
        <select id="queryById" resultMap="$!{tableInfo.name}ResultMap">
            select
               <include refid="table_field" />
            from $!tableInfo.obj.name
            where $!pk.obj.name = #{
        $!pk.name}
        </select>
    
        
        <select id="queryAllByLimit" resultMap="$!{tableInfo.name}ResultMap">
            select
             <include refid="table_field" />
            from $!tableInfo.obj.name
            limit #{
        offset}, #{
        limit}
        </select>
    
         
        
        <insert id="insert" keyProperty="$!pk.name" useGeneratedKeys="true">
            insert into $!{
        tableInfo.obj.name}(#foreach($column in $tableInfo.otherColumn)$!column.obj.name#if($velocityHasNext), #end#end)
            values (#foreach($column in $tableInfo.otherColumn)#{
        $!{
        column.name}}#if($velocityHasNext), #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>
       
        
        <select id="countAll" resultType="int">
            select count($!pk.obj.name) from $!{
        tableInfo.obj.name}
        </select>
        
         
        <delete id="deleteByIds" parameterType="list">
            delete from $!{
        tableInfo.obj.name} where $!pk.obj.name in
            <foreach item="item" collection="list" separator="," open="(" close=")" index="index">
                #{
        item}
            </foreach>
        </delete>
    
        
        <update id="updateBatch" parameterType="list">
            update $!{
        tableInfo.obj.name}
            <trim prefix="set" suffixOverrides=",">
                #foreach($column in $tableInfo.otherColumn)
                <trim prefix="$!{column.obj.name} = case" suffix="end,">
                     <foreach collection="list" item="item" index="index">
                      when $!pk.obj.name = #{
        item.$!pk.name} then #{
        item.$!column.name}
                     </foreach>
                </trim>
                #end
            </trim>
            where $!pk.obj.name in
            <foreach collection="list" index="index" item="item" separator="," open="(" close=")">
                #{
        item.$!pk.name,jdbcType=$!pk.ext.jdbcType}
            </foreach>
        </update>
        
         
        <insert id="insertBatch" keyProperty="$!pk.name" useGeneratedKeys="true" parameterType="list">
            insert into $!{
        tableInfo.obj.name}
             (#foreach($column in $tableInfo.fullColumn)$!{
        column.obj.name}#if($velocityHasNext), #end#end)
            values
            <foreach item="item" collection="list" separator="," open="" close="" index="index">
             (#foreach($column in $tableInfo.fullColumn)#{
        item.$!{
        column.name},jdbcType=$!column.ext.jdbcType}#if($velocityHasNext), #end#end)
            </foreach>
        </insert>
        
        
        <delete id="deleteByEntity" parameterType="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}">
            delete from $!{
        tableInfo.obj.name}
            <where>
                #foreach($column in $tableInfo.otherColumn)
                <if test="$!column.name != null">
                    and $!column.obj.name = #{
        $!column.name,jdbcType=$!column.ext.jdbcType}
                </if>
                #end
            </where>
        </delete>
        
         
        <select id="listByEntity" resultMap="$!{tableInfo.name}ResultMap" parameterType="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}">
            select
              <include refid="table_field" />
            from $!tableInfo.obj.name
            <where>
                #foreach($column in $tableInfo.fullColumn)
                <if test="$!column.name != null">
                    and $!column.obj.name = #{
        $!column.name,jdbcType=$!column.ext.jdbcType}
                </if>
            #end
            </where>
        </select>
        
       
        <insert id="insertSelect" keyProperty="$!pk.name" useGeneratedKeys="true" parameterType="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}">
            insert into $!{
        tableInfo.obj.name}
            <trim prefix="(" suffix=")" suffixOverrides=",">
                #foreach($column in  $tableInfo.fullColumn)
              <if test="$!column.name != null">
                 $!column.obj.name,
              </if>
                #end          
            </trim>
            <trim prefix="values (" suffix=")" suffixOverrides=",">
                #foreach($column in  $tableInfo.fullColumn)
              <if test="$!column.name != null">
                 #{
        $!column.name,jdbcType=$!column.ext.jdbcType},
              </if>
                #end
            </trim>
        </insert>
        
         
        <select id="getByEntity" resultMap="$!{tableInfo.name}ResultMap" parameterType="$!{tableInfo.savePackageName}.entity.$!{tableInfo.name}">
            select
              <include refid="table_field" />
            from $!tableInfo.obj.name
            <where>
                #foreach($column in $tableInfo.fullColumn)
                <if test="$!column.name != null">
                    and $!column.obj.name = #{
        $!column.name,jdbcType=$!column.ext.jdbcType}
                </if>
                #end
            </where>
              limit 1
        </select>
        
        
        <select id="listByIds" resultMap="$!{tableInfo.name}ResultMap" parameterType="list">
            select
              <include refid="table_field" />
            from $!tableInfo.obj.name
            where $!pk.obj.name in
            <foreach item="item" collection="list" separator="," open="(" close=")" index="index">
                #{
        item}
            </foreach>
        </select>
    </mapper>

## service ##

##定义初始变量
    #set($tableName = $tool.append($tableInfo.name, "Service"))
    ##设置回调
    $!callback.setFileName($tool.append($tableName, ".java"))
    $!callback.setSavePath($tool.append($tableInfo.savePath, "/service"))
    
    ##拿到主键
    #if(!$tableInfo.pkColumn.isEmpty())
        #set($pk = $tableInfo.pkColumn.get(0))
    #end
    
    #if($tableInfo.savePackageName)package $!{
        tableInfo.savePackageName}.#{
        end}service;
    
    import $!{
        tableInfo.savePackageName}.entity.$!{
        tableInfo.name};
    import java.util.List;
    
    /**
     * $!{tableInfo.comment}($!{tableInfo.name})表服务接口
     *
     * @author $!author
     * @since $!time.currTime()
     */
    public interface $!{
        tableName} {
        
    
        /**
         * 通过ID查询单条数据
         *
         * @param $!pk.name 主键
         * @return 实例对象
         */
        $!{
        tableInfo.name} queryById($!pk.shortType $!pk.name);
    
     
        /**
         * 新增数据
         *
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
         */
        void insert($!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name}));
    
        /**
         * 修改数据
         *
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
         */
        void update($!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name}));
    
        /**
         * 通过主键删除数据
         *
         * @param $!pk.name 主键
         */
        void deleteById($!pk.shortType $!pk.name);
    
    }

## serviceImpl ##

##定义初始变量
    #set($tableName = $tool.append($tableInfo.name, "ServiceImpl"))
    ##设置回调
    $!callback.setFileName($tool.append($tableName, ".java"))
    $!callback.setSavePath($tool.append($tableInfo.savePath, "/service/impl"))
    
    ##拿到主键
    #if(!$tableInfo.pkColumn.isEmpty())
        #set($pk = $tableInfo.pkColumn.get(0))
    #end
    
    #if($tableInfo.savePackageName)package $!{
        tableInfo.savePackageName}.#{
        end}service.impl;
    
    import $!{
        tableInfo.savePackageName}.entity.$!{
        tableInfo.name};
    import $!{
        tableInfo.savePackageName}.mapper.$!{
        tableInfo.name}Mapper;
    import $!{
        tableInfo.savePackageName}.service.$!{
        tableInfo.name}Service;
    import org.springframework.stereotype.Service;
    
    import javax.annotation.Resource;
    import java.util.List;
    
    /**
     * $!{tableInfo.comment}($!{tableInfo.name})表服务实现类
     *
     * @author $!author
     * @since $!time.currTime()
     */
    @Service("$!tool.firstLowerCase($!{tableInfo.name})Service")
    public class $!{
        tableName} implements $!{
        tableInfo.name}Service {
        
        @Resource
        private $!{
        tableInfo.name}Mapper $!tool.firstLowerCase($!{
        tableInfo.name})Mapper;
    
        /**
         * 通过主键查询单条数据
         *
         * @param $!pk.name 主键
         * @return 实例对象
         */
        @Override
        public $!{
        tableInfo.name} queryById($!pk.shortType $!pk.name) {
        
            return this.$!{
        tool.firstLowerCase($!{
        tableInfo.name})}Mapper.queryById($!pk.name);
        }
    
      
        /**
         * 新增数据
         *
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
         * @return 实例对象
         */
        @Transactional(rollbackFor = RuntimeException.class)
        @Override
        public void insert($!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name})) {
        
            this.$!{
        tool.firstLowerCase($!{
        tableInfo.name})}Mapper.insert($!tool.firstLowerCase($!{
        tableInfo.name}));
        }
    
        /**
         * 修改数据
         *
         * @param $!tool.firstLowerCase($!{tableInfo.name}) 实例对象
         * @return 实例对象
         */
        @Transactional(rollbackFor = RuntimeException.class)
        @Override
        public void update($!{
        tableInfo.name} $!tool.firstLowerCase($!{
        tableInfo.name})) {
        
            this.$!{
        tool.firstLowerCase($!{
        tableInfo.name})}Mapper.update($!tool.firstLowerCase($!{
        tableInfo.name}));
        }
    
        /**
         * 通过主键删除数据
         *
         * @param $!pk.name 主键
         */
        @Transactional(rollbackFor = RuntimeException.class)
        @Override
        public void deleteById($!pk.shortType $!pk.name) {
        
             this.$!{
        tool.firstLowerCase($!{
        tableInfo.name})}Mapper.deleteById($!pk.name);
        }
    }

## controller ##

##定义初始变量
    #set($tableName = $tool.append($tableInfo.name, "Controller"))
    ##设置回调
    $!callback.setFileName($tool.append($tableName, ".java"))
    $!callback.setSavePath($tool.append($tableInfo.savePath, "/controller"))
    ##拿到主键
    #if(!$tableInfo.pkColumn.isEmpty())
        #set($pk = $tableInfo.pkColumn.get(0))
    #end
    
    #if($tableInfo.savePackageName)package $!{
        tableInfo.savePackageName}.#{
        end}controller;
    
    import $!{
        tableInfo.savePackageName}.entity.$!{
        tableInfo.name};
    import $!{
        tableInfo.savePackageName}.service.$!{
        tableInfo.name}Service;
    import org.springframework.web.bind.annotation.*;
    
    import javax.annotation.Resource;
    
    /**
     * $!{tableInfo.comment}($!{tableInfo.name})表控制层
     *
     * @author $!author
     * @since $!time.currTime()
     */
    @RestController
    @RequestMapping("$!tool.firstLowerCase($tableInfo.name)")
    public class $!{
        tableName} {
        
        /**
         * 服务对象
         */
        @Resource
        private $!{
        tableInfo.name}Service $!tool.firstLowerCase($tableInfo.name)Service;
    
        /**
         * 通过主键查询单条数据
         *
         * @param id 主键
         * @return 单条数据
         */
        @GetMapping
        public $!{
        tableInfo.name} queryById($!pk.shortType id) {
        
            return this.$!{
        tool.firstLowerCase($tableInfo.name)}Service.queryById(id);
        }
    
    }

--------------------