配置
<update id="updateStudentById" parameterClass="Student">
update Student
set
sname=#sname#,
ssex=#ssex#,
sphone=#sphone#,
sclass=#sclass#,
sdate=#sdate#
where studentid=#studentid#
</update>
实现
@Override
public boolean updateStudentById(Student student) {
boolean flag = false;
Object object = false;
try {
object = sqlMapClient.update("updateStudentById", student);
System.out.println("更新学生信息的返回值:" + object + ",返回影响的行数");
} catch (SQLException e) {
e.printStackTrace();
}
if (object != null) {
flag = true;
}
return flag;
}
测试
IStudentDAO dao = new IStudentDAOImpl();
System.out.println("\n3.测试updateUser(User user)");
Student user2 = new Student();
user2.setStudentid(5);
user2.setSname("55");
user2.setSphone("55");
user2.setSsex("55");
user2.setSclass("55");
user2.setSdate(Date.valueOf("1991-5-3"));
dao.updateStudentById(user2);