pgsql -- 批量插入

工具：mybatis+pgsql

详见pgsql官方文档

案例1 – Set集合

dao层

void insert(Set<User> userSet);

sql

<insert id = "insert" parameterType = "java.util.Set">
	insert into user(username,address,sex,create_date)
	values
	<foreach collection="collection" separator="," item="val">
	(#{val.username}, #{val.address},#{val.sex},now())
	</foreach>
</insert>

案例2 – List集合

dao层

void insert(List<User> userList);

sql

<insert id = "insert" parameterType="java.util.List">
	insert into user(username,address,sex,create_date)
	values
	<foreach collection="list" separator="," item="