请根据  <resultMap id="BaseResultMap" type="com.dllg.circle.auction.app.application.domain.generate.AtAuctionMem">
    <!--
      WARNING - @mbg.generated
      This element is automatically generated by MyBatis Generator, do not modify.
    -->
    <id column="AUCTION_MEM_ID" jdbcType="INTEGER" property="auctionMemId" />
    <result column="AUCTION_MEM_CODE" jdbcType="VARCHAR" property="auctionMemCode" />
    <result column="AUCTION_CODE" jdbcType="VARCHAR" property="auctionCode" />
    <result column="AUCTION_NAME" jdbcType="VARCHAR" property="auctionName" />
    <result column="AUCTION_TYPE" jdbcType="VARCHAR" property="auctionType" />
    <result column="MEMBER_CODE" jdbcType="VARCHAR" property="memberCode" />
    <result column="MEMBER_NAME" jdbcType="VARCHAR" property="memberName" />
    <result column="MEMBER_CCODE" jdbcType="VARCHAR" property="memberCcode" />
    <result column="MEMBER_CNAME" jdbcType="VARCHAR" property="memberCname" />
    <result column="AUCTION_MEM_TYPE" jdbcType="VARCHAR" property="auctionMemType" />
    <result column="AUCTION_MEM_OPCODE" jdbcType="VARCHAR" property="auctionMemOpcode" />
    <result column="AUCTION_MEM_OPNAME" jdbcType="VARCHAR" property="auctionMemOpname" />
    <result column="USER_CODE" jdbcType="VARCHAR" property="userCode" />
    <result column="USER_NAME" jdbcType="VARCHAR" property="userName" />
    <result column="GMT_CREATE" jdbcType="TIMESTAMP" property="gmtCreate" />
    <result column="GMT_MODIFIED" jdbcType="TIMESTAMP" property="gmtModified" />
    <result column="MEMO" jdbcType="VARCHAR" property="memo" />
    <result column="DATA_STATE" jdbcType="INTEGER" property="dataState" />
    <result column="TENANT_CODE" jdbcType="VARCHAR" property="tenantCode" />
    <result column="APPMANAGE_ICODE" jdbcType="VARCHAR" property="appmanageIcode" />
  </resultMap>中的相关字段 帮我生成针对 AT_AUCTION_MEM 表的批量插入语句<insert id="batchInsert" parameterType="java.util.List">,且带上jdbcType类型

输入提示词后kimi生成后

int batchInsert(List<AtAuctionMem> list);

下面给出 带完整 jdbcType 的 MyBatis 批量插入片段,字段顺序、属性名、jdbcType 均与原 BaseResultMap 保持完全一致

<!-- 批量插入 AT_AUCTION_MEM,含 jdbcType -->
<insert id="batchInsert" parameterType="java.util.List">
    INSERT INTO AT_AUCTION_MEM
    (
        AUCTION_MEM_ID,
        AUCTION_MEM_CODE,
        AUCTION_CODE,
        AUCTION_NAME,
        AUCTION_TYPE,
        MEMBER_CODE,
        MEMBER_NAME,
        MEMBER_CCODE,
        MEMBER_CNAME,
        AUCTION_MEM_TYPE,
        AUCTION_MEM_OPCODE,
        AUCTION_MEM_OPNAME,
        USER_CODE,
        USER_NAME,
        GMT_CREATE,
        GMT_MODIFIED,
        MEMO,
        DATA_STATE,
        TENANT_CODE,
        APPMANAGE_ICODE
    )
    VALUES
    <foreach collection="list" item="item" separator=",">
        (
            #{item.auctionMemId,      jdbcType=INTEGER},
            #{item.auctionMemCode,    jdbcType=VARCHAR},
            #{item.auctionCode,       jdbcType=VARCHAR},
            #{item.auctionName,       jdbcType=VARCHAR},
            #{item.auctionType,       jdbcType=VARCHAR},
            #{item.memberCode,        jdbcType=VARCHAR},
            #{item.memberName,        jdbcType=VARCHAR},
            #{item.memberCcode,       jdbcType=VARCHAR},
            #{item.memberCname,       jdbcType=VARCHAR},
            #{item.auctionMemType,    jdbcType=VARCHAR},
            #{item.auctionMemOpcode,  jdbcType=VARCHAR},
            #{item.auctionMemOpname,  jdbcType=VARCHAR},
            #{item.userCode,          jdbcType=VARCHAR},
            #{item.userName,          jdbcType=VARCHAR},
            #{item.gmtCreate,         jdbcType=TIMESTAMP},
            #{item.gmtModified,       jdbcType=TIMESTAMP},
            #{item.memo,              jdbcType=VARCHAR},
            #{item.dataState,         jdbcType=INTEGER},
            #{item.tenantCode,        jdbcType=VARCHAR},
            #{item.appmanageIcode,    jdbcType=VARCHAR}
        )
    </foreach>
</insert>

Logo

有“AI”的1024 = 2048,欢迎大家加入2048 AI社区

更多推荐