PDManer程序代码模板

PDManer程序代码模板

最近一直使用PDManer做代码生成器,因为它自带的实体类属性和mapper与预期不符，这里将mapper和实体类模板进行修改备份，方便以后使用。

DO

{{  var today=new Date();
    var fullYear=today.getFullYear();
    var month=today.getMonth() + 1;
    var days=today.getDate();
    
    var pkVarName = "undefinedId";
    var pkDataType = "String";
    it.entity.fields.forEach(function(field){
        if(field.primaryKey){
            pkVarName = it.func.camel(field.defKey,false);
            pkDataType = field["type"];
            return;
        }
        if(field["type"]=="Date"){
            field["type"] = "LocalDateTime"
        }
        if(field["type"]=="char"){
            field["type"] = "String"
        }
        if(field["type"]=="Double"){
            field["type"] = "BigDecimal"
        }
    });
    
    var pkgName = it.entity.env.base.nameSpace;
    var beanClass = it.entity.env.base.codeRoot;
    var beanVarName = beanClass.charAt(0).toLowerCase()+beanClass.slice(1);
    var serviceClass = beanClass+'Service';
    var serviceVarName= beanVarName+'Service';
    
}}package {{=pkgName}}.entity;
$blankline
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import java.io.Serializable;
import java.time.LocalDateTime;
$blankline

 /**
 * {{=it.entity.defName}};{{=it.entity.comment}}
 * @author : 
 * @date : {{=fullYear}}-{{=month}}-{{=days}}
 */
@ApiModel(value = "{{=it.entity.defName}}",description = "{{=it.entity.comment}}")
public class {{=beanClass}}DO{
{{~it.entity.fields:field:index}}
    /** {{=it.func.join(field.defName,field.comment,';')}} */
    @ApiModelProperty(name = "{{=field.defName}}",notes = "{{=field.comment}}")
    private {{=field.type}} {{=it.func.camel(field.defKey,false)}} ;
{{~}}
$blankline

{{~it.entity.fields:field:index}}
    /** {{=it.func.join(field.defName,field.comment,';')}} */
    public {{=field.type}} get{{=it.func.camel(field.defKey,true)}}(){
        return this.{{=it.func.camel(field.defKey,false)}};
    }
    /** {{=it.func.join(field.defName,field.comment,';')}} */
    public void set{{=it.func.camel(field.defKey,true)}}({{=field.type}} {{= it.func.camel(field.defKey,false) }}){
        this.{{=it.func.camel(field.defKey,false)}}={{=it.func.camel(field.defKey,false)}};
    }
{{~}}
}

Mapper

{{  var today=new Date();
    var fullYear=today.getFullYear();
    var month=today.getMonth() + 1;
    var days=today.getDate();
    
    var pkVarName = "undefinedId";
    var pkDataType = "String";
    var pkField = "UNDEFINED_ID";
    it.entity.fields.forEach(function(field){
        if(field.primaryKey){
            pkField = field.defKey;
            pkVarName = it.func.camel(field.defKey,false);
            pkDataType = field["type"];
            return;
        }
    });
    
    var pkgName = it.entity.env.base.nameSpace;
    var beanClass = it.entity.env.base.codeRoot;
    var beanVarName = beanClass.charAt(0).toLowerCase()+beanClass.slice(1);
    var serviceClass = beanClass+'Service';
    var serviceVarName= beanVarName+'Service';
    
}}<?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="{{=pkgName}}.mapper.{{=beanClass}}Mapper">
    <resultMap type="{{=pkgName}}.entity.{{=beanClass}}" id="{{=beanClass}}Map">
    {{~it.entity.fields:field:index}}
        <result property="{{=it.func.camel(field.defKey,false)}}" column="{{=field.defKey}}"/>
    {{~}}
    </resultMap>
    $blankline
    <!-- 通过ID查询单条数据 -->
    <select id="queryById" resultMap="{{=beanClass}}Map">
        select
            {{=it.entity.fields.map(function(e,i){return e.defKey}).join(',')}}
        from {{=it.entity.defKey}}
        where {{=pkField}} = #{{{=pkVarName}}}
    </select>
    $blankline
    <!--分页查询指定行数据-->
    <select id="queryAllByLimit" resultMap="{{=beanClass}}Map">
        select
            {{=it.entity.fields.map(function(e,i){return e.defKey}).join(',')}}
        from {{=it.entity.defKey}}
        <where>
        {{~it.entity.fields:field:index}}
            <if test="{{=it.func.camel(field.defKey,false)}} != null and {{=it.func.camel(field.defKey,false)}} != ''">
                and {{=field.defKey}} = #{{{=it.func.camel(field.defKey,false)}}}
            </if>
        {{~}}
        </where>
        limit #{pageable.offset}, #{pageable.pageSize}
    </select>
    $blankline
    <!--统计总行数-->
    <select id="count" resultType="java.lang.Long">
        select count(1)
        from {{=it.entity.defKey}}
        <where>
        {{~it.entity.fields:field:index}}
            <if test="{{=it.func.camel(field.defKey,false)}} != null and {{=it.func.camel(field.defKey,false)}} != ''">
                and {{=field.defKey}} = #{{{=it.func.camel(field.defKey,false)}}}
            </if>
        {{~}}
        </where>
    </select>
    $blankline
    <!--新增数据-->
    <insert id="insert">
        insert into {{=it.entity.defKey}}({{=it.entity.fields.map(function(e,i){return e.defKey}).join(',')}})
        values ({{=it.entity.fields.map(function(e,i){return '#{'+it.func.camel(e.defKey,false)+'}'}).join(',')}})
    </insert>
    $blankline
    <!-- 批量新增数据 -->
    <insert id="insertBatch" keyProperty="{{=pkField}}" useGeneratedKeys="true">
        insert into {{=it.entity.defKey}}({{=it.entity.fields.map(function(e,i){return e.defKey}).join(',')}})
        values
        <foreach collection="entities" item="entity" separator=",">
            ({{=it.entity.fields.map(function(e,i){return '#{entity.'+it.func.camel(e.defKey,false)+'}'}).join(',')}})
        </foreach>
    </insert>
    $blankline
    <!-- 批量新增或按主键更新数据 -->
    <insert id="insertOrUpdateBatch">
        insert into {{=it.entity.defKey}}({{=it.entity.fields.map(function(e,i){return e.defKey}).join(',')}})
        values
        <foreach collection="entities" item="entity" separator=",">
            ({{=it.entity.fields.map(function(e,i){return '#{entity.'+it.func.camel(e.defKey,false)+'}'}).join(',')}})
        </foreach>
        on duplicate key update
        {{=it.entity.fields.map(function(e,i){return e.defKey + '=values('+e.defKey+')'}).join(',\n\t\t')}}
    </insert>
    $blankline
    <!-- 更新数据 -->
    <update id="update">
        update {{=it.entity.defKey}}
        <set>
        {{~it.entity.fields:field:index}}
            <if test="{{=it.func.camel(field.defKey,false)}} != null and {{=it.func.camel(field.defKey,false)}} != ''">
                {{=field.defKey}} = #{{{=it.func.camel(field.defKey,false)}}},
            </if>
        {{~}}
        </set>
        where {{=pkField}} = #{{{=pkVarName}}}
    </update>
    $blankline
    <!-- 批量更新数据 -->
    <update id="updateBatch">
        <foreach collection="entities" item="entity" separator=";">
            update {{=it.entity.defKey}}
            <set>
            {{~it.entity.fields:field:index}}
                <if test="entity.{{=it.func.camel(field.defKey,false)}} != null and entity.{{=it.func.camel(field.defKey,false)}} != ''">
                    {{=field.defKey}} = #{entity.{{=it.func.camel(field.defKey,false)}}},
                </if>
            {{~}}
            </set>
            where {{=pkField}} = #{entity.{{=pkVarName}}}
        </foreach>
    </update>
    $blankline
    <!--通过主键删除-->
    <delete id="deleteById">
        delete from {{=it.entity.defKey}} where {{=pkField}} = #{{{=pkVarName}}}
    </delete>
</mapper>