• MybatisX快速开发插件模版扩展

    ​​​​​​官方文档  MybatisX快速开发插件 | MyBatis-Plus

    MybatisX 是一款基于 IDEA 的快速开发插件，为效率而生。

    安装方法：打开 IDEA，进入 File -> Settings -> Plugins -> Browse Repositories，输入 mybatisx 搜索并安装。

    一. 模版修改

    官方生成的模版少了service，以及部分方法的定义，所以我在官方的基础上加了加了service模版以及底层方法的补充。主要修改的是default-all文件夹下的模版文件，具体如下：

    .meta.xml 修改后代码

    2. <templates>
    3.     <template>
    4.         <property name="configName" value="serviceInterface"/>
    5.         <property name="configFile" value="serviceInterface.ftl"/>
    6.         <property name="fileName" value="${domain.fileName}Service"/>
    7.         <property name="suffix" value=".java"/>
    8.         <property name="packageName" value="${domain.basePackage}.service"/>
    9.         <property name="encoding" value="${domain.encoding}"/>
    10.         <property name="basePath" value="${domain.basePath}"/>
    11.     template>
    12.     <template>
    13.         <property name="configName" value="serviceImpl"/>
    14.         <property name="configFile" value="serviceImpl.ftl"/>
    15.         <property name="fileName" value="${domain.fileName}ServiceImpl"/>
    16.         <property name="suffix" value=".java"/>
    17.         <property name="packageName" value="${domain.basePackage}.service.impl"/>
    18.         <property name="encoding" value="${domain.encoding}"/>
    19.         <property name="basePath" value="${domain.basePath}"/>
    20.     template>
    21.     <template>
    22.         <property name="configName" value="mapperInterface"/>
    23.         <property name="configFile" value="mapperInterface.ftl"/>
    24.         <property name="fileName" value="${domain.fileName}Mapper"/>
    25.         <property name="suffix" value=".java"/>
    26.         <property name="packageName" value="${domain.basePackage}.mapper"/>
    27.         <property name="encoding" value="${domain.encoding}"/>
    28.         <property name="basePath" value="${domain.basePath}"/>
    29.     template>
    30.     <template>
    31.         <property name="configName" value="mapperXml"/>
    32.         <property name="configFile" value="mapperXml.ftl"/>
    33.         <property name="fileName" value="${domain.fileName}Mapper"/>
    34.         <property name="suffix" value=".xml"/>
    35.         <property name="packageName" value="mapper"/>
    36.         <property name="encoding" value="${domain.encoding}"/>
    37.         <property name="basePath" value="src/main/resources"/>
    38.     template>
    39. templates>

    mapperXml.ftl 修改后代码

    1. "1.0" encoding="UTF-8"?>
    3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. "${mapperInterface.packageName}.${baseInfo.fileName}">
    6.  
    7.     id="BaseResultMap" type="${tableClass.fullClassName}">
    8.         <#list tableClass.pkFields as field>
    9.             <id property="${field.fieldName}" column="${field.columnName}" jdbcType="${field.jdbcType}"/>
    10.         #list>
    11.         <#list tableClass.baseFields as field>
    12.             "${field.fieldName}" column="${field.columnName}" jdbcType="${field.jdbcType}"/>
    13.         #list>
    14.     
    15.  
    16.     id="Base_Column_List">
    17.         <#list tableClass.allFields as field>${field.columnName}<#sep>,<#if field_index%3==2>${"\n        "}
    18.     
    19.  
    20.     
    21.  
    22.     
    23.  
    24.     
    25.  
    26.     id="queryCondition">
    27.         <#list tableClass.allFields as field>
    28.             <if test="${field.fieldName} != null">and ${field.columnName} = ${'#'}{${field.fieldName},jdbcType=${field.jdbcType}}
    29.         #list>
    30.     
    31.  
    32.     id="deleteByPrimaryKey" parameterType="java.lang.Long">
    33.         delete from ${tableClass.tableName}
    34.         where <#list tableClass.pkFields as field> ${field.columnName} = ${'#'}{${field.fieldName},jdbcType=${field.jdbcType}} <#if field_has_next>AND
    35.     
    36.  
    37.     id="insert"<#if (tableClass.pkFields?size==1)> keyColumn="${tableClass.pkFields[0].columnName}" keyProperty="${tableClass.pkFields[0].fieldName}" parameterType="${tableClass.fullClassName}" useGeneratedKeys="true">
    38.         insert into ${tableClass.tableName}
    39.         "(" suffix=")" suffixOverrides=",">
    40.             <#list tableClass.allFields as field>
    41.                 <if test="${field.fieldName} != null">${field.columnName},
    42.             #list>
    43.         
    44.         "values (" suffix=")" suffixOverrides=",">
    45.             <#list tableClass.allFields as field>
    46.                 <if test="${field.fieldName} != null">${'#'}{${field.fieldName},jdbcType=${field.jdbcType}},
    47.             #list>
    48.         
    49.     
    50.  
    51.     id="update" parameterType="${tableClass.fullClassName}">
    52.         update ${tableClass.tableName}
    53.         <set>
    54.             <#list tableClass.baseBlobFields as field>
    55.                 <if test="${field.fieldName} != null">
    56.                     ${field.columnName} = ${'#'}{${field.fieldName},jdbcType=${field.jdbcType}},
    57.                 
    58.             #list>
    59.         
    60.         where  <#list tableClass.pkFields as field> ${field.columnName} = ${'#'}{${field.fieldName},jdbcType=${field.jdbcType}} <#if field_has_next>AND
    61.     
    62.

    mapperInterface.ftl  修改后代码

    1. package ${mapperInterface.packageName};
    2.  
    3. import ${tableClass.fullClassName};
    4. import java.util.List;
    5.  
    6. /**
    7. * @author ${author!}
    8. * @description 针对表【${tableClass.tableName}<#if tableClass.remark?has_content>(${tableClass.remark!})】的数据库操作Mapper
    9. * @createDate ${.now?string('yyyy-MM-dd HH:mm:ss')}
    10. * @Entity ${tableClass.fullClassName}
    11. */
    12. public interface ${mapperInterface.fileName} {
    13.  
    14.     int deleteByPrimaryKey(Long id);
    15.  
    16.     int insert(${tableClass.shortClassName} record);
    17.  
    18.     ${tableClass.shortClassName} selectDetail(${tableClass.shortClassName} record);
    19.  
    20.     List<${tableClass.shortClassName}> selectList(${tableClass.shortClassName} record);
    21.  
    22.     int selectCount(${tableClass.shortClassName} record);
    23.  
    24.     int update(${tableClass.shortClassName} record);
    25. }

    serviceInterface.ftl  修改后代码

    1. package ${baseInfo.packageName};
    2.  
    3. import ${tableClass.fullClassName};
    4. <#if baseService??&&baseService!="">
    5.     import ${baseService};
    6.     <#list baseService?split(".") as simpleName>
    7.         <#if !simpleName_has_next>
    8.             <#assign serviceSimpleName>${simpleName}
    9.         #if>
    10.     #list>
    11. #if>
    12. import java.util.List;
    13.  
    14. /**
    15. * @author ${author!}
    16. * @description 针对表【${tableClass.tableName}<#if tableClass.remark?has_content>(${tableClass.remark!})】的数据库操作Service
    17. * @createDate ${.now?string('yyyy-MM-dd HH:mm:ss')}
    18. */
    19. public interface ${baseInfo.fileName} {
    20.  
    21.     public int deleteByPrimaryKey(Long id);
    22.  
    23.     public int insert(${tableClass.shortClassName} record);
    24.  
    25.     public ${tableClass.shortClassName} selectDetail(${tableClass.shortClassName} record);
    26.  
    27.     public List<${tableClass.shortClassName}> selectList(${tableClass.shortClassName} record);
    28.  
    29.     public int selectCount(${tableClass.shortClassName} record);
    30.  
    31.     public int update(${tableClass.shortClassName} record);
    32. }

    serviceImpl.ftl 修改后代码

    1. package ${baseInfo.packageName};
    2.  
    3. import ${tableClass.fullClassName};
    4. import ${serviceInterface.packageName}.${serviceInterface.fileName};
    5. import ${mapperInterface.packageName}.${mapperInterface.fileName};
    6. <#if baseService??&&baseService!="">
    7. import ${baseService};
    8.     <#list baseService?split(".") as simpleName>
    9.         <#if !simpleName_has_next>
    10.             <#assign serviceSimpleName>${simpleName}
    11.         if>
    12.     
    13. if>
    14. import org.springframework.stereotype.Service;
    15. import org.springframework.beans.factory.annotation.Autowired;
    16. import java.util.List;
    17.  
    18. /**
    19. * @author ${author!}
    20. * @description 针对表【${tableClass.tableName}<#if tableClass.remark?has_content>(${tableClass.remark!})】的数据库操作Service实现
    21. * @createDate ${.now?string('yyyy-MM-dd HH:mm:ss')}
    22. */
    23. @Service
    24. public class ${serviceImpl.fileName} implements ${serviceInterface.fileName}{
    25.  
    26.     @Autowired
    27.     private ${mapperInterface.fileName} dao;
    28.  
    29.     public int deleteByPrimaryKey(Long id) {
    30.         return dao.deleteByPrimaryKey(id);
    31.     }
    32.  
    33.     public int insert(${tableClass.shortClassName} record) {
    34.         return dao.insert(record);
    35.     }
    36.  
    37.     public ${tableClass.shortClassName} selectDetail(${tableClass.shortClassName} record) {
    38.         return dao.selectDetail(record);
    39.     }
    40.  
    41.     public List<${tableClass.shortClassName}> selectList(${tableClass.shortClassName} record) {
    42.         return dao.selectList(record);
    43.     }
    44.  
    45.     public int selectCount(${tableClass.shortClassName} record) {
    46.         return dao.selectCount(record);
    47.     }
    48.  
    49.     public int update(${tableClass.shortClassName} record) {
    50.         return dao.update(record);
    51.     }
    52. }
    53.  
    54.  
    55.  
    56.

    二. 代码生成步骤：

    接下来看下使用：

    三. 查看生成的代码 

    domain文件jxzCustomer

    1. package com.train.domain;
    2.  
    3. import java.io.Serializable;
    4. import lombok.Data;
    5.  
    6. /**
    7.  * 客户列表
    8.  * @TableName jxzCustomer
    9.  */
    10. @Data
    11. public class jxzCustomer implements Serializable {
    12.  
    13.     private static final long serialVersionUID = -4294857523757350782L;  // 后面手动修改的，默认是1
    14.     /**
    15.      * 主键
    16.      */
    17.     private Long customerId;
    18.  
    19.     /**
    20.      * 客户编码
    21.      */
    22.     private String customerCode;
    23.  
    24.     /**
    25.      * 客户名称
    26.      */
    27.     private String customerName;
    28.  
    29.     /**
    30.      * 简称
    31.      */
    32.     private String shortName;
    33. }

    jxzCustomerMapper.xml

    2. mapper
    3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. <mapper namespace="com.train.mapper.jxzCustomerMapper">
    6.  
    7.     <resultMap id="BaseResultMap" type="com.train.domain.jxzCustomer">
    8.             <id property="customerId" column="customerId" jdbcType="BIGINT"/>
    9.             <result property="customerCode" column="customerCode" jdbcType="VARCHAR"/>
    10.             <result property="customerName" column="customerName" jdbcType="VARCHAR"/>
    11.             <result property="shortName" column="shortName" jdbcType="VARCHAR"/>
    12.     resultMap>
    13.  
    14.     <sql id="Base_Column_List">
    15.         customerId,customerCode,customerName,
    16.         shortName
    17.     sql>
    18.  
    19.     <select id="selectDetail" parameterType="com.train.domain.jxzCustomer" resultType="com.train.domain.jxzCustomer">
    20.         select * from jxzCustomer
    21.         <where>
    22.             <include refid="queryCondition">include>
    23.         where>
    24.         limit 1
    25.     select>
    26.  
    27.     <select id="selectCount" parameterType="com.train.domain.jxzCustomer" resultType="java.lang.Integer">
    28.         select count(1) from jxzCustomer
    29.         <where>
    30.             <include refid="queryCondition">include>
    31.         where>
    32.     select>
    33.  
    34.     <select id="selectList" parameterType="com.train.domain.jxzCustomer" resultType="com.train.domain.jxzCustomer">
    35.         select * from jxzCustomer
    36.         <where>
    37.             <include refid="queryCondition">include>
    38.         where>
    39.     select>
    40.  
    41.     <sql id="queryCondition">
    42.             <if test="customerId != null">and customerId = #{customerId,jdbcType=BIGINT},if>
    43.             <if test="customerCode != null">and customerCode = #{customerCode,jdbcType=VARCHAR},if>
    44.             <if test="customerName != null">and customerName = #{customerName,jdbcType=VARCHAR},if>
    45.             <if test="shortName != null">and shortName = #{shortName,jdbcType=VARCHAR},if>
    46.     sql>
    47.  
    48.     <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
    49.         delete from jxzCustomer
    50.         where  customerId = #{customerId,jdbcType=BIGINT} 
    51.     delete>
    52.  
    53.     <insert id="insert" keyColumn="customerId" keyProperty="customerId" parameterType="com.train.domain.jxzCustomer" useGeneratedKeys="true">
    54.         insert into jxzCustomer
    55.         <trim prefix="(" suffix=")" suffixOverrides=",">
    56.                 <if test="customerId != null">customerId,if>
    57.                 <if test="customerCode != null">customerCode,if>
    58.                 <if test="customerName != null">customerName,if>
    59.                 <if test="shortName != null">shortName,if>
    60.         trim>
    61.         <trim prefix="values (" suffix=")" suffixOverrides=",">
    62.                 <if test="customerId != null">#{customerId,jdbcType=BIGINT},if>
    63.                 <if test="customerCode != null">#{customerCode,jdbcType=VARCHAR},if>
    64.                 <if test="customerName != null">#{customerName,jdbcType=VARCHAR},if>
    65.                 <if test="shortName != null">#{shortName,jdbcType=VARCHAR},if>
    66.         trim>
    67.     insert>
    68.  
    69.     <update id="update" parameterType="com.train.domain.jxzCustomer">
    70.         update jxzCustomer
    71.         <set>
    72.                 <if test="customerCode != null">
    73.                     customerCode = #{customerCode,jdbcType=VARCHAR},
    74.                 if>
    75.                 <if test="customerName != null">
    76.                     customerName = #{customerName,jdbcType=VARCHAR},
    77.                 if>
    78.                 <if test="shortName != null">
    79.                     shortName = #{shortName,jdbcType=VARCHAR},
    80.                 if>
    81.         set>
    82.         where   customerId = #{customerId,jdbcType=BIGINT} 
    83.     update>
    84.  
    85. mapper>
    jxzCustomerMapper
    1. package com.train.mapper;
    2.  
    3. import com.train.domain.jxzCustomer;
    4. import java.util.List;
    5.  
    6. /**
    7. * @author sunww
    8. * @description 针对表【jxzCustomer(客户列表)】的数据库操作Mapper
    9. * @createDate 2022-08-02 15:36:15
    10. * @Entity com.train.domain.jxzCustomer
    11. */
    12. public interface jxzCustomerMapper {
    13.  
    14.     int deleteByPrimaryKey(Long id);
    15.  
    16.     int insert(jxzCustomer record);
    17.  
    18.     jxzCustomer selectDetail(jxzCustomer record);
    19.  
    20.     List selectList(jxzCustomer record);
    21.  
    22.     int selectCount(jxzCustomer record);
    23.  
    24.     int update(jxzCustomer record);
    25. }
    jxzCustomerService
    1. package com.train.service;
    2.  
    3. import com.train.domain.jxzCustomer;
    4. import java.util.List;
    5.  
    6. /**
    7. * @author sunww
    8. * @description 针对表【jxzCustomer(客户列表)】的数据库操作Service
    9. * @createDate 2022-08-02 15:36:15
    10. */
    11. public interface jxzCustomerService {
    12.  
    13.     public int deleteByPrimaryKey(Long id);
    14.  
    15.     public int insert(jxzCustomer record);
    16.  
    17.     public jxzCustomer selectDetail(jxzCustomer record);
    18.  
    19.     public List selectList(jxzCustomer record);
    20.  
    21.     public int selectCount(jxzCustomer record);
    22.  
    23.     public int update(jxzCustomer record);
    24. }
    jxzCustomerServiceImpl
    1. package com.train.service.impl;
    2.  
    3. import com.train.domain.jxzCustomer;
    4. import com.train.service.jxzCustomerService;
    5. import com.train.mapper.jxzCustomerMapper;
    6. import org.springframework.stereotype.Service;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import java.util.List;
    9.  
    10. /**
    11. * @author sunww
    12. * @description 针对表【jxzCustomer(客户列表)】的数据库操作Service实现
    13. * @createDate 2022-08-02 15:36:15
    14. */
    15. @Service
    16. public class jxzCustomerServiceImpl implements jxzCustomerService{
    17.  
    18.     @Autowired
    19.     private jxzCustomerMapper dao;
    20.  
    21.     public int deleteByPrimaryKey(Long id) {
    22.         return dao.deleteByPrimaryKey(id);
    23.     }
    24.  
    25.     public int insert(jxzCustomer record) {
    26.         return dao.insert(record);
    27.     }
    28.  
    29.     public jxzCustomer selectDetail(jxzCustomer record) {
    30.         return dao.selectDetail(record);
    31.     }
    32.  
    33.     public List selectList(jxzCustomer record) {
    34.         return dao.selectList(record);
    35.     }
    36.  
    37.     public int selectCount(jxzCustomer record) {
    38.         return dao.selectCount(record);
    39.     }
    40.  
    41.     public int update(jxzCustomer record) {
    42.         return dao.update(record);
    43.     }
    44. }
    45.  
    46.  
    47.  
    48.  
     

    
                
    
                    
    
                
    • 

                
  • 

                    相关阅读:
    
                    
MySQL的下载、安装、配置                            
    
基于springboot+Redis的前后端分离项目之分布式锁（四）-【黑马点评】                            
    
shiro的实现认证                            
    
贴片天线的特征模分析及其应用                            
    
Android学习笔记 70. 学会帮助自己【自理】                            
    
【英雄哥六月集训】第 30天: 拓扑排序                            
    
CI/CD -gitlab                            
    
初刷leetcode题目(5)——数据结构与算法                            
    
LibOpenCM3(二) 项目模板 Makefile分析                            
    
高德地图系列（四）：vue项目利用高德地图实现车辆的路线规划                            
    
                        
                
    • 
                
  • 
                    原文地址：https://blog.csdn.net/robinson_911/article/details/126125160
                
    •