批量插入
"insert into user (userid,name,age) values "
+ " <foreach collection ='list' item='it' separator =','>" +
"(#{it.userid}, #{it.name}, #{it.age})"
+" </foreach>"
批量更新(根据userid,name ,批量更新age字段)
"update user a join ("
+ "<foreach collection ='list' item='it' separator =' union '>"
+ "select #{it.userid} ,#{it.name},#{it.age} "
+ "</foreach>"
+ ")b using (userid,name) set a.age = b.age"