1. 批量更新:
@Update({"<script>" + "<foreach collection="smsConfigTemplateList" item="item" separator=";">" + " UPDATE" + " mt_message_template" + " SET pushapp_type = #{item.pushAppType, jdbcType=VARCHAR}, " + " message_title = #{item.messageTitle, jdbcType=VARCHAR}, " + " message_content = #{item.messageContent, jdbcType=VARCHAR}, " + " template_id_weixin = #{item.emplateIdWeixin, jdbcType=VARCHAR}, " + " template_weixin = #{item.templateWeixin, jdbcType=VARCHAR}, " + " template_alipay = #{item.templateAlipay, jdbcType=VARCHAR}, " + " template_id_zhifubao = #{item.templateIdZhifubao, jdbcType=VARCHAR}, " + " modifiedon = #{item.modifiedon, jdbcType=TIMESTAMP}, " + " modifiedby = #{item.modifiedby, jdbcType=VARCHAR} " + " WHERE " + " message_template_id = #{item.messageTemplateId, jdbcType=VARCHAR} " + " AND deletion_state = '0' " + "</foreach>" + "</script>"}) void update(@Param("smsConfigTemplateList") List<SmsConfigTemplate> smsConfigTemplateList);
2. 批量新增:
@Insert({"<script>" + "INSERT INTO mt_message_template (" + "message_template_id, " + "message_template_head_id, " + "message_title, " + "message_content, " + "pushapp_type, " + "platform_hospital_id, " + "template_id_weixin, " + "template_weixin, " + "template_alipay, " + "template_id_zhifubao, " + "createdby, " + "createdon, " + "modifiedby, " + "modifiedon, " + "deletion_state)" + "values " + "<foreach collection="mtMessageTemplateList" item="item" separator=",">" + "(#{item.messageTemplateId}, #{item.messageTemplateHeadId}, " + "#{item.messageTitle}, #{item.messageContent}, " + "#{item.pushAppType}, #{item.platformHospitalId}, " + "#{item.emplateIdWeixin}, #{item.templateWeixin}, " + "#{item.templateAlipay}, #{item.templateIdZhifubao}, " + "#{item.createdby}, #{item.createdon}, " + "#{item.modifiedby}, #{item.modifiedon}, " + "#{item.deletionState})" + "</foreach>" + "</script>"}) void insert(@Param("mtMessageTemplateList") List<MtMessageTemplate> mtMessageTemplateList);