mybatis中mysql循环修改_mybatis多条件循环修改

//users.xml

UPDATE user

fullname=#{fullname},

age=#{age},

sex=#{sex},

address=#{address},

tel=#{tel},

WHERE email=#{email}

//DB层

public boolean ChangePersonInfo(String email, String fullname, int age, String sex, String adress, String tel) {

boolean b = false;

SqlSession session = sqlSessionFactory.openSession(); // 开启sqlsession

try {

System.out.println("hello123"+email);

users users12 = (users) session.selectOne("beans.usersMapper.selectUserByeamil", email);

System.out.println("hello"+users12.getEmail());

if (users12.getEmail().equals(email)) {   ///这里开始就是那个拼接更新的调用

users us1 = new users();

us1.setEmail(email);

us1.setFullname(fullname);

us1.setAge(age);

us1.setSex(sex);

us1.setAddress(adress);

us1.setTel(tel);

int c = session.update("beans.usersMapper.updatfn-age-sex-add-telbyemail", us1);

session.commit();

if (c == 1) {

b = true;

}

}

} catch (Exception ex) {

Logger.getLogger(LoginDB.class.getName()).log(Level.SEVERE, null, ex);

}

finally {

session.close(); // 关闭

}

return b;

}

这是我当时给user表写的update 根据传入的fallname age sex address tel是否为空 来进行set语句的拼接 可以借鉴一下 修改自己的