mybatis批量保存

发布时间 2023-07-26 13:58:03作者: chen1777
<insert id="saveBatchForList" parameterType="java.util.List">
        insert into T_PRICE_PPI_BASEWEIGHT (BASEYEAR,ORGCODE,ORGNAME, BASECODE,
        BASENAME,WEIGHT,DATA_TYPE,STARTTIME,CREATOR,CREATETIME,AREACODE,AREANAME,GROUP_ITEM_TYPE,AMOUNT,STATUS,BASEWEIGHT_VERSION)
        values
        <foreach collection="list" item="item" index="index" separator=",">
            (#{item.baseyear},#{item.orgcode},#{item.orgname},#{item.basecode},#{item.basename},#{item.weight},#{item.dataType},#{item.starttime},#{item.creator},
            #{item.createtime},#{item.areacode},#{item.areaname},#{item.groupItemType},#{item.amount},#{item.status},#{item.baseweightVersion})
        </foreach>
    </insert>