Mybatis批量插入更新数据

注解(@Mapper中)

批量新增

@Insert("<script>" +
	"INSERT INTO tb_user(name, age, sex)" +
	"VALUES" +
	"<foreach collection = \"list\" item=\"bean\" index=\"index\" separator=\",\">" +
	  "(#{bean.name, #{bean.age}, #{bean.sex})" +
	"</foreach>" +
	"</script>")
int batchSave(@Param("list") List<User> userList);

批量更新

@Update("<script>" +
	"<foreach collection =\"list\" item=\"bean\" index= \"index\" separator =\";\"> " +
	  "UPDATE tb_user SET name=#{bean.name}, age=#{bean.age}, sex=#{bean.sex} WHERE id=#{bean.id}" +
	"</foreach>" +
	"</script>")
int batchUpdate(@Param("list") List<User> userList);

XML(Mapper.xml中)

修改数据库连接配置：&allowMultiQueries=true

比如：jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true

批量新增

<insert id="batchSave" parameterType="java.util.List" >
  INSERT INTO tb_user(name, age, sex)
  VALUES 
   <foreach collection="list" item="bean" index="index" separator="," >
   (#{bean.name, #{bean.age}, #{bean.sex})
   </foreach>
</insert>

批量更新

<update id="batchUpdate" parameterType="java.util.List">
  <foreach collection = "list" item = "bean" index="index" separator = ";" > 
    update tb_user
      <set>
	name=#{bean.name},
	age=#{bean.age},
	sex=#{bean.sex},
     </set>
     WHERE id=#{bean.id}
  </foreach>
</update>