Mybatis实现批量更新sql语句

Integer insertBatch(@Param(“hyTemplates”)List hyTemplates);

INSERT INTO hy_template (ID,TEMPLATE_ID,ITEM_NAME) VALUES ( #{hytemplate.id,jdbcType=VARCHAR}, #{hytemplate.templateId,jdbcType=VARCHAR}, #{hytemplate.itemName,jdbcType=VARCHAR} )

Integer insert(Organization organization);

SELECT LAST_INSERT_ID() AS id

INSERT INTO organization (NAME, PARENT_ID)
VALUES (#{name,jdbcType=VARCHAR}, #{parentId,jdbcType=VARCHAR})

UPDATE ruleBo Status = #{status,jdbcType=VARCHAR} ID IN #{id,jdbcType=VARCHAR}

方式一:

update tableName name=${item.name}, name2=${item.name2} where id = ${item.id}

方式二:

update tableName when id=#{cus.id} then #{cus.name} when id=#{cus.id} then #{cus.age} id = #{cus.id}