• 第3章业务功能开发（创建mybatis的逆向工程）

    1.mybatis逆向工程：
      1)简介：根据表生成mapper层三部分代码：实体类，mapper接口，映射文件。
      2)使用mybatis逆向工程：
        a)创建工程:crm-mybatis-generator


        b)添加插件：

    pom.xml文件

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <modelVersion>4.0.0</modelVersion>
    6.  
    7.     <groupId>com.it.crm</groupId>
    8.     <artifactId>crm-mybatis-generator</artifactId>
    9.     <version>1.0-SNAPSHOT</version>
    10.  
    11.     <build>
    12.         <plugins>
    13.             <!--myBatis逆向工程插件-->
    14.             <plugin>
    15.                 <groupId>org.mybatis.generator</groupId>
    16.                 <artifactId>mybatis-generator-maven-plugin</artifactId>
    17.                 <version>1.3.2</version>
    18.                 <configuration>
    19.                     <verbose>true</verbose>
    20.                     <overwrite>true</overwrite>
    21.                 </configuration>
    22.             </plugin>
    23.         </plugins>
    24.     </build>
    25.  
    26.  
    27. </project>


       c)添加配置文件：
         数据库连接信息

    generator.properties配置文件

    jdbc.driverLocation：代表Maven仓库中mql的驱动文件的位置

    1. jdbc.driverLocation=D:/jsp/Maven/MavenTest/repository/mysql/mysql-connector-java/5.1.43/mysql-connector-java-5.1.43.jar
    2. jdbc.driverClass=com.mysql.jdbc.Driver
    3. jdbc.connectionURL=jdbc:mysql://127.0.0.1:3306/db_crm_ssm
    4. jdbc.userId=root
    5. jdbc.password=123456

        generatorConfig.xml配置文件

    当前把需要逆向生成的表全部已经写好了，需要逆向生成那些表就放出来那些表，已经生成过的需要再关进去。现在只需要逆向生成tbl_user表

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <!DOCTYPE generatorConfiguration
    3.         PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    5.  
    6. <generatorConfiguration>
    7.  
    8.     <!--指定mysql数据库驱动-->
    9.     <!--<classPathEntry location="E://repository-p2p//mysql//mysql-connector-java//5.1.43//mysql-connector-java-5.1.43.jar"/>-->
    10.  
    11.     <!--导入属性配置-->
    12.     <properties resource="generator.properties"></properties>
    13.  
    14.     <!--指定特定数据库的jdbc驱动jar包的位置-->
    15.     <classPathEntry location="${jdbc.driverLocation}"/>
    16.  
    17.     <context id="default" targetRuntime="MyBatis3">
    18.  
    19.         <!-- optional，旨在创建class时，对注释进行控制，false生成注释,true无注释 -->
    20.         <commentGenerator>
    21.             <property name="suppressDate" value="false"/>
    22.             <property name="suppressAllComments" value="false"/>
    23.         </commentGenerator>
    24.  
    25.         <!--jdbc的数据库连接 -->
    26.         <jdbcConnection
    27.                 driverClass="${jdbc.driverClass}"
    28.                 connectionURL="${jdbc.connectionURL}"
    29.                 userId="${jdbc.userId}"
    30.                 password="${jdbc.password}">
    31.         </jdbcConnection>
    32.  
    33.  
    34.         <!-- 非必需，类型处理器，在数据库类型和java类型之间的转换控制-->
    35.         <javaTypeResolver>
    36.             <property name="forceBigDecimals" value="false"/>
    37.         </javaTypeResolver>
    38.  
    39.  
    40.         <!-- Model模型生成器,用来生成含有主键key的类，记录类 以及查询Example类
    41.             targetPackage     指定生成的model生成所在的包名
    42.             targetProject     指定在该项目下所在的路径|指定生成到的工程名称
    43.         -->
    44.         <javaModelGenerator targetPackage="com.it.crm.settings.entity"
    45.                             targetProject="D:/SSM框架/SSM版CRMTest/crm/src/main/java">
    46.  
    47.             <!-- 是否允许子包，即targetPackage.schemaName.tableName -->
    48.             <property name="enableSubPackages" value="false"/>
    49.             <!-- 是否对model添加 构造函数 true添加，false不添加-->
    50.             <property name="constructorBased" value="false"/>
    51.             <!-- 是否对类CHAR类型的列的数据进行trim操作 -->
    52.             <property name="trimStrings" value="true"/>
    53.             <!-- 建立的Model对象是否 不可改变  即生成的Model对象不会有 setter方法，只有构造方法 -->
    54.             <property name="immutable" value="false"/>
    55.         </javaModelGenerator>
    56.  
    57.         <!--Mapper映射文件生成所在的目录 为每一个数据库的表生成对应的SqlMap文件 -->
    58.         <sqlMapGenerator targetPackage="com.it.crm.settings.mapper"
    59.                          targetProject="D:/SSM框架/SSM版CRMTest/crm/src/main/java">
    60.             <property name="enableSubPackages" value="false"/>
    61.         </sqlMapGenerator>
    62.  
    63.         <!-- 客户端代码，生成易于使用的针对Model对象和XML配置文件 的代码
    64.                 type="ANNOTATEDMAPPER",生成Java Model 和基于注解的Mapper对象
    65.                 type="MIXEDMAPPER",生成基于注解的Java Model 和相应的Mapper对象
    66.                 type="XMLMAPPER",生成SQLMap XML文件和独立的Mapper接口
    67.         -->
    68.         <javaClientGenerator targetPackage="com.it.crm.settings.mapper"
    69.                              targetProject="D:/SSM框架/SSM版CRMTest/crm/src/main/java" type="XMLMAPPER">
    70.             <property name="enableSubPackages" value="true"/>
    71.         </javaClientGenerator>
    72.  
    73.  
    74.         <table tableName="tbl_user" domainObjectName="User"
    75.                enableCountByExample="false" enableUpdateByExample="false"
    76.                enableDeleteByExample="false" enableSelectByExample="false"
    77.                selectByExampleQueryId="false">
    78.         </table>
    79.  
    80.         <!--
    81.                <table tableName="tbl_clue" domainObjectName="Clue"
    82.                       enableCountByExample="false" enableUpdateByExample="false"
    83.                       enableDeleteByExample="false" enableSelectByExample="false"
    84.                       selectByExampleQueryId="false">
    85.                </table>
    87.                <table tableName="tbl_clue_activity_relation" domainObjectName="ClueActivityRelation"
    88.                       enableCountByExample="false" enableUpdateByExample="false"
    89.                       enableDeleteByExample="false" enableSelectByExample="false"
    90.                       selectByExampleQueryId="false">
    91.                </table>
    93.                <table tableName="tbl_clue_remark" domainObjectName="ClueRemark"
    94.                       enableCountByExample="false" enableUpdateByExample="false"
    95.                       enableDeleteByExample="false" enableSelectByExample="false"
    96.                       selectByExampleQueryId="false">
    97.                </table>
    98.                -->
    99.         <!--
    100.         <table tableName="tbl_contacts" domainObjectName="Contacts"
    101.                enableCountByExample="false" enableUpdateByExample="false"
    102.                enableDeleteByExample="false" enableSelectByExample="false"
    103.                selectByExampleQueryId="false">
    104.         </table>
    105.         <table tableName="tbl_contacts_activity_relation" domainObjectName="ContactsActivityRelation"
    106.                enableCountByExample="false" enableUpdateByExample="false"
    107.                enableDeleteByExample="false" enableSelectByExample="false"
    108.                selectByExampleQueryId="false">
    109.         </table>
    110.         <table tableName="tbl_contacts_remark" domainObjectName="ContactsRemark"
    111.                enableCountByExample="false" enableUpdateByExample="false"
    112.                enableDeleteByExample="false" enableSelectByExample="false"
    113.                selectByExampleQueryId="false">
    114.         </table>
    115.         -->
    116.         <!--
    117.         <table tableName="tbl_customer" domainObjectName="Customer"
    118.                enableCountByExample="false" enableUpdateByExample="false"
    119.                enableDeleteByExample="false" enableSelectByExample="false"
    120.                selectByExampleQueryId="false">
    121.         </table>
    123.         <table tableName="tbl_customer_remark" domainObjectName="CustomerRemark"
    124.                enableCountByExample="false" enableUpdateByExample="false"
    125.                enableDeleteByExample="false" enableSelectByExample="false"
    126.                selectByExampleQueryId="false">
    127.         </table>
    128.         -->
    129.         <!--
    130.                 <table tableName="tbl_dictionary_type" domainObjectName="DictionaryType"
    131.                        enableCountByExample="false" enableUpdateByExample="false"
    132.                        enableDeleteByExample="false" enableSelectByExample="false"
    133.                        selectByExampleQueryId="false">
    134.                 </table>
    137.                 <table tableName="tbl_dictionary_value" domainObjectName="DictionaryValue"
    138.                        enableCountByExample="false" enableUpdateByExample="false"
    139.                        enableDeleteByExample="false" enableSelectByExample="false"
    140.                        selectByExampleQueryId="false">
    141.                 </table>
    144.                 <table tableName="tbl_marketing_activities" domainObjectName="MarketingActivities"
    145.                        enableCountByExample="false" enableUpdateByExample="false"
    146.                        enableDeleteByExample="false" enableSelectByExample="false"
    147.                        selectByExampleQueryId="false">
    148.                 </table>
    151.                 <table tableName="tbl_marketing_activities_remark" domainObjectName="MarketingActivitiesRemark"
    152.                        enableCountByExample="false" enableUpdateByExample="false"
    153.                        enableDeleteByExample="false" enableSelectByExample="false"
    154.                        selectByExampleQueryId="false">
    155.                 </table>
    158.         <table tableName="tbl_transaction" domainObjectName="Transaction"
    159.                enableCountByExample="false" enableUpdateByExample="false"
    160.                enableDeleteByExample="false" enableSelectByExample="false"
    161.                selectByExampleQueryId="false">
    162.         </table>
    163.         <table tableName="tbl_transaction_history" domainObjectName="TransactionHistory"
    164.                enableCountByExample="false" enableUpdateByExample="false"
    165.                enableDeleteByExample="false" enableSelectByExample="false"
    166.                selectByExampleQueryId="false">
    167.         </table>
    168.         <table tableName="tbl_transaction_remark" domainObjectName="TransactionRemark"
    169.                enableCountByExample="false" enableUpdateByExample="false"
    170.                enableDeleteByExample="false" enableSelectByExample="false"
    171.                selectByExampleQueryId="false">
    172.         </table>
    173. -->
    174.     </context>
    175. </generatorConfiguration>


       d)运行mybatis的逆向工程，根据指定表生成java代码，保存到指定的目录中。

    双击蓝色阴影的插件

     

    自动在crm项目中生成了这三个文件，实体类，用户接口，用户接口的映射文件。

    User实体类

    1. package com.it.crm.settings.entity;
    2.  
    3. public class User {
    4.     /**
    5.      * This field was generated by MyBatis Generator.
    6.      * This field corresponds to the database column tbl_user.id
    7.      *
    8.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    9.      */
    10.     private String id;
    11.  
    12.     /**
    13.      * This field was generated by MyBatis Generator.
    14.      * This field corresponds to the database column tbl_user.login_act
    15.      *
    16.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    17.      */
    18.     private String loginAct;
    19.  
    20.     /**
    21.      * This field was generated by MyBatis Generator.
    22.      * This field corresponds to the database column tbl_user.name
    23.      *
    24.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    25.      */
    26.     private String name;
    27.  
    28.     /**
    29.      * This field was generated by MyBatis Generator.
    30.      * This field corresponds to the database column tbl_user.login_pwd
    31.      *
    32.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    33.      */
    34.     private String loginPwd;
    35.  
    36.     /**
    37.      * This field was generated by MyBatis Generator.
    38.      * This field corresponds to the database column tbl_user.email
    39.      *
    40.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    41.      */
    42.     private String email;
    43.  
    44.     /**
    45.      * This field was generated by MyBatis Generator.
    46.      * This field corresponds to the database column tbl_user.expire_time
    47.      *
    48.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    49.      */
    50.     private String expireTime;
    51.  
    52.     /**
    53.      * This field was generated by MyBatis Generator.
    54.      * This field corresponds to the database column tbl_user.lock_state
    55.      *
    56.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    57.      */
    58.     private String lockState;
    59.  
    60.     /**
    61.      * This field was generated by MyBatis Generator.
    62.      * This field corresponds to the database column tbl_user.deptno
    63.      *
    64.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    65.      */
    66.     private String deptno;
    67.  
    68.     /**
    69.      * This field was generated by MyBatis Generator.
    70.      * This field corresponds to the database column tbl_user.allow_ips
    71.      *
    72.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    73.      */
    74.     private String allowIps;
    75.  
    76.     /**
    77.      * This field was generated by MyBatis Generator.
    78.      * This field corresponds to the database column tbl_user.createTime
    79.      *
    80.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    81.      */
    82.     private String createtime;
    83.  
    84.     /**
    85.      * This field was generated by MyBatis Generator.
    86.      * This field corresponds to the database column tbl_user.create_by
    87.      *
    88.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    89.      */
    90.     private String createBy;
    91.  
    92.     /**
    93.      * This field was generated by MyBatis Generator.
    94.      * This field corresponds to the database column tbl_user.edit_time
    95.      *
    96.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    97.      */
    98.     private String editTime;
    99.  
    100.     /**
    101.      * This field was generated by MyBatis Generator.
    102.      * This field corresponds to the database column tbl_user.edit_by
    103.      *
    104.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    105.      */
    106.     private String editBy;
    107.  
    108.     /**
    109.      * This method was generated by MyBatis Generator.
    110.      * This method returns the value of the database column tbl_user.id
    111.      *
    112.      * @return the value of tbl_user.id
    113.      *
    114.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    115.      */
    116.     public String getId() {
    117.         return id;
    118.     }
    119.  
    120.     /**
    121.      * This method was generated by MyBatis Generator.
    122.      * This method sets the value of the database column tbl_user.id
    123.      *
    124.      * @param id the value for tbl_user.id
    125.      *
    126.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    127.      */
    128.     public void setId(String id) {
    129.         this.id = id == null ? null : id.trim();
    130.     }
    131.  
    132.     /**
    133.      * This method was generated by MyBatis Generator.
    134.      * This method returns the value of the database column tbl_user.login_act
    135.      *
    136.      * @return the value of tbl_user.login_act
    137.      *
    138.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    139.      */
    140.     public String getLoginAct() {
    141.         return loginAct;
    142.     }
    143.  
    144.     /**
    145.      * This method was generated by MyBatis Generator.
    146.      * This method sets the value of the database column tbl_user.login_act
    147.      *
    148.      * @param loginAct the value for tbl_user.login_act
    149.      *
    150.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    151.      */
    152.     public void setLoginAct(String loginAct) {
    153.         this.loginAct = loginAct == null ? null : loginAct.trim();
    154.     }
    155.  
    156.     /**
    157.      * This method was generated by MyBatis Generator.
    158.      * This method returns the value of the database column tbl_user.name
    159.      *
    160.      * @return the value of tbl_user.name
    161.      *
    162.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    163.      */
    164.     public String getName() {
    165.         return name;
    166.     }
    167.  
    168.     /**
    169.      * This method was generated by MyBatis Generator.
    170.      * This method sets the value of the database column tbl_user.name
    171.      *
    172.      * @param name the value for tbl_user.name
    173.      *
    174.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    175.      */
    176.     public void setName(String name) {
    177.         this.name = name == null ? null : name.trim();
    178.     }
    179.  
    180.     /**
    181.      * This method was generated by MyBatis Generator.
    182.      * This method returns the value of the database column tbl_user.login_pwd
    183.      *
    184.      * @return the value of tbl_user.login_pwd
    185.      *
    186.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    187.      */
    188.     public String getLoginPwd() {
    189.         return loginPwd;
    190.     }
    191.  
    192.     /**
    193.      * This method was generated by MyBatis Generator.
    194.      * This method sets the value of the database column tbl_user.login_pwd
    195.      *
    196.      * @param loginPwd the value for tbl_user.login_pwd
    197.      *
    198.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    199.      */
    200.     public void setLoginPwd(String loginPwd) {
    201.         this.loginPwd = loginPwd == null ? null : loginPwd.trim();
    202.     }
    203.  
    204.     /**
    205.      * This method was generated by MyBatis Generator.
    206.      * This method returns the value of the database column tbl_user.email
    207.      *
    208.      * @return the value of tbl_user.email
    209.      *
    210.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    211.      */
    212.     public String getEmail() {
    213.         return email;
    214.     }
    215.  
    216.     /**
    217.      * This method was generated by MyBatis Generator.
    218.      * This method sets the value of the database column tbl_user.email
    219.      *
    220.      * @param email the value for tbl_user.email
    221.      *
    222.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    223.      */
    224.     public void setEmail(String email) {
    225.         this.email = email == null ? null : email.trim();
    226.     }
    227.  
    228.     /**
    229.      * This method was generated by MyBatis Generator.
    230.      * This method returns the value of the database column tbl_user.expire_time
    231.      *
    232.      * @return the value of tbl_user.expire_time
    233.      *
    234.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    235.      */
    236.     public String getExpireTime() {
    237.         return expireTime;
    238.     }
    239.  
    240.     /**
    241.      * This method was generated by MyBatis Generator.
    242.      * This method sets the value of the database column tbl_user.expire_time
    243.      *
    244.      * @param expireTime the value for tbl_user.expire_time
    245.      *
    246.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    247.      */
    248.     public void setExpireTime(String expireTime) {
    249.         this.expireTime = expireTime == null ? null : expireTime.trim();
    250.     }
    251.  
    252.     /**
    253.      * This method was generated by MyBatis Generator.
    254.      * This method returns the value of the database column tbl_user.lock_state
    255.      *
    256.      * @return the value of tbl_user.lock_state
    257.      *
    258.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    259.      */
    260.     public String getLockState() {
    261.         return lockState;
    262.     }
    263.  
    264.     /**
    265.      * This method was generated by MyBatis Generator.
    266.      * This method sets the value of the database column tbl_user.lock_state
    267.      *
    268.      * @param lockState the value for tbl_user.lock_state
    269.      *
    270.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    271.      */
    272.     public void setLockState(String lockState) {
    273.         this.lockState = lockState == null ? null : lockState.trim();
    274.     }
    275.  
    276.     /**
    277.      * This method was generated by MyBatis Generator.
    278.      * This method returns the value of the database column tbl_user.deptno
    279.      *
    280.      * @return the value of tbl_user.deptno
    281.      *
    282.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    283.      */
    284.     public String getDeptno() {
    285.         return deptno;
    286.     }
    287.  
    288.     /**
    289.      * This method was generated by MyBatis Generator.
    290.      * This method sets the value of the database column tbl_user.deptno
    291.      *
    292.      * @param deptno the value for tbl_user.deptno
    293.      *
    294.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    295.      */
    296.     public void setDeptno(String deptno) {
    297.         this.deptno = deptno == null ? null : deptno.trim();
    298.     }
    299.  
    300.     /**
    301.      * This method was generated by MyBatis Generator.
    302.      * This method returns the value of the database column tbl_user.allow_ips
    303.      *
    304.      * @return the value of tbl_user.allow_ips
    305.      *
    306.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    307.      */
    308.     public String getAllowIps() {
    309.         return allowIps;
    310.     }
    311.  
    312.     /**
    313.      * This method was generated by MyBatis Generator.
    314.      * This method sets the value of the database column tbl_user.allow_ips
    315.      *
    316.      * @param allowIps the value for tbl_user.allow_ips
    317.      *
    318.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    319.      */
    320.     public void setAllowIps(String allowIps) {
    321.         this.allowIps = allowIps == null ? null : allowIps.trim();
    322.     }
    323.  
    324.     /**
    325.      * This method was generated by MyBatis Generator.
    326.      * This method returns the value of the database column tbl_user.createTime
    327.      *
    328.      * @return the value of tbl_user.createTime
    329.      *
    330.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    331.      */
    332.     public String getCreatetime() {
    333.         return createtime;
    334.     }
    335.  
    336.     /**
    337.      * This method was generated by MyBatis Generator.
    338.      * This method sets the value of the database column tbl_user.createTime
    339.      *
    340.      * @param createtime the value for tbl_user.createTime
    341.      *
    342.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    343.      */
    344.     public void setCreatetime(String createtime) {
    345.         this.createtime = createtime == null ? null : createtime.trim();
    346.     }
    347.  
    348.     /**
    349.      * This method was generated by MyBatis Generator.
    350.      * This method returns the value of the database column tbl_user.create_by
    351.      *
    352.      * @return the value of tbl_user.create_by
    353.      *
    354.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    355.      */
    356.     public String getCreateBy() {
    357.         return createBy;
    358.     }
    359.  
    360.     /**
    361.      * This method was generated by MyBatis Generator.
    362.      * This method sets the value of the database column tbl_user.create_by
    363.      *
    364.      * @param createBy the value for tbl_user.create_by
    365.      *
    366.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    367.      */
    368.     public void setCreateBy(String createBy) {
    369.         this.createBy = createBy == null ? null : createBy.trim();
    370.     }
    371.  
    372.     /**
    373.      * This method was generated by MyBatis Generator.
    374.      * This method returns the value of the database column tbl_user.edit_time
    375.      *
    376.      * @return the value of tbl_user.edit_time
    377.      *
    378.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    379.      */
    380.     public String getEditTime() {
    381.         return editTime;
    382.     }
    383.  
    384.     /**
    385.      * This method was generated by MyBatis Generator.
    386.      * This method sets the value of the database column tbl_user.edit_time
    387.      *
    388.      * @param editTime the value for tbl_user.edit_time
    389.      *
    390.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    391.      */
    392.     public void setEditTime(String editTime) {
    393.         this.editTime = editTime == null ? null : editTime.trim();
    394.     }
    395.  
    396.     /**
    397.      * This method was generated by MyBatis Generator.
    398.      * This method returns the value of the database column tbl_user.edit_by
    399.      *
    400.      * @return the value of tbl_user.edit_by
    401.      *
    402.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    403.      */
    404.     public String getEditBy() {
    405.         return editBy;
    406.     }
    407.  
    408.     /**
    409.      * This method was generated by MyBatis Generator.
    410.      * This method sets the value of the database column tbl_user.edit_by
    411.      *
    412.      * @param editBy the value for tbl_user.edit_by
    413.      *
    414.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    415.      */
    416.     public void setEditBy(String editBy) {
    417.         this.editBy = editBy == null ? null : editBy.trim();
    418.     }
    419. }

    UserMapper接口

    1. package com.it.crm.settings.mapper;
    2.  
    3. import com.it.crm.settings.entity.User;
    4.  
    5. public interface UserMapper {
    6.     /**
    7.      * This method was generated by MyBatis Generator.
    8.      * This method corresponds to the database table tbl_user
    9.      *
    10.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    11.      */
    12.     int deleteByPrimaryKey(String id);
    13.  
    14.     /**
    15.      * This method was generated by MyBatis Generator.
    16.      * This method corresponds to the database table tbl_user
    17.      *
    18.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    19.      */
    20.     int insert(User record);
    21.  
    22.     /**
    23.      * This method was generated by MyBatis Generator.
    24.      * This method corresponds to the database table tbl_user
    25.      *
    26.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    27.      */
    28.     int insertSelective(User record);
    29.  
    30.     /**
    31.      * This method was generated by MyBatis Generator.
    32.      * This method corresponds to the database table tbl_user
    33.      *
    34.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    35.      */
    36.     User selectByPrimaryKey(String id);
    37.  
    38.     /**
    39.      * This method was generated by MyBatis Generator.
    40.      * This method corresponds to the database table tbl_user
    41.      *
    42.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    43.      */
    44.     int updateByPrimaryKeySelective(User record);
    45.  
    46.     /**
    47.      * This method was generated by MyBatis Generator.
    48.      * This method corresponds to the database table tbl_user
    49.      *
    50.      * @mbggenerated Wed Jun 29 12:20:46 CST 2022
    51.      */
    52.     int updateByPrimaryKey(User record);
    53. }

    UserMapper.xml映射文件

     

    1. <?xml version="1.0" encoding="UTF-8" ?>
    2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
    3. <mapper namespace="com.it.crm.settings.mapper.UserMapper" >
    4.   <resultMap id="BaseResultMap" type="com.it.crm.settings.entity.User" >
    5.     <!--
    6.       WARNING - @mbggenerated
    7.       This element is automatically generated by MyBatis Generator, do not modify.
    8.       This element was generated on Wed Jun 29 12:20:46 CST 2022.
    9.     -->
    10.     <id column="id" property="id" jdbcType="CHAR" />
    11.     <result column="login_act" property="loginAct" jdbcType="VARCHAR" />
    12.     <result column="name" property="name" jdbcType="VARCHAR" />
    13.     <result column="login_pwd" property="loginPwd" jdbcType="VARCHAR" />
    14.     <result column="email" property="email" jdbcType="VARCHAR" />
    15.     <result column="expire_time" property="expireTime" jdbcType="CHAR" />
    16.     <result column="lock_state" property="lockState" jdbcType="CHAR" />
    17.     <result column="deptno" property="deptno" jdbcType="CHAR" />
    18.     <result column="allow_ips" property="allowIps" jdbcType="VARCHAR" />
    19.     <result column="createTime" property="createtime" jdbcType="CHAR" />
    20.     <result column="create_by" property="createBy" jdbcType="VARCHAR" />
    21.     <result column="edit_time" property="editTime" jdbcType="CHAR" />
    22.     <result column="edit_by" property="editBy" jdbcType="VARCHAR" />
    23.   </resultMap>
    24.   <sql id="Base_Column_List" >
    25.     <!--
    26.       WARNING - @mbggenerated
    27.       This element is automatically generated by MyBatis Generator, do not modify.
    28.       This element was generated on Wed Jun 29 12:20:46 CST 2022.
    29.     -->
    30.     id, login_act, name, login_pwd, email, expire_time, lock_state, deptno, allow_ips, 
    31.     createTime, create_by, edit_time, edit_by
    32.   </sql>
    33.   <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
    34.     <!--
    35.       WARNING - @mbggenerated
    36.       This element is automatically generated by MyBatis Generator, do not modify.
    37.       This element was generated on Wed Jun 29 12:20:46 CST 2022.
    38.     -->
    39.     select 
    40.     <include refid="Base_Column_List" />
    41.     from tbl_user
    42.     where id = #{id,jdbcType=CHAR}
    43.   </select>
    44.   <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    45.     <!--
    46.       WARNING - @mbggenerated
    47.       This element is automatically generated by MyBatis Generator, do not modify.
    48.       This element was generated on Wed Jun 29 12:20:46 CST 2022.
    49.     -->
    50.     delete from tbl_user
    51.     where id = #{id,jdbcType=CHAR}
    52.   </delete>
    53.   <insert id="insert" parameterType="com.it.crm.settings.entity.User" >
    54.     <!--
    55.       WARNING - @mbggenerated
    56.       This element is automatically generated by MyBatis Generator, do not modify.
    57.       This element was generated on Wed Jun 29 12:20:46 CST 2022.
    58.     -->
    59.     insert into tbl_user (id, login_act, name, 
    60.       login_pwd, email, expire_time, 
    61.       lock_state, deptno, allow_ips, 
    62.       createTime, create_by, edit_time, 
    63.       edit_by)
    64.     values (#{id,jdbcType=CHAR}, #{loginAct,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR}, 
    65.       #{loginPwd,jdbcType=VARCHAR}, #{email,jdbcType=VARCHAR}, #{expireTime,jdbcType=CHAR}, 
    66.       #{lockState,jdbcType=CHAR}, #{deptno,jdbcType=CHAR}, #{allowIps,jdbcType=VARCHAR}, 
    67.       #{createtime,jdbcType=CHAR}, #{createBy,jdbcType=VARCHAR}, #{editTime,jdbcType=CHAR}, 
    68.       #{editBy,jdbcType=VARCHAR})
    69.   </insert>
    70.   <insert id="insertSelective" parameterType="com.it.crm.settings.entity.User" >
    71.     <!--
    72.       WARNING - @mbggenerated
    73.       This element is automatically generated by MyBatis Generator, do not modify.
    74.       This element was generated on Wed Jun 29 12:20:46 CST 2022.
    75.     -->
    76.     insert into tbl_user
    77.     <trim prefix="(" suffix=")" suffixOverrides="," >
    78.       <if test="id != null" >
    79.         id,
    80.       </if>
    81.       <if test="loginAct != null" >
    82.         login_act,
    83.       </if>
    84.       <if test="name != null" >
    85.         name,
    86.       </if>
    87.       <if test="loginPwd != null" >
    88.         login_pwd,
    89.       </if>
    90.       <if test="email != null" >
    91.         email,
    92.       </if>
    93.       <if test="expireTime != null" >
    94.         expire_time,
    95.       </if>
    96.       <if test="lockState != null" >
    97.         lock_state,
    98.       </if>
    99.       <if test="deptno != null" >
    100.         deptno,
    101.       </if>
    102.       <if test="allowIps != null" >
    103.         allow_ips,
    104.       </if>
    105.       <if test="createtime != null" >
    106.         createTime,
    107.       </if>
    108.       <if test="createBy != null" >
    109.         create_by,
    110.       </if>
    111.       <if test="editTime != null" >
    112.         edit_time,
    113.       </if>
    114.       <if test="editBy != null" >
    115.         edit_by,
    116.       </if>
    117.     </trim>
    118.     <trim prefix="values (" suffix=")" suffixOverrides="," >
    119.       <if test="id != null" >
    120.         #{id,jdbcType=CHAR},
    121.       </if>
    122.       <if test="loginAct != null" >
    123.         #{loginAct,jdbcType=VARCHAR},
    124.       </if>
    125.       <if test="name != null" >
    126.         #{name,jdbcType=VARCHAR},
    127.       </if>
    128.       <if test="loginPwd != null" >
    129.         #{loginPwd,jdbcType=VARCHAR},
    130.       </if>
    131.       <if test="email != null" >
    132.         #{email,jdbcType=VARCHAR},
    133.       </if>
    134.       <if test="expireTime != null" >
    135.         #{expireTime,jdbcType=CHAR},
    136.       </if>
    137.       <if test="lockState != null" >
    138.         #{lockState,jdbcType=CHAR},
    139.       </if>
    140.       <if test="deptno != null" >
    141.         #{deptno,jdbcType=CHAR},
    142.       </if>
    143.       <if test="allowIps != null" >
    144.         #{allowIps,jdbcType=VARCHAR},
    145.       </if>
    146.       <if test="createtime != null" >
    147.         #{createtime,jdbcType=CHAR},
    148.       </if>
    149.       <if test="createBy != null" >
    150.         #{createBy,jdbcType=VARCHAR},
    151.       </if>
    152.       <if test="editTime != null" >
    153.         #{editTime,jdbcType=CHAR},
    154.       </if>
    155.       <if test="editBy != null" >
    156.         #{editBy,jdbcType=VARCHAR},
    157.       </if>
    158.     </trim>
    159.   </insert>
    160.   <update id="updateByPrimaryKeySelective" parameterType="com.it.crm.settings.entity.User" >
    161.     <!--
    162.       WARNING - @mbggenerated
    163.       This element is automatically generated by MyBatis Generator, do not modify.
    164.       This element was generated on Wed Jun 29 12:20:46 CST 2022.
    165.     -->
    166.     update tbl_user
    167.     <set >
    168.       <if test="loginAct != null" >
    169.         login_act = #{loginAct,jdbcType=VARCHAR},
    170.       </if>
    171.       <if test="name != null" >
    172.         name = #{name,jdbcType=VARCHAR},
    173.       </if>
    174.       <if test="loginPwd != null" >
    175.         login_pwd = #{loginPwd,jdbcType=VARCHAR},
    176.       </if>
    177.       <if test="email != null" >
    178.         email = #{email,jdbcType=VARCHAR},
    179.       </if>
    180.       <if test="expireTime != null" >
    181.         expire_time = #{expireTime,jdbcType=CHAR},
    182.       </if>
    183.       <if test="lockState != null" >
    184.         lock_state = #{lockState,jdbcType=CHAR},
    185.       </if>
    186.       <if test="deptno != null" >
    187.         deptno = #{deptno,jdbcType=CHAR},
    188.       </if>
    189.       <if test="allowIps != null" >
    190.         allow_ips = #{allowIps,jdbcType=VARCHAR},
    191.       </if>
    192.       <if test="createtime != null" >
    193.         createTime = #{createtime,jdbcType=CHAR},
    194.       </if>
    195.       <if test="createBy != null" >
    196.         create_by = #{createBy,jdbcType=VARCHAR},
    197.       </if>
    198.       <if test="editTime != null" >
    199.         edit_time = #{editTime,jdbcType=CHAR},
    200.       </if>
    201.       <if test="editBy != null" >
    202.         edit_by = #{editBy,jdbcType=VARCHAR},
    203.       </if>
    204.     </set>
    205.     where id = #{id,jdbcType=CHAR}
    206.   </update>
    207.   <update id="updateByPrimaryKey" parameterType="com.it.crm.settings.entity.User" >
    208.     <!--
    209.       WARNING - @mbggenerated
    210.       This element is automatically generated by MyBatis Generator, do not modify.
    211.       This element was generated on Wed Jun 29 12:20:46 CST 2022.
    212.     -->
    213.     update tbl_user
    214.     set login_act = #{loginAct,jdbcType=VARCHAR},
    215.       name = #{name,jdbcType=VARCHAR},
    216.       login_pwd = #{loginPwd,jdbcType=VARCHAR},
    217.       email = #{email,jdbcType=VARCHAR},
    218.       expire_time = #{expireTime,jdbcType=CHAR},
    219.       lock_state = #{lockState,jdbcType=CHAR},
    220.       deptno = #{deptno,jdbcType=CHAR},
    221.       allow_ips = #{allowIps,jdbcType=VARCHAR},
    222.       createTime = #{createtime,jdbcType=CHAR},
    223.       create_by = #{createBy,jdbcType=VARCHAR},
    224.       edit_time = #{editTime,jdbcType=CHAR},
    225.       edit_by = #{editBy,jdbcType=VARCHAR}
    226.     where id = #{id,jdbcType=CHAR}
    227.   </update>
    228. </mapper>

  • 相关阅读:
    RabbitMQ学习整理————基于RabbitMQ实现RPC
    使用键盘控制Franka机械臂运动
    不允许还有Java程序员不了解BlockingQueue阻塞队列的实现原理
    使用 sqlc 生成类型安全的Go代码与SQL数据库交互
    多线程调用外部接口
    uniapp tabBar app页面滚动闪屏的问题
    实时输出Java8 HashMap数据结构
    DataX DorisWriter 插件DorisStreamLoadObserver类详细解读
    我的NAS方案及使用的功能
    手把手教你Nginx常用模块详解之ngx_http_access_module(一)
  • 原文地址：https://blog.csdn.net/weixin_59334478/article/details/125518545