UserMapper.xml
<update id="updateUserInfo" parameterType="cn.tedu.entity.User">
update emp
<set>
<if test="sal != 1250">
sal = #{sal},
</if>
<if test="sal != null">
comm = #{comm}
</if>
<if test="mgr != null">
mgr = #{mgr}
</if>
</set>
where empno=#{empno}
</update>
- set标签可以自动省略分隔符“,”
UserMapper
Integer updateUserInfo(User user);
TestCase.java
@Test
public void testUpdateUserInfo(){
UserMapper mapper = ctx.getBean("userMapper",UserMapper.class);
User user = new User();
user.setEmptno(10);
user.setSal((double) 8888);
user.setComm(8888);
Integer n = mapper.updateUserInfo(user);
System.out.println(n);
}