service:
@Transactional(readOnly = false)
public int addSmsMobileTmp(Set<MsgMemberDto> set) {
return sendTaskDao.addSmsMobileTmp(set);
}
@Transactional(readOnly = false)
public void truncateSmsMobileTmp() {
sendTaskDao.truncateSmsMobileTmp();
}
xml:
<insert id="addSmsMobileTmp">
INSERT INTO cs_sms_mobile_tmp(
mobile
) VALUES
<foreach collection ="set" item="item" index= "index" separator =",">
(
#{item.mobile}
)
</foreach>
</insert>
<update id="truncateSmsMobileTmp">
truncate table cs_sms_mobile_tmp
</update>