Java自动生成Mysql表实体和mybatis接口以及xml文件

为了提高开发效率，有一些工具和插件其实很好用，今天介绍怎么样自动生成我们Mysql数据库表的实体对象和mybatis接口以及xml文件。

先介绍一下使用方法，文章最后会附上我的实例项目，大家可直接下载！

1、首先主要的工具包就是mybatis-generator-core，我这里是mybatis-generator-core-1.3.2.jar包，大家需要其他版本的可以到网上下载
2、需要数据库jdbc连接的包，例如Mysql：mysql-connector-java-5.1.48.jar
3、在你的目录下新建一个src的文件夹
4、新建一个xml文件，自动生成的xml配置文件，这里主要介绍怎么配置。
示例截图：

 首先把配置文件贴出来再一一讲解

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration
        PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
        "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

<generatorConfiguration>
    <!-- 引入数据库连接配置 -->
    <classPathEntry
            location="D:\work\generator\mysql-connector-java-5.1.48.jar"/>
    <context id="DB2Tables" targetRuntime="MyBatis3">
        <commentGenerator>
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>

        <jdbcConnection 
			driverClass="com.mysql.jdbc.Driver" 
			connectionURL="jdbc:mysql://localhost:3306/t2_cpv2?characterEncoding=utf8" 
			userId="root" 
			password="123456"> 
		</jdbcConnection>

        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>


        <!--配置实体类存放路径,域模型层,生成的目标包 -->
        <javaModelGenerator targetPackage="com.entity"
                            targetProject="D:\work\generator\src">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>
        <!--XML映射文件,生成的位置（目标包）,源代码文件夹 -->
        <sqlMapGenerator targetPackage="mapper" targetProject="D:\work\generator\src">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        <!--XML对应的Mapper类 -->
        <javaClientGenerator type="XMLMAPPER"
                             targetPackage="com.dao" targetProject="D:\work\generator\src">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>


        <!--下面是数据库表名和项目中需要生成类的名称，建议和数据库保持一致，如果有多个表，添加多个节点即可 -->
        <table tableName="ab_accrecords" domainObjectName="ab_accrecords"
               enableCountByExample="false" enableSelectByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false">
        </table>


    </context>
</generatorConfiguration>

配置好后在该路径下cmd:
执行代码介绍：java -jar mybatis-generator-core包 -configfile xml文件名 -overwrite
执行：java -jar mybatis-generator-core-1.3.2.jar -configfile generatorMysql.xml -overwrite

这样就在你src目录下面自动生成好文件了！

生成的mapper.xml文件

<?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="com.dao.ab_accrecordsMapper" >
  <resultMap id="BaseResultMap" type="com.entity.ab_accrecords" >
    <id column="ID" property="id" jdbcType="VARCHAR" />
    <result column="VID" property="vid" jdbcType="VARCHAR" />
    <result column="VVID" property="vvid" jdbcType="VARCHAR" />
    <result column="RECID" property="recid" jdbcType="VARCHAR" />
    <result column="TRID" property="trid" jdbcType="VARCHAR" />
    <result column="LASTID" property="lastid" jdbcType="VARCHAR" />
    <result column="LASTBILLCODE" property="lastbillcode" jdbcType="VARCHAR" />
    <result column="VALID_SIGN" property="validSign" jdbcType="CHAR" />
    <result column="IS_HIDE" property="isHide" jdbcType="VARCHAR" />
    <result column="STATUS" property="status" jdbcType="DECIMAL" />
    <result column="OPT_STATUS" property="optStatus" jdbcType="VARCHAR" />
    <result column="SEND_SIGN" property="sendSign" jdbcType="CHAR" />
    <result column="BILL_SOURCE" property="billSource" jdbcType="VARCHAR" />
    <result column="RETURN_CODE" property="returnCode" jdbcType="VARCHAR" />
    <result column="RETURN_MSG" property="returnMsg" jdbcType="VARCHAR" />
    <result column="BRIEF_ID" property="briefId" jdbcType="VARCHAR" />
    <result column="INSIDE_SING" property="insideSing" jdbcType="DECIMAL" />
    <result column="ENTER_STOCK_NEW" property="enterStockNew" jdbcType="VARCHAR" />
    <result column="ENTER_STOCK_OLD" property="enterStockOld" jdbcType="VARCHAR" />
    <result column="BAIL_TYPE" property="bailType" jdbcType="VARCHAR" />
    <result column="RECALL_TYPE" property="recallType" jdbcType="VARCHAR" />
    <result column="BANKENDRSMTMK" property="bankendrsmtmk" jdbcType="VARCHAR" />
    <result column="STTLMMK" property="sttlmmk" jdbcType="VARCHAR" />
    <result column="APPLY_DATE" property="applyDate" jdbcType="TIMESTAMP" />
    <result column="BUSINESS_DATE" property="businessDate" jdbcType="TIMESTAMP" />
    <result column="RCRSOKMONEY" property="rcrsokmoney" jdbcType="DECIMAL" />
    <result column="CN_ACCRECORDS" property="cnAccrecords" jdbcType="VARCHAR" />
    <result column="SIGN_UP_FLAG" property="signUpFlag" jdbcType="VARCHAR" />
    <result column="ABS" property="abs" jdbcType="VARCHAR" />
    <result column="RMK" property="rmk" jdbcType="VARCHAR" />
    <result column="CREDIT_CODE" property="creditCode" jdbcType="VARCHAR" />
    <result column="BUDGET_CODE" property="budgetCode" jdbcType="VARCHAR" />
    <result column="BAIL_ACC" property="bailAcc" jdbcType="VARCHAR" />
    <result column="BAILMONEY" property="bailmoney" jdbcType="DECIMAL" />
    <result column="BAILPERCENT" property="bailpercent" jdbcType="DECIMAL" />
    <result column="BAILRATE" property="bailrate" jdbcType="DECIMAL" />
    <result column="FEEMONEY" property="feemoney" jdbcType="DECIMAL" />
    <result column="RCRSRSNCD" property="rcrsrsncd" jdbcType="VARCHAR" />
    <result column="RCRS_TP" property="rcrsTp" jdbcType="VARCHAR" />
    <result column="SIGNEROK" property="signerok" jdbcType="VARCHAR" />
    <result column="BIF_CODE" property="bifCode" jdbcType="VARCHAR" />
    <result column="REQ_ROLE" property="reqRole" jdbcType="VARCHAR" />
    <result column="REQ_NM" property="reqNm" jdbcType="VARCHAR" />
    <result column="REQ_CMONID" property="reqCmonid" jdbcType="VARCHAR" />
    <result column="REQ_ACCT_ID" property="reqAcctId" jdbcType="VARCHAR" />
    <result column="REQ_ACCTSVCR" property="reqAcctsvcr" jdbcType="VARCHAR" />
    <result column="REQ_ACCTSVCR_AG" property="reqAcctsvcrAg" jdbcType="VARCHAR" />
    <result column="REC_ROLE" property="recRole" jdbcType="VARCHAR" />
    <result column="REC_NM" property="recNm" jdbcType="VARCHAR" />
    <result column="REC_CMONID" property="recCmonid" jdbcType="VARCHAR" />
    <result column="REC_ACCT_ID" property="recAcctId" jdbcType="VARCHAR" />
    <result column="REC_ACCTSVCR" property="recAcctsvcr" jdbcType="VARCHAR" />
    <result column="REC_ACCTSVCR_AG" property="recAcctsvcrAg" jdbcType="VARCHAR" />
    <result column="BUS_GLOBAL_ID" property="busGlobalId" jdbcType="VARCHAR" />
    <result column="ATTACHMENT_ID" property="attachmentId" jdbcType="VARCHAR" />
    <result column="CDT_RATGS" property="cdtRatgs" jdbcType="VARCHAR" />
    <result column="CDT_RATG_AGCY" property="cdtRatgAgcy" jdbcType="VARCHAR" />
    <result column="CDT_RATG_DUEDT" property="cdtRatgDuedt" jdbcType="TIMESTAMP" />
    <result column="EMIT_STTLMMK" property="emitSttlmmk" jdbcType="VARCHAR" />
    <result column="CREATE_NAME" property="createName" jdbcType="VARCHAR" />
    <result column="CREATE_BY" property="createBy" jdbcType="VARCHAR" />
    <result column="CREATE_DATE" property="createDate" jdbcType="TIMESTAMP" />
    <result column="UPDATE_NAME" property="updateName" jdbcType="VARCHAR" />
    <result column="UPDATE_BY" property="updateBy" jdbcType="VARCHAR" />
    <result column="UPDATE_DATE" property="updateDate" jdbcType="TIMESTAMP" />
    <result column="BILL_ID" property="billId" jdbcType="VARCHAR" />
    <result column="MSG_ID" property="msgId" jdbcType="VARCHAR" />
    <result column="TRADER" property="trader" jdbcType="VARCHAR" />
    <result column="RSN" property="rsn" jdbcType="VARCHAR" />
    <result column="PD_ID" property="pdId" jdbcType="VARCHAR" />
    <result column="IS_AUTOSIGN" property="isAutosign" jdbcType="VARCHAR" />
  </resultMap>
  <resultMap id="ResultMapWithBLOBs" type="com.entity.ab_accrecords" extends="BaseResultMap" >
    <result column="ADR" property="adr" jdbcType="LONGVARCHAR" />
  </resultMap>
  <sql id="Base_Column_List" >
    ID, VID, VVID, RECID, TRID, LASTID, LASTBILLCODE, VALID_SIGN, IS_HIDE, STATUS, OPT_STATUS, 
    SEND_SIGN, BILL_SOURCE, RETURN_CODE, RETURN_MSG, BRIEF_ID, INSIDE_SING, ENTER_STOCK_NEW, 
    ENTER_STOCK_OLD, BAIL_TYPE, RECALL_TYPE, BANKENDRSMTMK, STTLMMK, APPLY_DATE, BUSINESS_DATE, 
    RCRSOKMONEY, CN_ACCRECORDS, SIGN_UP_FLAG, ABS, RMK, CREDIT_CODE, BUDGET_CODE, BAIL_ACC, 
    BAILMONEY, BAILPERCENT, BAILRATE, FEEMONEY, RCRSRSNCD, RCRS_TP, SIGNEROK, BIF_CODE, 
    REQ_ROLE, REQ_NM, REQ_CMONID, REQ_ACCT_ID, REQ_ACCTSVCR, REQ_ACCTSVCR_AG, REC_ROLE, 
    REC_NM, REC_CMONID, REC_ACCT_ID, REC_ACCTSVCR, REC_ACCTSVCR_AG, BUS_GLOBAL_ID, ATTACHMENT_ID, 
    CDT_RATGS, CDT_RATG_AGCY, CDT_RATG_DUEDT, EMIT_STTLMMK, CREATE_NAME, CREATE_BY, CREATE_DATE, 
    UPDATE_NAME, UPDATE_BY, UPDATE_DATE, BILL_ID, MSG_ID, TRADER, RSN, PD_ID, IS_AUTOSIGN
  </sql>
  <sql id="Blob_Column_List" >
    ADR
  </sql>
  <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.String" >
    select 
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from ab_accrecords
    where ID = #{id,jdbcType=VARCHAR}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
    delete from ab_accrecords
    where ID = #{id,jdbcType=VARCHAR}
  </delete>
  <insert id="insert" parameterType="com.entity.ab_accrecords" >
    insert into ab_accrecords (ID, VID, VVID, 
      RECID, TRID, LASTID, 
      LASTBILLCODE, VALID_SIGN, IS_HIDE, 
      STATUS, OPT_STATUS, SEND_SIGN, 
      BILL_SOURCE, RETURN_CODE, RETURN_MSG, 
      BRIEF_ID, INSIDE_SING, ENTER_STOCK_NEW, 
      ENTER_STOCK_OLD, BAIL_TYPE, RECALL_TYPE, 
      BANKENDRSMTMK, STTLMMK, APPLY_DATE, 
      BUSINESS_DATE, RCRSOKMONEY, CN_ACCRECORDS, 
      SIGN_UP_FLAG, ABS, RMK, 
      CREDIT_CODE, BUDGET_CODE, BAIL_ACC, 
      BAILMONEY, BAILPERCENT, BAILRATE, 
      FEEMONEY, RCRSRSNCD, RCRS_TP, 
      SIGNEROK, BIF_CODE, REQ_ROLE, 
      REQ_NM, REQ_CMONID, REQ_ACCT_ID, 
      REQ_ACCTSVCR, REQ_ACCTSVCR_AG, REC_ROLE, 
      REC_NM, REC_CMONID, REC_ACCT_ID, 
      REC_ACCTSVCR, REC_ACCTSVCR_AG, BUS_GLOBAL_ID, 
      ATTACHMENT_ID, CDT_RATGS, CDT_RATG_AGCY, 
      CDT_RATG_DUEDT, EMIT_STTLMMK, CREATE_NAME, 
      CREATE_BY, CREATE_DATE, UPDATE_NAME, 
      UPDATE_BY, UPDATE_DATE, BILL_ID, 
      MSG_ID, TRADER, RSN, 
      PD_ID, IS_AUTOSIGN, ADR
      )
    values (#{id,jdbcType=VARCHAR}, #{vid,jdbcType=VARCHAR}, #{vvid,jdbcType=VARCHAR}, 
      #{recid,jdbcType=VARCHAR}, #{trid,jdbcType=VARCHAR}, #{lastid,jdbcType=VARCHAR}, 
      #{lastbillcode,jdbcType=VARCHAR}, #{validSign,jdbcType=CHAR}, #{isHide,jdbcType=VARCHAR}, 
      #{status,jdbcType=DECIMAL}, #{optStatus,jdbcType=VARCHAR}, #{sendSign,jdbcType=CHAR}, 
      #{billSource,jdbcType=VARCHAR}, #{returnCode,jdbcType=VARCHAR}, #{returnMsg,jdbcType=VARCHAR}, 
      #{briefId,jdbcType=VARCHAR}, #{insideSing,jdbcType=DECIMAL}, #{enterStockNew,jdbcType=VARCHAR}, 
      #{enterStockOld,jdbcType=VARCHAR}, #{bailType,jdbcType=VARCHAR}, #{recallType,jdbcType=VARCHAR}, 
      #{bankendrsmtmk,jdbcType=VARCHAR}, #{sttlmmk,jdbcType=VARCHAR}, #{applyDate,jdbcType=TIMESTAMP}, 
      #{businessDate,jdbcType=TIMESTAMP}, #{rcrsokmoney,jdbcType=DECIMAL}, #{cnAccrecords,jdbcType=VARCHAR}, 
      #{signUpFlag,jdbcType=VARCHAR}, #{abs,jdbcType=VARCHAR}, #{rmk,jdbcType=VARCHAR}, 
      #{creditCode,jdbcType=VARCHAR}, #{budgetCode,jdbcType=VARCHAR}, #{bailAcc,jdbcType=VARCHAR}, 
      #{bailmoney,jdbcType=DECIMAL}, #{bailpercent,jdbcType=DECIMAL}, #{bailrate,jdbcType=DECIMAL}, 
      #{feemoney,jdbcType=DECIMAL}, #{rcrsrsncd,jdbcType=VARCHAR}, #{rcrsTp,jdbcType=VARCHAR}, 
      #{signerok,jdbcType=VARCHAR}, #{bifCode,jdbcType=VARCHAR}, #{reqRole,jdbcType=VARCHAR}, 
      #{reqNm,jdbcType=VARCHAR}, #{reqCmonid,jdbcType=VARCHAR}, #{reqAcctId,jdbcType=VARCHAR}, 
      #{reqAcctsvcr,jdbcType=VARCHAR}, #{reqAcctsvcrAg,jdbcType=VARCHAR}, #{recRole,jdbcType=VARCHAR}, 
      #{recNm,jdbcType=VARCHAR}, #{recCmonid,jdbcType=VARCHAR}, #{recAcctId,jdbcType=VARCHAR}, 
      #{recAcctsvcr,jdbcType=VARCHAR}, #{recAcctsvcrAg,jdbcType=VARCHAR}, #{busGlobalId,jdbcType=VARCHAR}, 
      #{attachmentId,jdbcType=VARCHAR}, #{cdtRatgs,jdbcType=VARCHAR}, #{cdtRatgAgcy,jdbcType=VARCHAR}, 
      #{cdtRatgDuedt,jdbcType=TIMESTAMP}, #{emitSttlmmk,jdbcType=VARCHAR}, #{createName,jdbcType=VARCHAR}, 
      #{createBy,jdbcType=VARCHAR}, #{createDate,jdbcType=TIMESTAMP}, #{updateName,jdbcType=VARCHAR}, 
      #{updateBy,jdbcType=VARCHAR}, #{updateDate,jdbcType=TIMESTAMP}, #{billId,jdbcType=VARCHAR}, 
      #{msgId,jdbcType=VARCHAR}, #{trader,jdbcType=VARCHAR}, #{rsn,jdbcType=VARCHAR}, 
      #{pdId,jdbcType=VARCHAR}, #{isAutosign,jdbcType=VARCHAR}, #{adr,jdbcType=LONGVARCHAR}
      )
  </insert>
  <insert id="insertSelective" parameterType="com.entity.ab_accrecords" >
    insert into ab_accrecords
    <trim prefix="(" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        ID,
      </if>
      <if test="vid != null" >
        VID,
      </if>
      <if test="vvid != null" >
        VVID,
      </if>
      <if test="recid != null" >
        RECID,
      </if>
      <if test="trid != null" >
        TRID,
      </if>
      <if test="lastid != null" >
        LASTID,
      </if>
      <if test="lastbillcode != null" >
        LASTBILLCODE,
      </if>
      <if test="validSign != null" >
        VALID_SIGN,
      </if>
      <if test="isHide != null" >
        IS_HIDE,
      </if>
      <if test="status != null" >
        STATUS,
      </if>
      <if test="optStatus != null" >
        OPT_STATUS,
      </if>
      <if test="sendSign != null" >
        SEND_SIGN,
      </if>
      <if test="billSource != null" >
        BILL_SOURCE,
      </if>
      <if test="returnCode != null" >
        RETURN_CODE,
      </if>
      <if test="returnMsg != null" >
        RETURN_MSG,
      </if>
      <if test="briefId != null" >
        BRIEF_ID,
      </if>
      <if test="insideSing != null" >
        INSIDE_SING,
      </if>
      <if test="enterStockNew != null" >
        ENTER_STOCK_NEW,
      </if>
      <if test="enterStockOld != null" >
        ENTER_STOCK_OLD,
      </if>
      <if test="bailType != null" >
        BAIL_TYPE,
      </if>
      <if test="recallType != null" >
        RECALL_TYPE,
      </if>
      <if test="bankendrsmtmk != null" >
        BANKENDRSMTMK,
      </if>
      <if test="sttlmmk != null" >
        STTLMMK,
      </if>
      <if test="applyDate != null" >
        APPLY_DATE,
      </if>
      <if test="businessDate != null" >
        BUSINESS_DATE,
      </if>
      <if test="rcrsokmoney != null" >
        RCRSOKMONEY,
      </if>
      <if test="cnAccrecords != null" >
        CN_ACCRECORDS,
      </if>
      <if test="signUpFlag != null" >
        SIGN_UP_FLAG,
      </if>
      <if test="abs != null" >
        ABS,
      </if>
      <if test="rmk != null" >
        RMK,
      </if>
      <if test="creditCode != null" >
        CREDIT_CODE,
      </if>
      <if test="budgetCode != null" >
        BUDGET_CODE,
      </if>
      <if test="bailAcc != null" >
        BAIL_ACC,
      </if>
      <if test="bailmoney != null" >
        BAILMONEY,
      </if>
      <if test="bailpercent != null" >
        BAILPERCENT,
      </if>
      <if test="bailrate != null" >
        BAILRATE,
      </if>
      <if test="feemoney != null" >
        FEEMONEY,
      </if>
      <if test="rcrsrsncd != null" >
        RCRSRSNCD,
      </if>
      <if test="rcrsTp != null" >
        RCRS_TP,
      </if>
      <if test="signerok != null" >
        SIGNEROK,
      </if>
      <if test="bifCode != null" >
        BIF_CODE,
      </if>
      <if test="reqRole != null" >
        REQ_ROLE,
      </if>
      <if test="reqNm != null" >
        REQ_NM,
      </if>
      <if test="reqCmonid != null" >
        REQ_CMONID,
      </if>
      <if test="reqAcctId != null" >
        REQ_ACCT_ID,
      </if>
      <if test="reqAcctsvcr != null" >
        REQ_ACCTSVCR,
      </if>
      <if test="reqAcctsvcrAg != null" >
        REQ_ACCTSVCR_AG,
      </if>
      <if test="recRole != null" >
        REC_ROLE,
      </if>
      <if test="recNm != null" >
        REC_NM,
      </if>
      <if test="recCmonid != null" >
        REC_CMONID,
      </if>
      <if test="recAcctId != null" >
        REC_ACCT_ID,
      </if>
      <if test="recAcctsvcr != null" >
        REC_ACCTSVCR,
      </if>
      <if test="recAcctsvcrAg != null" >
        REC_ACCTSVCR_AG,
      </if>
      <if test="busGlobalId != null" >
        BUS_GLOBAL_ID,
      </if>
      <if test="attachmentId != null" >
        ATTACHMENT_ID,
      </if>
      <if test="cdtRatgs != null" >
        CDT_RATGS,
      </if>
      <if test="cdtRatgAgcy != null" >
        CDT_RATG_AGCY,
      </if>
      <if test="cdtRatgDuedt != null" >
        CDT_RATG_DUEDT,
      </if>
      <if test="emitSttlmmk != null" >
        EMIT_STTLMMK,
      </if>
      <if test="createName != null" >
        CREATE_NAME,
      </if>
      <if test="createBy != null" >
        CREATE_BY,
      </if>
      <if test="createDate != null" >
        CREATE_DATE,
      </if>
      <if test="updateName != null" >
        UPDATE_NAME,
      </if>
      <if test="updateBy != null" >
        UPDATE_BY,
      </if>
      <if test="updateDate != null" >
        UPDATE_DATE,
      </if>
      <if test="billId != null" >
        BILL_ID,
      </if>
      <if test="msgId != null" >
        MSG_ID,
      </if>
      <if test="trader != null" >
        TRADER,
      </if>
      <if test="rsn != null" >
        RSN,
      </if>
      <if test="pdId != null" >
        PD_ID,
      </if>
      <if test="isAutosign != null" >
        IS_AUTOSIGN,
      </if>
      <if test="adr != null" >
        ADR,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
      <if test="id != null" >
        #{id,jdbcType=VARCHAR},
      </if>
      <if test="vid != null" >
        #{vid,jdbcType=VARCHAR},
      </if>
      <if test="vvid != null" >
        #{vvid,jdbcType=VARCHAR},
      </if>
      <if test="recid != null" >
        #{recid,jdbcType=VARCHAR},
      </if>
      <if test="trid != null" >
        #{trid,jdbcType=VARCHAR},
      </if>
      <if test="lastid != null" >
        #{lastid,jdbcType=VARCHAR},
      </if>
      <if test="lastbillcode != null" >
        #{lastbillcode,jdbcType=VARCHAR},
      </if>
      <if test="validSign != null" >
        #{validSign,jdbcType=CHAR},
      </if>
      <if test="isHide != null" >
        #{isHide,jdbcType=VARCHAR},
      </if>
      <if test="status != null" >
        #{status,jdbcType=DECIMAL},
      </if>
      <if test="optStatus != null" >
        #{optStatus,jdbcType=VARCHAR},
      </if>
      <if test="sendSign != null" >
        #{sendSign,jdbcType=CHAR},
      </if>
      <if test="billSource != null" >
        #{billSource,jdbcType=VARCHAR},
      </if>
      <if test="returnCode != null" >
        #{returnCode,jdbcType=VARCHAR},
      </if>
      <if test="returnMsg != null" >
        #{returnMsg,jdbcType=VARCHAR},
      </if>
      <if test="briefId != null" >
        #{briefId,jdbcType=VARCHAR},
      </if>
      <if test="insideSing != null" >
        #{insideSing,jdbcType=DECIMAL},
      </if>
      <if test="enterStockNew != null" >
        #{enterStockNew,jdbcType=VARCHAR},
      </if>
      <if test="enterStockOld != null" >
        #{enterStockOld,jdbcType=VARCHAR},
      </if>
      <if test="bailType != null" >
        #{bailType,jdbcType=VARCHAR},
      </if>
      <if test="recallType != null" >
        #{recallType,jdbcType=VARCHAR},
      </if>
      <if test="bankendrsmtmk != null" >
        #{bankendrsmtmk,jdbcType=VARCHAR},
      </if>
      <if test="sttlmmk != null" >
        #{sttlmmk,jdbcType=VARCHAR},
      </if>
      <if test="applyDate != null" >
        #{applyDate,jdbcType=TIMESTAMP},
      </if>
      <if test="businessDate != null" >
        #{businessDate,jdbcType=TIMESTAMP},
      </if>
      <if test="rcrsokmoney != null" >
        #{rcrsokmoney,jdbcType=DECIMAL},
      </if>
      <if test="cnAccrecords != null" >
        #{cnAccrecords,jdbcType=VARCHAR},
      </if>
      <if test="signUpFlag != null" >
        #{signUpFlag,jdbcType=VARCHAR},
      </if>
      <if test="abs != null" >
        #{abs,jdbcType=VARCHAR},
      </if>
      <if test="rmk != null" >
        #{rmk,jdbcType=VARCHAR},
      </if>
      <if test="creditCode != null" >
        #{creditCode,jdbcType=VARCHAR},
      </if>
      <if test="budgetCode != null" >
        #{budgetCode,jdbcType=VARCHAR},
      </if>
      <if test="bailAcc != null" >
        #{bailAcc,jdbcType=VARCHAR},
      </if>
      <if test="bailmoney != null" >
        #{bailmoney,jdbcType=DECIMAL},
      </if>
      <if test="bailpercent != null" >
        #{bailpercent,jdbcType=DECIMAL},
      </if>
      <if test="bailrate != null" >
        #{bailrate,jdbcType=DECIMAL},
      </if>
      <if test="feemoney != null" >
        #{feemoney,jdbcType=DECIMAL},
      </if>
      <if test="rcrsrsncd != null" >
        #{rcrsrsncd,jdbcType=VARCHAR},
      </if>
      <if test="rcrsTp != null" >
        #{rcrsTp,jdbcType=VARCHAR},
      </if>
      <if test="signerok != null" >
        #{signerok,jdbcType=VARCHAR},
      </if>
      <if test="bifCode != null" >
        #{bifCode,jdbcType=VARCHAR},
      </if>
      <if test="reqRole != null" >
        #{reqRole,jdbcType=VARCHAR},
      </if>
      <if test="reqNm != null" >
        #{reqNm,jdbcType=VARCHAR},
      </if>
      <if test="reqCmonid != null" >
        #{reqCmonid,jdbcType=VARCHAR},
      </if>
      <if test="reqAcctId != null" >
        #{reqAcctId,jdbcType=VARCHAR},
      </if>
      <if test="reqAcctsvcr != null" >
        #{reqAcctsvcr,jdbcType=VARCHAR},
      </if>
      <if test="reqAcctsvcrAg != null" >
        #{reqAcctsvcrAg,jdbcType=VARCHAR},
      </if>
      <if test="recRole != null" >
        #{recRole,jdbcType=VARCHAR},
      </if>
      <if test="recNm != null" >
        #{recNm,jdbcType=VARCHAR},
      </if>
      <if test="recCmonid != null" >
        #{recCmonid,jdbcType=VARCHAR},
      </if>
      <if test="recAcctId != null" >
        #{recAcctId,jdbcType=VARCHAR},
      </if>
      <if test="recAcctsvcr != null" >
        #{recAcctsvcr,jdbcType=VARCHAR},
      </if>
      <if test="recAcctsvcrAg != null" >
        #{recAcctsvcrAg,jdbcType=VARCHAR},
      </if>
      <if test="busGlobalId != null" >
        #{busGlobalId,jdbcType=VARCHAR},
      </if>
      <if test="attachmentId != null" >
        #{attachmentId,jdbcType=VARCHAR},
      </if>
      <if test="cdtRatgs != null" >
        #{cdtRatgs,jdbcType=VARCHAR},
      </if>
      <if test="cdtRatgAgcy != null" >
        #{cdtRatgAgcy,jdbcType=VARCHAR},
      </if>
      <if test="cdtRatgDuedt != null" >
        #{cdtRatgDuedt,jdbcType=TIMESTAMP},
      </if>
      <if test="emitSttlmmk != null" >
        #{emitSttlmmk,jdbcType=VARCHAR},
      </if>
      <if test="createName != null" >
        #{createName,jdbcType=VARCHAR},
      </if>
      <if test="createBy != null" >
        #{createBy,jdbcType=VARCHAR},
      </if>
      <if test="createDate != null" >
        #{createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="updateName != null" >
        #{updateName,jdbcType=VARCHAR},
      </if>
      <if test="updateBy != null" >
        #{updateBy,jdbcType=VARCHAR},
      </if>
      <if test="updateDate != null" >
        #{updateDate,jdbcType=TIMESTAMP},
      </if>
      <if test="billId != null" >
        #{billId,jdbcType=VARCHAR},
      </if>
      <if test="msgId != null" >
        #{msgId,jdbcType=VARCHAR},
      </if>
      <if test="trader != null" >
        #{trader,jdbcType=VARCHAR},
      </if>
      <if test="rsn != null" >
        #{rsn,jdbcType=VARCHAR},
      </if>
      <if test="pdId != null" >
        #{pdId,jdbcType=VARCHAR},
      </if>
      <if test="isAutosign != null" >
        #{isAutosign,jdbcType=VARCHAR},
      </if>
      <if test="adr != null" >
        #{adr,jdbcType=LONGVARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.entity.ab_accrecords" >
    update ab_accrecords
    <set >
      <if test="vid != null" >
        VID = #{vid,jdbcType=VARCHAR},
      </if>
      <if test="vvid != null" >
        VVID = #{vvid,jdbcType=VARCHAR},
      </if>
      <if test="recid != null" >
        RECID = #{recid,jdbcType=VARCHAR},
      </if>
      <if test="trid != null" >
        TRID = #{trid,jdbcType=VARCHAR},
      </if>
      <if test="lastid != null" >
        LASTID = #{lastid,jdbcType=VARCHAR},
      </if>
      <if test="lastbillcode != null" >
        LASTBILLCODE = #{lastbillcode,jdbcType=VARCHAR},
      </if>
      <if test="validSign != null" >
        VALID_SIGN = #{validSign,jdbcType=CHAR},
      </if>
      <if test="isHide != null" >
        IS_HIDE = #{isHide,jdbcType=VARCHAR},
      </if>
      <if test="status != null" >
        STATUS = #{status,jdbcType=DECIMAL},
      </if>
      <if test="optStatus != null" >
        OPT_STATUS = #{optStatus,jdbcType=VARCHAR},
      </if>
      <if test="sendSign != null" >
        SEND_SIGN = #{sendSign,jdbcType=CHAR},
      </if>
      <if test="billSource != null" >
        BILL_SOURCE = #{billSource,jdbcType=VARCHAR},
      </if>
      <if test="returnCode != null" >
        RETURN_CODE = #{returnCode,jdbcType=VARCHAR},
      </if>
      <if test="returnMsg != null" >
        RETURN_MSG = #{returnMsg,jdbcType=VARCHAR},
      </if>
      <if test="briefId != null" >
        BRIEF_ID = #{briefId,jdbcType=VARCHAR},
      </if>
      <if test="insideSing != null" >
        INSIDE_SING = #{insideSing,jdbcType=DECIMAL},
      </if>
      <if test="enterStockNew != null" >
        ENTER_STOCK_NEW = #{enterStockNew,jdbcType=VARCHAR},
      </if>
      <if test="enterStockOld != null" >
        ENTER_STOCK_OLD = #{enterStockOld,jdbcType=VARCHAR},
      </if>
      <if test="bailType != null" >
        BAIL_TYPE = #{bailType,jdbcType=VARCHAR},
      </if>
      <if test="recallType != null" >
        RECALL_TYPE = #{recallType,jdbcType=VARCHAR},
      </if>
      <if test="bankendrsmtmk != null" >
        BANKENDRSMTMK = #{bankendrsmtmk,jdbcType=VARCHAR},
      </if>
      <if test="sttlmmk != null" >
        STTLMMK = #{sttlmmk,jdbcType=VARCHAR},
      </if>
      <if test="applyDate != null" >
        APPLY_DATE = #{applyDate,jdbcType=TIMESTAMP},
      </if>
      <if test="businessDate != null" >
        BUSINESS_DATE = #{businessDate,jdbcType=TIMESTAMP},
      </if>
      <if test="rcrsokmoney != null" >
        RCRSOKMONEY = #{rcrsokmoney,jdbcType=DECIMAL},
      </if>
      <if test="cnAccrecords != null" >
        CN_ACCRECORDS = #{cnAccrecords,jdbcType=VARCHAR},
      </if>
      <if test="signUpFlag != null" >
        SIGN_UP_FLAG = #{signUpFlag,jdbcType=VARCHAR},
      </if>
      <if test="abs != null" >
        ABS = #{abs,jdbcType=VARCHAR},
      </if>
      <if test="rmk != null" >
        RMK = #{rmk,jdbcType=VARCHAR},
      </if>
      <if test="creditCode != null" >
        CREDIT_CODE = #{creditCode,jdbcType=VARCHAR},
      </if>
      <if test="budgetCode != null" >
        BUDGET_CODE = #{budgetCode,jdbcType=VARCHAR},
      </if>
      <if test="bailAcc != null" >
        BAIL_ACC = #{bailAcc,jdbcType=VARCHAR},
      </if>
      <if test="bailmoney != null" >
        BAILMONEY = #{bailmoney,jdbcType=DECIMAL},
      </if>
      <if test="bailpercent != null" >
        BAILPERCENT = #{bailpercent,jdbcType=DECIMAL},
      </if>
      <if test="bailrate != null" >
        BAILRATE = #{bailrate,jdbcType=DECIMAL},
      </if>
      <if test="feemoney != null" >
        FEEMONEY = #{feemoney,jdbcType=DECIMAL},
      </if>
      <if test="rcrsrsncd != null" >
        RCRSRSNCD = #{rcrsrsncd,jdbcType=VARCHAR},
      </if>
      <if test="rcrsTp != null" >
        RCRS_TP = #{rcrsTp,jdbcType=VARCHAR},
      </if>
      <if test="signerok != null" >
        SIGNEROK = #{signerok,jdbcType=VARCHAR},
      </if>
      <if test="bifCode != null" >
        BIF_CODE = #{bifCode,jdbcType=VARCHAR},
      </if>
      <if test="reqRole != null" >
        REQ_ROLE = #{reqRole,jdbcType=VARCHAR},
      </if>
      <if test="reqNm != null" >
        REQ_NM = #{reqNm,jdbcType=VARCHAR},
      </if>
      <if test="reqCmonid != null" >
        REQ_CMONID = #{reqCmonid,jdbcType=VARCHAR},
      </if>
      <if test="reqAcctId != null" >
        REQ_ACCT_ID = #{reqAcctId,jdbcType=VARCHAR},
      </if>
      <if test="reqAcctsvcr != null" >
        REQ_ACCTSVCR = #{reqAcctsvcr,jdbcType=VARCHAR},
      </if>
      <if test="reqAcctsvcrAg != null" >
        REQ_ACCTSVCR_AG = #{reqAcctsvcrAg,jdbcType=VARCHAR},
      </if>
      <if test="recRole != null" >
        REC_ROLE = #{recRole,jdbcType=VARCHAR},
      </if>
      <if test="recNm != null" >
        REC_NM = #{recNm,jdbcType=VARCHAR},
      </if>
      <if test="recCmonid != null" >
        REC_CMONID = #{recCmonid,jdbcType=VARCHAR},
      </if>
      <if test="recAcctId != null" >
        REC_ACCT_ID = #{recAcctId,jdbcType=VARCHAR},
      </if>
      <if test="recAcctsvcr != null" >
        REC_ACCTSVCR = #{recAcctsvcr,jdbcType=VARCHAR},
      </if>
      <if test="recAcctsvcrAg != null" >
        REC_ACCTSVCR_AG = #{recAcctsvcrAg,jdbcType=VARCHAR},
      </if>
      <if test="busGlobalId != null" >
        BUS_GLOBAL_ID = #{busGlobalId,jdbcType=VARCHAR},
      </if>
      <if test="attachmentId != null" >
        ATTACHMENT_ID = #{attachmentId,jdbcType=VARCHAR},
      </if>
      <if test="cdtRatgs != null" >
        CDT_RATGS = #{cdtRatgs,jdbcType=VARCHAR},
      </if>
      <if test="cdtRatgAgcy != null" >
        CDT_RATG_AGCY = #{cdtRatgAgcy,jdbcType=VARCHAR},
      </if>
      <if test="cdtRatgDuedt != null" >
        CDT_RATG_DUEDT = #{cdtRatgDuedt,jdbcType=TIMESTAMP},
      </if>
      <if test="emitSttlmmk != null" >
        EMIT_STTLMMK = #{emitSttlmmk,jdbcType=VARCHAR},
      </if>
      <if test="createName != null" >
        CREATE_NAME = #{createName,jdbcType=VARCHAR},
      </if>
      <if test="createBy != null" >
        CREATE_BY = #{createBy,jdbcType=VARCHAR},
      </if>
      <if test="createDate != null" >
        CREATE_DATE = #{createDate,jdbcType=TIMESTAMP},
      </if>
      <if test="updateName != null" >
        UPDATE_NAME = #{updateName,jdbcType=VARCHAR},
      </if>
      <if test="updateBy != null" >
        UPDATE_BY = #{updateBy,jdbcType=VARCHAR},
      </if>
      <if test="updateDate != null" >
        UPDATE_DATE = #{updateDate,jdbcType=TIMESTAMP},
      </if>
      <if test="billId != null" >
        BILL_ID = #{billId,jdbcType=VARCHAR},
      </if>
      <if test="msgId != null" >
        MSG_ID = #{msgId,jdbcType=VARCHAR},
      </if>
      <if test="trader != null" >
        TRADER = #{trader,jdbcType=VARCHAR},
      </if>
      <if test="rsn != null" >
        RSN = #{rsn,jdbcType=VARCHAR},
      </if>
      <if test="pdId != null" >
        PD_ID = #{pdId,jdbcType=VARCHAR},
      </if>
      <if test="isAutosign != null" >
        IS_AUTOSIGN = #{isAutosign,jdbcType=VARCHAR},
      </if>
      <if test="adr != null" >
        ADR = #{adr,jdbcType=LONGVARCHAR},
      </if>
    </set>
    where ID = #{id,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKeyWithBLOBs" parameterType="com.entity.ab_accrecords" >
    update ab_accrecords
    set VID = #{vid,jdbcType=VARCHAR},
      VVID = #{vvid,jdbcType=VARCHAR},
      RECID = #{recid,jdbcType=VARCHAR},
      TRID = #{trid,jdbcType=VARCHAR},
      LASTID = #{lastid,jdbcType=VARCHAR},
      LASTBILLCODE = #{lastbillcode,jdbcType=VARCHAR},
      VALID_SIGN = #{validSign,jdbcType=CHAR},
      IS_HIDE = #{isHide,jdbcType=VARCHAR},
      STATUS = #{status,jdbcType=DECIMAL},
      OPT_STATUS = #{optStatus,jdbcType=VARCHAR},
      SEND_SIGN = #{sendSign,jdbcType=CHAR},
      BILL_SOURCE = #{billSource,jdbcType=VARCHAR},
      RETURN_CODE = #{returnCode,jdbcType=VARCHAR},
      RETURN_MSG = #{returnMsg,jdbcType=VARCHAR},
      BRIEF_ID = #{briefId,jdbcType=VARCHAR},
      INSIDE_SING = #{insideSing,jdbcType=DECIMAL},
      ENTER_STOCK_NEW = #{enterStockNew,jdbcType=VARCHAR},
      ENTER_STOCK_OLD = #{enterStockOld,jdbcType=VARCHAR},
      BAIL_TYPE = #{bailType,jdbcType=VARCHAR},
      RECALL_TYPE = #{recallType,jdbcType=VARCHAR},
      BANKENDRSMTMK = #{bankendrsmtmk,jdbcType=VARCHAR},
      STTLMMK = #{sttlmmk,jdbcType=VARCHAR},
      APPLY_DATE = #{applyDate,jdbcType=TIMESTAMP},
      BUSINESS_DATE = #{businessDate,jdbcType=TIMESTAMP},
      RCRSOKMONEY = #{rcrsokmoney,jdbcType=DECIMAL},
      CN_ACCRECORDS = #{cnAccrecords,jdbcType=VARCHAR},
      SIGN_UP_FLAG = #{signUpFlag,jdbcType=VARCHAR},
      ABS = #{abs,jdbcType=VARCHAR},
      RMK = #{rmk,jdbcType=VARCHAR},
      CREDIT_CODE = #{creditCode,jdbcType=VARCHAR},
      BUDGET_CODE = #{budgetCode,jdbcType=VARCHAR},
      BAIL_ACC = #{bailAcc,jdbcType=VARCHAR},
      BAILMONEY = #{bailmoney,jdbcType=DECIMAL},
      BAILPERCENT = #{bailpercent,jdbcType=DECIMAL},
      BAILRATE = #{bailrate,jdbcType=DECIMAL},
      FEEMONEY = #{feemoney,jdbcType=DECIMAL},
      RCRSRSNCD = #{rcrsrsncd,jdbcType=VARCHAR},
      RCRS_TP = #{rcrsTp,jdbcType=VARCHAR},
      SIGNEROK = #{signerok,jdbcType=VARCHAR},
      BIF_CODE = #{bifCode,jdbcType=VARCHAR},
      REQ_ROLE = #{reqRole,jdbcType=VARCHAR},
      REQ_NM = #{reqNm,jdbcType=VARCHAR},
      REQ_CMONID = #{reqCmonid,jdbcType=VARCHAR},
      REQ_ACCT_ID = #{reqAcctId,jdbcType=VARCHAR},
      REQ_ACCTSVCR = #{reqAcctsvcr,jdbcType=VARCHAR},
      REQ_ACCTSVCR_AG = #{reqAcctsvcrAg,jdbcType=VARCHAR},
      REC_ROLE = #{recRole,jdbcType=VARCHAR},
      REC_NM = #{recNm,jdbcType=VARCHAR},
      REC_CMONID = #{recCmonid,jdbcType=VARCHAR},
      REC_ACCT_ID = #{recAcctId,jdbcType=VARCHAR},
      REC_ACCTSVCR = #{recAcctsvcr,jdbcType=VARCHAR},
      REC_ACCTSVCR_AG = #{recAcctsvcrAg,jdbcType=VARCHAR},
      BUS_GLOBAL_ID = #{busGlobalId,jdbcType=VARCHAR},
      ATTACHMENT_ID = #{attachmentId,jdbcType=VARCHAR},
      CDT_RATGS = #{cdtRatgs,jdbcType=VARCHAR},
      CDT_RATG_AGCY = #{cdtRatgAgcy,jdbcType=VARCHAR},
      CDT_RATG_DUEDT = #{cdtRatgDuedt,jdbcType=TIMESTAMP},
      EMIT_STTLMMK = #{emitSttlmmk,jdbcType=VARCHAR},
      CREATE_NAME = #{createName,jdbcType=VARCHAR},
      CREATE_BY = #{createBy,jdbcType=VARCHAR},
      CREATE_DATE = #{createDate,jdbcType=TIMESTAMP},
      UPDATE_NAME = #{updateName,jdbcType=VARCHAR},
      UPDATE_BY = #{updateBy,jdbcType=VARCHAR},
      UPDATE_DATE = #{updateDate,jdbcType=TIMESTAMP},
      BILL_ID = #{billId,jdbcType=VARCHAR},
      MSG_ID = #{msgId,jdbcType=VARCHAR},
      TRADER = #{trader,jdbcType=VARCHAR},
      RSN = #{rsn,jdbcType=VARCHAR},
      PD_ID = #{pdId,jdbcType=VARCHAR},
      IS_AUTOSIGN = #{isAutosign,jdbcType=VARCHAR},
      ADR = #{adr,jdbcType=LONGVARCHAR}
    where ID = #{id,jdbcType=VARCHAR}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.entity.ab_accrecords" >
    update ab_accrecords
    set VID = #{vid,jdbcType=VARCHAR},
      VVID = #{vvid,jdbcType=VARCHAR},
      RECID = #{recid,jdbcType=VARCHAR},
      TRID = #{trid,jdbcType=VARCHAR},
      LASTID = #{lastid,jdbcType=VARCHAR},
      LASTBILLCODE = #{lastbillcode,jdbcType=VARCHAR},
      VALID_SIGN = #{validSign,jdbcType=CHAR},
      IS_HIDE = #{isHide,jdbcType=VARCHAR},
      STATUS = #{status,jdbcType=DECIMAL},
      OPT_STATUS = #{optStatus,jdbcType=VARCHAR},
      SEND_SIGN = #{sendSign,jdbcType=CHAR},
      BILL_SOURCE = #{billSource,jdbcType=VARCHAR},
      RETURN_CODE = #{returnCode,jdbcType=VARCHAR},
      RETURN_MSG = #{returnMsg,jdbcType=VARCHAR},
      BRIEF_ID = #{briefId,jdbcType=VARCHAR},
      INSIDE_SING = #{insideSing,jdbcType=DECIMAL},
      ENTER_STOCK_NEW = #{enterStockNew,jdbcType=VARCHAR},
      ENTER_STOCK_OLD = #{enterStockOld,jdbcType=VARCHAR},
      BAIL_TYPE = #{bailType,jdbcType=VARCHAR},
      RECALL_TYPE = #{recallType,jdbcType=VARCHAR},
      BANKENDRSMTMK = #{bankendrsmtmk,jdbcType=VARCHAR},
      STTLMMK = #{sttlmmk,jdbcType=VARCHAR},
      APPLY_DATE = #{applyDate,jdbcType=TIMESTAMP},
      BUSINESS_DATE = #{businessDate,jdbcType=TIMESTAMP},
      RCRSOKMONEY = #{rcrsokmoney,jdbcType=DECIMAL},
      CN_ACCRECORDS = #{cnAccrecords,jdbcType=VARCHAR},
      SIGN_UP_FLAG = #{signUpFlag,jdbcType=VARCHAR},
      ABS = #{abs,jdbcType=VARCHAR},
      RMK = #{rmk,jdbcType=VARCHAR},
      CREDIT_CODE = #{creditCode,jdbcType=VARCHAR},
      BUDGET_CODE = #{budgetCode,jdbcType=VARCHAR},
      BAIL_ACC = #{bailAcc,jdbcType=VARCHAR},
      BAILMONEY = #{bailmoney,jdbcType=DECIMAL},
      BAILPERCENT = #{bailpercent,jdbcType=DECIMAL},
      BAILRATE = #{bailrate,jdbcType=DECIMAL},
      FEEMONEY = #{feemoney,jdbcType=DECIMAL},
      RCRSRSNCD = #{rcrsrsncd,jdbcType=VARCHAR},
      RCRS_TP = #{rcrsTp,jdbcType=VARCHAR},
      SIGNEROK = #{signerok,jdbcType=VARCHAR},
      BIF_CODE = #{bifCode,jdbcType=VARCHAR},
      REQ_ROLE = #{reqRole,jdbcType=VARCHAR},
      REQ_NM = #{reqNm,jdbcType=VARCHAR},
      REQ_CMONID = #{reqCmonid,jdbcType=VARCHAR},
      REQ_ACCT_ID = #{reqAcctId,jdbcType=VARCHAR},
      REQ_ACCTSVCR = #{reqAcctsvcr,jdbcType=VARCHAR},
      REQ_ACCTSVCR_AG = #{reqAcctsvcrAg,jdbcType=VARCHAR},
      REC_ROLE = #{recRole,jdbcType=VARCHAR},
      REC_NM = #{recNm,jdbcType=VARCHAR},
      REC_CMONID = #{recCmonid,jdbcType=VARCHAR},
      REC_ACCT_ID = #{recAcctId,jdbcType=VARCHAR},
      REC_ACCTSVCR = #{recAcctsvcr,jdbcType=VARCHAR},
      REC_ACCTSVCR_AG = #{recAcctsvcrAg,jdbcType=VARCHAR},
      BUS_GLOBAL_ID = #{busGlobalId,jdbcType=VARCHAR},
      ATTACHMENT_ID = #{attachmentId,jdbcType=VARCHAR},
      CDT_RATGS = #{cdtRatgs,jdbcType=VARCHAR},
      CDT_RATG_AGCY = #{cdtRatgAgcy,jdbcType=VARCHAR},
      CDT_RATG_DUEDT = #{cdtRatgDuedt,jdbcType=TIMESTAMP},
      EMIT_STTLMMK = #{emitSttlmmk,jdbcType=VARCHAR},
      CREATE_NAME = #{createName,jdbcType=VARCHAR},
      CREATE_BY = #{createBy,jdbcType=VARCHAR},
      CREATE_DATE = #{createDate,jdbcType=TIMESTAMP},
      UPDATE_NAME = #{updateName,jdbcType=VARCHAR},
      UPDATE_BY = #{updateBy,jdbcType=VARCHAR},
      UPDATE_DATE = #{updateDate,jdbcType=TIMESTAMP},
      BILL_ID = #{billId,jdbcType=VARCHAR},
      MSG_ID = #{msgId,jdbcType=VARCHAR},
      TRADER = #{trader,jdbcType=VARCHAR},
      RSN = #{rsn,jdbcType=VARCHAR},
      PD_ID = #{pdId,jdbcType=VARCHAR},
      IS_AUTOSIGN = #{isAutosign,jdbcType=VARCHAR}
    where ID = #{id,jdbcType=VARCHAR}
  </update>
</mapper>

接口层

package com.dao;

import com.entity.ab_accrecords;

public interface ab_accrecordsMapper {
    int deleteByPrimaryKey(String id);

    int insert(ab_accrecords record);

    int insertSelective(ab_accrecords record);

    ab_accrecords selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(ab_accrecords record);

    int updateByPrimaryKeyWithBLOBs(ab_accrecords record);

    int updateByPrimaryKey(ab_accrecords record);
}

实体类

package com.entity;

import java.math.BigDecimal;
import java.util.Date;

public class ab_accrecords {
    private String id;

    private String vid;

    private String vvid;

    private String recid;

    private String trid;

    private String lastid;

    private String lastbillcode;

    private String validSign;

    private String isHide;

    private Integer status;

    private String optStatus;

    private String sendSign;

    private String billSource;

    private String returnCode;

    private String returnMsg;

    private String briefId;

    private Integer insideSing;

    private String enterStockNew;

    private String enterStockOld;

    private String bailType;

    private String recallType;

    private String bankendrsmtmk;

    private String sttlmmk;

    private Date applyDate;

    private Date businessDate;

    private BigDecimal rcrsokmoney;

    private String cnAccrecords;

    private String signUpFlag;

    private String abs;

    private String rmk;

    private String creditCode;

    private String budgetCode;

    private String bailAcc;

    private BigDecimal bailmoney;

    private BigDecimal bailpercent;

    private BigDecimal bailrate;

    private BigDecimal feemoney;

    private String rcrsrsncd;

    private String rcrsTp;

    private String signerok;

    private String bifCode;

    private String reqRole;

    private String reqNm;

    private String reqCmonid;

    private String reqAcctId;

    private String reqAcctsvcr;

    private String reqAcctsvcrAg;

    private String recRole;

    private String recNm;

    private String recCmonid;

    private String recAcctId;

    private String recAcctsvcr;

    private String recAcctsvcrAg;

    private String busGlobalId;

    private String attachmentId;

    private String cdtRatgs;

    private String cdtRatgAgcy;

    private Date cdtRatgDuedt;

    private String emitSttlmmk;

    private String createName;

    private String createBy;

    private Date createDate;

    private String updateName;

    private String updateBy;

    private Date updateDate;

    private String billId;

    private String msgId;

    private String trader;

    private String rsn;

    private String pdId;

    private String isAutosign;

    private String adr;

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id == null ? null : id.trim();
    }

    public String getVid() {
        return vid;
    }

    public void setVid(String vid) {
        this.vid = vid == null ? null : vid.trim();
    }

    public String getVvid() {
        return vvid;
    }

    public void setVvid(String vvid) {
        this.vvid = vvid == null ? null : vvid.trim();
    }

    public String getRecid() {
        return recid;
    }

    public void setRecid(String recid) {
        this.recid = recid == null ? null : recid.trim();
    }

    public String getTrid() {
        return trid;
    }

    public void setTrid(String trid) {
        this.trid = trid == null ? null : trid.trim();
    }

    public String getLastid() {
        return lastid;
    }

    public void setLastid(String lastid) {
        this.lastid = lastid == null ? null : lastid.trim();
    }

    public String getLastbillcode() {
        return lastbillcode;
    }

    public void setLastbillcode(String lastbillcode) {
        this.lastbillcode = lastbillcode == null ? null : lastbillcode.trim();
    }

    public String getValidSign() {
        return validSign;
    }

    public void setValidSign(String validSign) {
        this.validSign = validSign == null ? null : validSign.trim();
    }

    public String getIsHide() {
        return isHide;
    }

    public void setIsHide(String isHide) {
        this.isHide = isHide == null ? null : isHide.trim();
    }

    public Integer getStatus() {
        return status;
    }

    public void setStatus(Integer status) {
        this.status = status;
    }

    public String getOptStatus() {
        return optStatus;
    }

    public void setOptStatus(String optStatus) {
        this.optStatus = optStatus == null ? null : optStatus.trim();
    }

    public String getSendSign() {
        return sendSign;
    }

    public void setSendSign(String sendSign) {
        this.sendSign = sendSign == null ? null : sendSign.trim();
    }

    public String getBillSource() {
        return billSource;
    }

    public void setBillSource(String billSource) {
        this.billSource = billSource == null ? null : billSource.trim();
    }

    public String getReturnCode() {
        return returnCode;
    }

    public void setReturnCode(String returnCode) {
        this.returnCode = returnCode == null ? null : returnCode.trim();
    }

    public String getReturnMsg() {
        return returnMsg;
    }

    public void setReturnMsg(String returnMsg) {
        this.returnMsg = returnMsg == null ? null : returnMsg.trim();
    }

    public String getBriefId() {
        return briefId;
    }

    public void setBriefId(String briefId) {
        this.briefId = briefId == null ? null : briefId.trim();
    }

    public Integer getInsideSing() {
        return insideSing;
    }

    public void setInsideSing(Integer insideSing) {
        this.insideSing = insideSing;
    }

    public String getEnterStockNew() {
        return enterStockNew;
    }

    public void setEnterStockNew(String enterStockNew) {
        this.enterStockNew = enterStockNew == null ? null : enterStockNew.trim();
    }

    public String getEnterStockOld() {
        return enterStockOld;
    }

    public void setEnterStockOld(String enterStockOld) {
        this.enterStockOld = enterStockOld == null ? null : enterStockOld.trim();
    }

    public String getBailType() {
        return bailType;
    }

    public void setBailType(String bailType) {
        this.bailType = bailType == null ? null : bailType.trim();
    }

    public String getRecallType() {
        return recallType;
    }

    public void setRecallType(String recallType) {
        this.recallType = recallType == null ? null : recallType.trim();
    }

    public String getBankendrsmtmk() {
        return bankendrsmtmk;
    }

    public void setBankendrsmtmk(String bankendrsmtmk) {
        this.bankendrsmtmk = bankendrsmtmk == null ? null : bankendrsmtmk.trim();
    }

    public String getSttlmmk() {
        return sttlmmk;
    }

    public void setSttlmmk(String sttlmmk) {
        this.sttlmmk = sttlmmk == null ? null : sttlmmk.trim();
    }

    public Date getApplyDate() {
        return applyDate;
    }

    public void setApplyDate(Date applyDate) {
        this.applyDate = applyDate;
    }

    public Date getBusinessDate() {
        return businessDate;
    }

    public void setBusinessDate(Date businessDate) {
        this.businessDate = businessDate;
    }

    public BigDecimal getRcrsokmoney() {
        return rcrsokmoney;
    }

    public void setRcrsokmoney(BigDecimal rcrsokmoney) {
        this.rcrsokmoney = rcrsokmoney;
    }

    public String getCnAccrecords() {
        return cnAccrecords;
    }

    public void setCnAccrecords(String cnAccrecords) {
        this.cnAccrecords = cnAccrecords == null ? null : cnAccrecords.trim();
    }

    public String getSignUpFlag() {
        return signUpFlag;
    }

    public void setSignUpFlag(String signUpFlag) {
        this.signUpFlag = signUpFlag == null ? null : signUpFlag.trim();
    }

    public String getAbs() {
        return abs;
    }

    public void setAbs(String abs) {
        this.abs = abs == null ? null : abs.trim();
    }

    public String getRmk() {
        return rmk;
    }

    public void setRmk(String rmk) {
        this.rmk = rmk == null ? null : rmk.trim();
    }

    public String getCreditCode() {
        return creditCode;
    }

    public void setCreditCode(String creditCode) {
        this.creditCode = creditCode == null ? null : creditCode.trim();
    }

    public String getBudgetCode() {
        return budgetCode;
    }

    public void setBudgetCode(String budgetCode) {
        this.budgetCode = budgetCode == null ? null : budgetCode.trim();
    }

    public String getBailAcc() {
        return bailAcc;
    }

    public void setBailAcc(String bailAcc) {
        this.bailAcc = bailAcc == null ? null : bailAcc.trim();
    }

    public BigDecimal getBailmoney() {
        return bailmoney;
    }

    public void setBailmoney(BigDecimal bailmoney) {
        this.bailmoney = bailmoney;
    }

    public BigDecimal getBailpercent() {
        return bailpercent;
    }

    public void setBailpercent(BigDecimal bailpercent) {
        this.bailpercent = bailpercent;
    }

    public BigDecimal getBailrate() {
        return bailrate;
    }

    public void setBailrate(BigDecimal bailrate) {
        this.bailrate = bailrate;
    }

    public BigDecimal getFeemoney() {
        return feemoney;
    }

    public void setFeemoney(BigDecimal feemoney) {
        this.feemoney = feemoney;
    }

    public String getRcrsrsncd() {
        return rcrsrsncd;
    }

    public void setRcrsrsncd(String rcrsrsncd) {
        this.rcrsrsncd = rcrsrsncd == null ? null : rcrsrsncd.trim();
    }

    public String getRcrsTp() {
        return rcrsTp;
    }

    public void setRcrsTp(String rcrsTp) {
        this.rcrsTp = rcrsTp == null ? null : rcrsTp.trim();
    }

    public String getSignerok() {
        return signerok;
    }

    public void setSignerok(String signerok) {
        this.signerok = signerok == null ? null : signerok.trim();
    }

    public String getBifCode() {
        return bifCode;
    }

    public void setBifCode(String bifCode) {
        this.bifCode = bifCode == null ? null : bifCode.trim();
    }

    public String getReqRole() {
        return reqRole;
    }

    public void setReqRole(String reqRole) {
        this.reqRole = reqRole == null ? null : reqRole.trim();
    }

    public String getReqNm() {
        return reqNm;
    }

    public void setReqNm(String reqNm) {
        this.reqNm = reqNm == null ? null : reqNm.trim();
    }

    public String getReqCmonid() {
        return reqCmonid;
    }

    public void setReqCmonid(String reqCmonid) {
        this.reqCmonid = reqCmonid == null ? null : reqCmonid.trim();
    }

    public String getReqAcctId() {
        return reqAcctId;
    }

    public void setReqAcctId(String reqAcctId) {
        this.reqAcctId = reqAcctId == null ? null : reqAcctId.trim();
    }

    public String getReqAcctsvcr() {
        return reqAcctsvcr;
    }

    public void setReqAcctsvcr(String reqAcctsvcr) {
        this.reqAcctsvcr = reqAcctsvcr == null ? null : reqAcctsvcr.trim();
    }

    public String getReqAcctsvcrAg() {
        return reqAcctsvcrAg;
    }

    public void setReqAcctsvcrAg(String reqAcctsvcrAg) {
        this.reqAcctsvcrAg = reqAcctsvcrAg == null ? null : reqAcctsvcrAg.trim();
    }

    public String getRecRole() {
        return recRole;
    }

    public void setRecRole(String recRole) {
        this.recRole = recRole == null ? null : recRole.trim();
    }

    public String getRecNm() {
        return recNm;
    }

    public void setRecNm(String recNm) {
        this.recNm = recNm == null ? null : recNm.trim();
    }

    public String getRecCmonid() {
        return recCmonid;
    }

    public void setRecCmonid(String recCmonid) {
        this.recCmonid = recCmonid == null ? null : recCmonid.trim();
    }

    public String getRecAcctId() {
        return recAcctId;
    }

    public void setRecAcctId(String recAcctId) {
        this.recAcctId = recAcctId == null ? null : recAcctId.trim();
    }

    public String getRecAcctsvcr() {
        return recAcctsvcr;
    }

    public void setRecAcctsvcr(String recAcctsvcr) {
        this.recAcctsvcr = recAcctsvcr == null ? null : recAcctsvcr.trim();
    }

    public String getRecAcctsvcrAg() {
        return recAcctsvcrAg;
    }

    public void setRecAcctsvcrAg(String recAcctsvcrAg) {
        this.recAcctsvcrAg = recAcctsvcrAg == null ? null : recAcctsvcrAg.trim();
    }

    public String getBusGlobalId() {
        return busGlobalId;
    }

    public void setBusGlobalId(String busGlobalId) {
        this.busGlobalId = busGlobalId == null ? null : busGlobalId.trim();
    }

    public String getAttachmentId() {
        return attachmentId;
    }

    public void setAttachmentId(String attachmentId) {
        this.attachmentId = attachmentId == null ? null : attachmentId.trim();
    }

    public String getCdtRatgs() {
        return cdtRatgs;
    }

    public void setCdtRatgs(String cdtRatgs) {
        this.cdtRatgs = cdtRatgs == null ? null : cdtRatgs.trim();
    }

    public String getCdtRatgAgcy() {
        return cdtRatgAgcy;
    }

    public void setCdtRatgAgcy(String cdtRatgAgcy) {
        this.cdtRatgAgcy = cdtRatgAgcy == null ? null : cdtRatgAgcy.trim();
    }

    public Date getCdtRatgDuedt() {
        return cdtRatgDuedt;
    }

    public void setCdtRatgDuedt(Date cdtRatgDuedt) {
        this.cdtRatgDuedt = cdtRatgDuedt;
    }

    public String getEmitSttlmmk() {
        return emitSttlmmk;
    }

    public void setEmitSttlmmk(String emitSttlmmk) {
        this.emitSttlmmk = emitSttlmmk == null ? null : emitSttlmmk.trim();
    }

    public String getCreateName() {
        return createName;
    }

    public void setCreateName(String createName) {
        this.createName = createName == null ? null : createName.trim();
    }

    public String getCreateBy() {
        return createBy;
    }

    public void setCreateBy(String createBy) {
        this.createBy = createBy == null ? null : createBy.trim();
    }

    public Date getCreateDate() {
        return createDate;
    }

    public void setCreateDate(Date createDate) {
        this.createDate = createDate;
    }

    public String getUpdateName() {
        return updateName;
    }

    public void setUpdateName(String updateName) {
        this.updateName = updateName == null ? null : updateName.trim();
    }

    public String getUpdateBy() {
        return updateBy;
    }

    public void setUpdateBy(String updateBy) {
        this.updateBy = updateBy == null ? null : updateBy.trim();
    }

    public Date getUpdateDate() {
        return updateDate;
    }

    public void setUpdateDate(Date updateDate) {
        this.updateDate = updateDate;
    }

    public String getBillId() {
        return billId;
    }

    public void setBillId(String billId) {
        this.billId = billId == null ? null : billId.trim();
    }

    public String getMsgId() {
        return msgId;
    }

    public void setMsgId(String msgId) {
        this.msgId = msgId == null ? null : msgId.trim();
    }

    public String getTrader() {
        return trader;
    }

    public void setTrader(String trader) {
        this.trader = trader == null ? null : trader.trim();
    }

    public String getRsn() {
        return rsn;
    }

    public void setRsn(String rsn) {
        this.rsn = rsn == null ? null : rsn.trim();
    }

    public String getPdId() {
        return pdId;
    }

    public void setPdId(String pdId) {
        this.pdId = pdId == null ? null : pdId.trim();
    }

    public String getIsAutosign() {
        return isAutosign;
    }

    public void setIsAutosign(String isAutosign) {
        this.isAutosign = isAutosign == null ? null : isAutosign.trim();
    }

    public String getAdr() {
        return adr;
    }

    public void setAdr(String adr) {
        this.adr = adr == null ? null : adr.trim();
    }
}

简单粗暴，你学废了吗？

Oracle数据库请参考另一篇文章：
https://blog.csdn.net/qq_37928228/article/details/110699441

实例项目文件下载：
https://download.csdn.net/download/qq_37928228/13455402
或者
https://download.csdn.net/download/qq_37928228/13455392