单句新增:
<insert id="insertPlayerItemData" parameterType="java.util.List">
INSERT INTO lost_player_item_info (
player_id,
func_id,
item_id,
item_num)
VALUES
#{playerId,jdbcType=BIGINT},
#{funcId,jdbcType=BIGINT},
#{itemId,jdbcType=INTEGER},
#{itemNum,jdbcType=INTEGER}
ON DUPLICATE KEY UPDATE
item_num = #{itemNum,jdbcType=INTEGER}
</insert>
批量新增:(格式:VALUES(xx))
<insert id="insertPlayerItemData" parameterType="java.util.List">
INSERT INTO lost_player_item_info (
player_id,
func_id,
item_id,
item_num)
VALUES
<foreach collection ="list" item="item" index= "index" separator =",">
(
#{item.playerId,jdbcType=BIGINT},
#{item.funcId,jdbcType=BIGINT},
#{item.itemId,jdbcType=INTEGER},
#{item.itemNum,jdbcType=INTEGER}
)
</foreach >
ON DUPLICATE KEY UPDATE
item_num = VALUES(item_num)
</insert>