mapping文件中:
<insert id="saveUser" parameterType="List">
insert into user (`name`,age,unit_price) values
<foreach collection="users" item="l" index="index" separator=",">
(#{l.name},#{l.age},#{l.unitPrice})
</foreach>
ON DUPLICATE KEY UPDATE
age=values(age),unit_price=values(unit_price)
</insert>
dao:
int saveUser(@Param("users")List<User> users);
service中:
public Object saveUser(List<User> users) {
int a = companyConfigMapper.saveUser(users);
return JsonUtil.toJsonByFastjson(true,a);
}