工作中遇到的问题,做一个简单记录。
批量更新表里的148条数据
//批量更新
paTerminalService.updateBatch(paTerminalUpdateList);
public interface PaTerminalService {
void updateBatch(List<PaTerminal> paTerminalList);
}
动态sql
<update id="updateBatch" parameterType="java.util.List">
<foreach collection="list" item="item" separator=";">
update pa_terminal set
<if test="item.devid != null and item.devid != ''">
devId = #{item.devid,jdbcType=VARCHAR},
</if>
<if test="item.devname != null and item.devname != ''">
devName = #{item.devname},
</if>
<if test="item.channelno != n