生成mybatis中的批量插入语句提示词例子
/resultMap>中的相关字段 帮我生成针对 AT_AUCTION_MEM 表的批量插入语句<insert id="batchInsert" parameterType="java.util.List">,且带上jdbcType类型。请根据<resultMap id="BaseResultMap" type="com.dllg.circle.auction.app.application.do
请根据 <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>
更多推荐



所有评论(0)