1.批量插入语句
insert into user (name) (select #{item.name,jdbcType=VARCHAR} )2.批量更新(两种)
第一种,只更新一条sql语句
update user when id=#{item.id,jdbcType=INTEGER} then #{item.name,jdbcType=VARCHAR} where id = #{item.id,jdbcType=INTEGER}第二种:更新多条sql语句,需要在url添加&allowMultiQueries=true
update user name = #{item.name,jdbcType=VARCHAR}, age = #{item.age,jdbcType=INTEGER}, version = #{item.version,jdbcType=INTEGER} where id = #{item.id,jdbcType=INTEGER}