mybatis 注解形式设置批量新增、批量更新数据

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,\n" +
            "message_template_head_id,\n" +
            "message_title,\n" +
            "message_content,\n" +
            "pushapp_type,\n" +
            "platform_hospital_id,\n" +
            "template_id_weixin,\n" +
            "template_weixin,\n" +
            "template_alipay,\n" +
            "template_id_zhifubao,\n" +
            "createdby,\n" +
            "createdon,\n" +
            "modifiedby,\n" +
            "modifiedon,\n" +
            "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);