devbox
你好赵伟
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

PDManer 自定义 mybatis 的代码模板_pdmaner java代码

作者：你好赵伟 | 2024-07-07 17:01:45

赞

踩

pdmaner java代码

目录

前言

PDManer

代码模板

Mapper

Mapper.xml

Entity

前言

平时一直使用PDManer对业务进行数据库表建模，建完模后可以自动生成基础的业务代码，以 mybatis 为例，生成 Entity，Mapper，Mapper.xml 代码。

PDManer里有默认的代码模板，不过在实际开发中需要根据实际情况做调整，便需要自定义代码模板。

记录下实际项目中用过的 mybatis 代码模板，以便以后复用。

PDManer

代码模板

Mapper

  1. {{  var today=new Date();
  2.     var fullYear=today.getFullYear();
  3.     var month=today.getMonth() + 1;
  4.     var days=today.getDate();
  5.     
  6.     var pkVarName = "id";
  7.     var pkDataType = "String";
  8.     it.entity.fields.forEach(function(field){
  9.         if(field.primaryKey){
  10.             pkVarName = field.defKey,false;
  11.             pkDataType = field["type"];
  12.             return;
  13.         }
  14.     });
  15.     
  16.     var pkgName = it.entity.env.base.nameSpace;
  17.     var beanClass = it.entity.env.base.codeRoot;
  18.     var beanVarName = beanClass.charAt(0).toLowerCase()+beanClass.slice(1);
  19.     var serviceClass = beanClass+'Service';
  20.     var serviceVarName= beanVarName+'Service';
  21.     
  22. }}package {{=pkgName}}.mapper;
  23. $blankline
  24. import java.util.List;
  25. import org.apache.ibatis.annotations.Mapper;
  26. import org.apache.ibatis.annotations.Param;
  27. import {{=pkgName}}.beans.entity.{{=beanClass}};
  28. $blankline
  29.  
  30.  /**
  31.  * {{=it.entity.defName}};({{=it.entity.defKey}})表数据库访问层
  32.  * @author : name
  33.  * @date : {{=fullYear}}-{{=month}}-{{=days}}
  34.  */
  35. @Mapper
  36. public interface {{=beanClass}}Mapper{
  37.     //↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓模板生成的基础方法↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
  38.     /** 
  39.      * 通过ID查询单条数据 
  40.      *
  41.      * @param {{=pkVarName}} 主键
  42.      * @return 实例对象
  43.      */
  44.     {{=beanClass}} selectById({{=pkDataType}} {{=pkVarName}});
  45.     
  46.     /** 
  47.      * 查询列表
  48.      *
  49.      * @param {{=beanVarName}} 查询条件
  50.      * @return 对象列表
  51.      */
  52.     List<{{=beanClass}}> selectList({{=beanClass}} {{=beanVarName}});
  53.  
  54.     /** 
  55.      * 统计总行数
  56.      *
  57.      * @param {{=beanVarName}} 查询条件
  58.      * @return 总行数
  59.      */
  60.     long count({{=beanClass}} {{=beanVarName}});
  61.  
  62.     /** 
  63.      * 新增数据
  64.      *
  65.      * @param {{=beanVarName}} 实例对象
  66.      * @return 影响行数
  67.      */
  68.     int insert({{=beanClass}} {{=beanVarName}});
  69.  
  70.     /** 
  71.      * 批量新增数据
  72.      *
  73.      * @param entities List<{{=beanClass}}> 实例对象列表
  74.      * @return 影响行数
  75.      */
  76.     int insertBatch(@Param("entities") List<{{=beanClass}}> entities);
  77.     
  78.     /** 
  79.      * 批量新增或按主键更新数据
  80.      *
  81.      * @param entities List<{{=beanClass}}> 实例对象列表
  82.      * @return 影响行数
  83.      */
  84.     int insertOrUpdateBatch(@Param("entities") List<{{=beanClass}}> entities);
  85.     
  86.     /** 
  87.      * 更新数据
  88.      *
  89.      * @param {{=beanVarName}} 实例对象
  90.      * @return 影响行数
  91.      */
  92.     int update({{=beanClass}} {{=beanVarName}});
  93.  
  94.     /** 
  95.      * 通过主键删除数据
  96.      *
  97.      * @param {{=pkVarName}} 主键
  98.      * @return 影响行数
  99.      */
  100.     int deleteById({{=pkDataType}} {{=pkVarName}});
  101.     //↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑模板生成的基础方法↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑
  102.     $blankline
  103.     //↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓自定义方法↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
  104.     $blankline
  105.     $blankline
  106.     $blankline
  107.     //↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑自定义方法↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑
  108. }

Mapper.xml

  1. {{  var today=new Date();
  2.     var fullYear=today.getFullYear();
  3.     var month=today.getMonth() + 1;
  4.     var days=today.getDate();
  5.     
  6.     var pkVarName = "id";
  7.     var pkDataType = "String";
  8.     var pkField = "id";
  9.     it.entity.fields.forEach(function(field){
  10.         if(field.primaryKey){
  11.             pkField = field.defKey;
  12.             pkVarName = field.defKey;
  13.             pkDataType = field["type"];
  14.             return;
  15.         }
  16.     });
  17.     
  18.     var pkgName = it.entity.env.base.nameSpace;
  19.     var beanClass = it.entity.env.base.codeRoot;
  20.     var beanVarName = beanClass.charAt(0).toLowerCase()+beanClass.slice(1);
  21.     var serviceClass = beanClass+'Service';
  22.     var serviceVarName= beanVarName+'Service';
  23.     
  24. }}<?xml version="1.0" encoding="UTF-8"?>
  25. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  26. <mapper namespace="{{=pkgName}}.mapper.{{=beanClass}}Mapper">
  27.     <resultMap type="{{=pkgName}}.beans.entity.{{=beanClass}}" id="{{=beanClass}}Map">
  28.     {{~it.entity.fields:field:index}}
  29.         <result property="{{=it.func.camel(field.defKey,false)}}" column="{{=field.defKey}}"/>
  30.     {{~}}
  31.     </resultMap>
  32.     $blankline
  33.     <!--↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓模板生成的基础方法↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓-->
  34.     <!-- 通过ID查询单条数据 -->
  35.     <select id="selectById" resultMap="{{=beanClass}}Map">
  36.         select
  37.             {{=it.entity.fields.map(function(e,i){
  38.                 if (e.defKey == 'desc' || e.defKey == 'type' || e.defKey == 'key' || e.defKey == 'level') return '`'+e.defKey+'`';
  39.                 return e.defKey}).join(',')}}
  40.         from {{=it.entity.defKey}}
  41.         where {{=pkField}} = #{{{=pkVarName}}} and delete_flag = 0
  42.     </select>
  43.     $blankline
  44.     <!--查询列表-->
  45.     <select id="selectList" resultMap="{{=beanClass}}Map">
  46.         select
  47.             {{=it.entity.fields.map(function(e,i){
  48.                 if (e.defKey == 'desc' || e.defKey == 'type' || e.defKey == 'key' || e.defKey == 'level') return '`'+e.defKey+'`';
  49.                 return e.defKey}).join(',')}}
  50.         from {{=it.entity.defKey}}
  51.         <where>
  52.             delete_flag = 0
  53.         {{~it.entity.fields:field:index}}
  54.             {{?field.defKey != 'delete_flag'}}<if test={{?field.type == 'Integer'}}"{{=it.func.camel(field.defKey,false)}} != null"{{??}}"{{=it.func.camel(field.defKey,false)}} != null and {{=it.func.camel(field.defKey,false)}} != ''"{{?}}>
  55.                 and {{?field.defKey == 'desc' || field.defKey == 'type' || field.defKey == 'key'}}`{{=field.defKey}}`{{??}}{{=field.defKey}}{{?}} = #{{{=it.func.camel(field.defKey,false)}}}
  56.             </if>{{?}}
  57.         {{~}}
  58.         </where>
  59.     </select>
  60.     $blankline
  61.     <!--统计总行数-->
  62.     <select id="count" resultType="java.lang.Long">
  63.         select count(1)
  64.         from {{=it.entity.defKey}}
  65.         <where>
  66.             delete_flag = 0
  67.         {{~it.entity.fields:field:index}}
  68.             {{?field.defKey != 'delete_flag'}}<if test={{?field.type == 'Integer'}}"{{=it.func.camel(field.defKey,false)}} != null"{{??}}"{{=it.func.camel(field.defKey,false)}} != null and {{=it.func.camel(field.defKey,false)}} != ''"{{?}}>
  69.                 and {{?field.defKey == 'desc' || field.defKey == 'type' || field.defKey == 'key' || field.defKey == 'level'}}`{{=field.defKey}}`{{??}}{{=field.defKey}}{{?}} = #{{{=it.func.camel(field.defKey,false)}}}
  70.             </if>{{?}}
  71.         {{~}}
  72.         </where>
  73.     </select>
  74.     $blankline
  75.     <!--新增数据-->
  76.     <insert id="insert" keyProperty="{{=pkField}}" useGeneratedKeys="true">
  77.         insert into {{=it.entity.defKey}}({{=it.entity.fields.map(function(e,i){
  78.                 if (e.defKey == 'desc' || e.defKey == 'type' || e.defKey == 'key' || e.defKey == 'level') return '`'+e.defKey+'`';
  79.                 return e.defKey}).join(',')}})
  80.         values ({{=it.entity.fields.map(function(e,i){
  81.             if (e.defKey == 'create_date' || e.defKey == 'update_date') return 'now()';
  82.             if (e.defKey == 'delete_flag') return '0';
  83.             return '#{'+it.func.camel(e.defKey,false)+'}'}).join(',')}})
  84.     </insert>
  85.     $blankline
  86.     <!-- 批量新增数据 -->
  87.     <insert id="insertBatch" keyProperty="{{=pkField}}" useGeneratedKeys="true">
  88.         insert into {{=it.entity.defKey}}({{=it.entity.fields.map(function(e,i){
  89.                 if (e.defKey == 'desc' || e.defKey == 'type' || e.defKey == 'key' || e.defKey == 'level') return '`'+e.defKey+'`';
  90.                 return e.defKey}).join(',')}})
  91.         values
  92.         <foreach collection="entities" item="entity" separator=",">
  93.             ({{=it.entity.fields.map(function(e,i){
  94.             if (e.defKey == 'create_date' || e.defKey == 'update_date') return 'now()';
  95.             if (e.defKey == 'delete_flag') return '0';
  96.             return '#{entity.'+it.func.camel(e.defKey,false)+'}'}).join(',')}})
  97.         </foreach>
  98.     </insert>
  99.     $blankline
  100.     <!-- 批量新增或按主键更新数据 -->
  101.     <insert id="insertOrUpdateBatch" keyProperty="{{=pkField}}" useGeneratedKeys="true">
  102.         insert into {{=it.entity.defKey}}({{=it.entity.fields.map(function(e,i){
  103.                 if (e.defKey == 'desc' || e.defKey == 'type' || e.defKey == 'key' || e.defKey == 'level') return '`'+e.defKey+'`';
  104.                 return e.defKey}).join(',')}})
  105.         values
  106.         <foreach collection="entities" item="entity" separator=",">
  107.             ({{=it.entity.fields.map(function(e,i){
  108.             if (e.defKey == 'create_date' || e.defKey == 'update_date') return 'now()';
  109.             if (e.defKey == 'delete_flag') return '0';
  110.             return '#{entity.'+it.func.camel(e.defKey,false)+'}'}).join(',')}})
  111.         </foreach>
  112.         on duplicate key update
  113.         {{=it.entity.fields.filter(function(e){
  114.             if (e.defKey == 'create_date' || e.defKey == 'delete_flag')
  115.                 return false;
  116.             return true;    
  117.         }).map(function(e,i){
  118.             if (e.defKey == 'update_date') 
  119.                 return 'update_date=now()';
  120.             if (e.defKey == 'desc' || e.defKey == 'type' || e.defKey == 'key' || e.defKey == 'level') 
  121.                 return '`' + e.defKey + '`' + '=values('+e.defKey+')' ;
  122.             return e.defKey + '=values('+it.func.camel(e.defKey,false)+')';}).join(',\n\t\t')
  123.         }}
  124.     </insert>
  125.     $blankline
  126.     <!-- 更新数据 -->
  127.     <update id="update">
  128.         update {{=it.entity.defKey}}
  129.         <set>
  130.         {{~it.entity.fields:field:index}}
  131.             {{?field.defKey != 'create_date' && field.defKey != 'update_date'}}<if test={{?field.type == 'Integer'}}"{{=it.func.camel(field.defKey,false)}} != null"{{??}}"{{=it.func.camel(field.defKey,false)}} != null and {{=it.func.camel(field.defKey,false)}} != ''"{{?}}>
  132.                 {{?field.defKey == 'desc' || field.defKey == 'type' || field.defKey == 'key' || field.defKey == 'level'}}`{{=field.defKey}}`{{??}}{{=field.defKey}}{{?}} = #{{{=it.func.camel(field.defKey,false)}}},
  133.             </if>{{??}} {{continue;}} {{?}}
  134.         {{~}}
  135.             update_date=now()
  136.         </set>
  137.         where {{=pkField}} = #{{{=pkVarName}}}
  138.     </update>
  139.     $blankline
  140.     <!--通过主键删除-->
  141.     <delete id="deleteById">
  142.         update {{=it.entity.defKey}} set update_date = now(), delete_flag = 1 where {{=pkField}} = #{{{=pkVarName}}}
  143.     </delete>
  144.     <!--↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑模板生成的基础方法↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑-->
  145.     $blankline
  146.     <!--↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓自定义方法↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓-->
  147.     $blankline
  148.     <!--↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑自定义方法↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑↑-->
  149. </mapper>
  150.

Entity

  1. {{  var today=new Date();
  2.     var fullYear=today.getFullYear();
  3.     var month=today.getMonth() + 1;
  4.     var days=today.getDate();
  5.     
  6.     var pkVarName = "id";
  7.     var pkDataType = "String";
  8.     it.entity.fields.forEach(function(field){
  9.         if(field.primaryKey){
  10.             pkVarName = it.func.camel(field.defKey,false);
  11.             pkDataType = field["type"];
  12.             return;
  13.         }
  14.     });
  15.     
  16.     var pkgName = it.entity.env.base.nameSpace;
  17.     var beanClass = it.entity.env.base.codeRoot;
  18.     var beanVarName = beanClass.charAt(0).toLowerCase()+beanClass.slice(1);
  19.     var serviceClass = beanClass+'Service';
  20.     var serviceVarName= beanVarName+'Service';
  21.     
  22. }}package {{=pkgName}}.beans.entity;
  23. $blankline
  24. import java.io.Serializable;
  25. import java.util.Date;
  26. $blankline
  27.  
  28.  /**
  29.  * {{=it.entity.defName}};{{=it.entity.comment}}
  30.  * @author : name
  31.  * @date : {{=fullYear}}-{{=month}}-{{=days}}
  32.  */
  33. public class {{=beanClass}} implements Serializable,Cloneable{
  34. {{~it.entity.fields:field:index}}
  35.     /** {{=it.func.join(field.defName,field.comment,';')}} */
  36.     private {{=field.type}} {{=it.func.camel(field.defKey,false)}} ;
  37. {{~}}
  38. $blankline
  39.  
  40. {{~it.entity.fields:field:index}}
  41.     /** {{=it.func.join(field.defName,field.comment,';')}} */
  42.     public {{=field.type}} get{{=it.func.camel(field.defKey,true)}}(){
  43.         return this.{{=it.func.camel(field.defKey,false)}};
  44.     }
  45.     /** {{=it.func.join(field.defName,field.comment,';')}} */
  46.     public void set{{=it.func.camel(field.defKey,true)}}({{=field.type}} {{= it.func.camel(field.defKey,false) }}){
  47.         this.{{=it.func.camel(field.defKey,false)}}={{=it.func.camel(field.defKey,false)}};
  48.     }
  49. {{~}}
  50. }

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/你好赵伟/article/detail/796295
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号