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 List<User> userList;


public UserInput() {
super();
// TODO Auto-generated constructor stub
}

sql语句

<update id="updateUsers" parameterType="com.koopoo.liuguosheng.model.vo.input.UserInput">
        update t_user set
        uname =
        <foreach collection="userList" item="item" index="index"
                 separator=" " open="case uid" close="end">
            <if test="item.uname != null and item.uname != '' ">
    &nbs