示例【更新学生信息】
配置StudentMapper.xml
<update id="updateStudent" parameterType="com.po.Student">
update t_student
<set>
<if test="sname!=null">
sname=#{sname},
</if>
<if test="sex!=null">
sex=#{sex},
</if>
<if test="classes!=null">
classes=#{classes},
</if>
<if test="address!=null">
address=#{address},
</if>
</set>
where sid=#{sid}
</update>
创建StudentDao
@Test
public void updateStudent(){
Student stu=new Student();
stu.setSid(1);
stu.setClasses("大三");
int row=session.update("com.mapper.StudentMapper.updateStudent", stu);
session.commit();
if(row>=0) {
System.out.println("成功更新了"+row+"条记录。");
}
}
执行updateStudent()方法