批量更新
@Update("<script>"
+ "UPDATE sy_game_register_retain "
+ "SET "
+ "retain_user = CASE id "
+ "<foreach collection='list' item='item' index='index'>"
+ "WHEN #{item.id} THEN #{item.retainUser} "
+ "</foreach>"
+ "END, "
+ "retain_new_pay_user = CASE id "
+ "<foreach collection='list' item='item' index='index'>"
+ "WHEN #{item.id} THEN #{item.retainNewPayUser} "
+ "</foreach>"
+ "END, "
+ "retain_active_number = CASE id "
+ "<foreach collection='list' item='item' index='index'>"
+ "WHEN #{item.id} THEN #{item.retainActiveNumber} "
+ "</foreach>"
+ "END, "
+ "register_retain_payment = CASE id "
+ "<foreach collection='list' item='item' index='index'>"
+ "WHEN #{item.id} THEN #{item.registerRetainPayment} "
+ "</foreach>"
+ "END, "
+ "region_code = CASE id "
+ "<foreach collection='list' item='item' index='index'>"
+ "WHEN #{item.id} THEN #{item.regionCode} "
+ "</foreach>"
+ "END, "
+ "modified_time = CASE id "
+ "<foreach collection='list' item='item' index='index'>"
+ "WHEN #{item.id} THEN #{item.modifiedTime} "
+ "</foreach>"
+ "END "
+ "WHERE id IN "
+ "<foreach collection='list' item='item' index='index' open='(' close=')' separator=','>"
+ " #{item.id}"
+ "</foreach>"
+ "</script>")
void batchUpdate(@Param("list") List<GameRegisterRetainDO> list);
批量插入
@Insert("<script>"
+ "INSERT INTO sy_game_register_retain "
+ "(gid,gcid,platform,benchmark_date,days,retain_user,created_time,modified_time,"
+ "retain_new_pay_user,retain_active_number,register_retain_payment,region_code) "
+ "VALUES "
+ "<foreach collection='list' item='item' separator=',' >"
+ " ( "
+ " #{item.gid},#{item.gcid},#{item.benchmarkDate},#{item.days},#{item.retainUser},"
+ " unix_timestamp(),unix_timestamp(),#{item.retainNewPayUser},#{item.retainNewPayUser},"
+ "#{item.retainActiveNumber},#{item.registerRetainPayment},#{item.regionCode} "
+ " ) "
+ "</foreach>"
+ "</script>")
void batchInsert(@Param("list") List<GameRegisterRetainDO> list);