Mybatis更新时候只更新变更部分的方法

在更新数据库的某条记录的时候，通过我们只需要更新我们设置的字段就可以了，但是如果基于ORM映射更新，当参数传入的为一个Bean的时候，这个时候会将Bean的全部字段都更新一次。有一个场景的如在登陆时候，如果用户登陆成功以后只想更新用户登陆的ip跟时间，对于这一类场景可以用mybatis的SqlProvider方法来只更新我们设置的字段，具体可以参考以下代码。

Dao:

package org.**.dao;

import java.sql.Timestamp;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.UpdateProvider;
import org.**.beans.User;
import org.**.sql.provider.UserSqlProvider;
import org.springframework.stereotype.Repository;

@Repository("userDao")
public interface UserDao {
    /**
     * login method
     * @param username
     * @param password
     * @return
     */
    @Select("select * from j_user where username=#{username} and password=#{password}")
    @Results({
        @Result(id=true, property="userId", column="user_id", javaType=Integer.class),
        @Result(property="username", column="username", javaType=String.class),
        @Result(property="password", column="password", javaType=String.class),
        @Result(property="email", column="email", javaType=String.class),
        @Result(property="registerTime", column="register_time", javaType=Timestamp.class),
        @Result(property="registerIp", column="register_ip", javaType=String.class),
        @Result(property="lastLoginTime", column="last_login_time", javaType=Timestamp.class),
        @Result(property="lastLoginIp", column="last_login_ip", javaType=String.class),
        @Result(property="loginCount", column="login_count", javaType=Integer.class),
        @Result(property="errorTime", column="error_time", javaType=Timestamp.class),
        @Result(property="errorCount", column="error_count", javaType=Integer.class),
        @Result(property="errorIp", column="error_ip", javaType=String.class)
    })
    public User getUserByUsernameAndPassword(@Param("username") String username, @Param("password") String password);
    
    @UpdateProvider(type = UserSqlProvider.class, method = "update")
    public int updateLoginInfo(User user);
}

SqlProvider:

package org.**.sql.provider;

import org.apache.commons.lang3.StringUtils;
import org.apache.ibatis.jdbc.SQL;
import org.**.beans.User;


public class UserSqlProvider {
	
	public String update(final User user) {
		return new SQL(){
			{
				UPDATE("jo_user");
				
				if (StringUtils.isNotBlank(user.getUsername())) {
					SET("username = #{username}");
				}
				
				if (StringUtils.isNotBlank(user.getEmail())) {
					SET("email = #{email}");
				}
				
				if (StringUtils.isNotBlank(user.getPassword())) {
					SET("password = #{password}");
				}
				
				if (user.getRegisterTime() != null) {
					SET("register_time = #{registerTime}");
				}
				
				if (StringUtils.isNotBlank(user.getRegisterIp())) {
					SET("register_ip = #{registerIp}");
				}
				
				if (user.getLastLoginTime() != null ) {
					SET("last_login_time = #{lastLoginTime}");
				}
				
				if (StringUtils.isNotBlank(user.getLastLoginIp())) {
					SET("last_login_ip = #{lastLoginIp}");
				}
				
				if (StringUtils.isNotBlank(user.getLoginCount().toString())) {
					SET("login_count = #{loginCount}");
				}
				
				if (StringUtils.isNotBlank(user.getResetKey())) {
					SET("reset_key = #{resetKey}");
				}
				
				if (StringUtils.isNotBlank(user.getResetPwd())) {
					SET("reset_pwd = #{resetPwd}");
				}
				
				if (user.getErrorTime() != null) {
					SET("error_time = #{errorTime}");
				}
				
				if (StringUtils.isNotBlank(user.getErrorCount().toString())) {
					SET("error_count = #{errorCount}");
				}
				
				if (StringUtils.isNotBlank(user.getErrorIp())) {
					SET("error_ip = #{errorIp}");
				}
				
				if (StringUtils.isNotBlank(user.getActivationCode())) {
					SET("activation_code = #{activationCode}");
				}
				
				WHERE("user_id = #{userId}");
			}
		}.toString();
	}

}