java 怎么做批量修改_java批量修改

public class User {

private int uid;

private String uname;

private String age;

private String sex;

private String phone;

private Date creatTime;

public User() {

super();

}

public class UserInput {

private ListuserList;

public UserInput() {

super();

// TODO Auto-generated constructor stub

}

sql语句

update t_user set

uname =

separator=" " open="case uid" close="end">

when #{item.uid} then #{item.uname}

when #{item.uid} then t_user.uname

,age =

separator=" " open="case uid" close="end">

when #{item.uid} then #{item.age}

when #{item.uid} then t_user.age

,sex =

separator=" " open="case uid" close="end">

when #{item.uid} then #{item.sex}

when #{item.uid} then t_user.sex

,phone =

separator=" " open="case uid" close="end">

when #{item.uid} then #{item.phone}

when #{item.uid} then t_user.phone

where uid in

separator="," open="(" close=")">

#{item.uid}

dao里面

int updateUsers(UserInput userInput);

service里面

Dto updateUsers(UserInput userInput);

serviceImpl里面

@Override

public Dto updateUsers(UserInput userInput) {

Dto dto =new Dto();

userMapper.updateUsers(userInput);

return dto;

}

controller里面

@RequestMapping(value = "/updateUsers",method =RequestMethod.POST)

@ResponseBody

public Dto updateUsers(@RequestBody UserInput userInput)  {

return userService.updateUsers(userInput);

}

用的是postman测的

结果传参示例：

{

"userList":[

{

"uid":13,

"uname":"测试13",

"age":"24",

"sex":"2",

"phone":"12435435"

},

{

"uid":14,

"uname":"测试14",

"age":"24",

"sex":"2",

"phone":"12435435"

}

]

}

返回结果示例：

{

"code": 0,

"msg": "success"

}