updateByPrimaryKeySelective 过滤不掉 where 中的null值

Question

使用tk.mybatis.mapper的updateByPrimaryKeySelective 进行update操作 只去掉了set的null值 where 后面的没有去掉

SystemUser upUser = new SystemUser();
upUser.setUserId(sysUser.getUserId());
upUser.setLastLoginIp(ip);
upUser.setLastLoginTime(nowTime);
userService.updateSystemUser(upUser);

public Integer updateSystemUser(SystemUser systemUser) {
   return systemUserMapperImpl.updateByPrimaryKeySelective(systemUser);
}

public interface SystemUserMapper extends MyMapper<SystemUser> {
}

import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

/**
 * 继承自己的MyMapper
 */
public interface MyMapper<T> extends Mapper<T>, MySqlMapper<T> {
}

 

UPDATE system_user  SET user_id = ?,last_login_time = ?,last_login_ip = ? WHERE  user_id = ? AND real_name = ? AND role_id = ? AND login_name = ? AND login_password = ? AND phone = ? AND create_time = ? AND modify_time = ? AND remark = ? AND last_login_time = ? AND wechat_id = ? AND last_login_ip = ? AND data_status = ? AND creater = ?

 

 

Answer 1

数据库表没有设置主键

Answer 2

是 xxx = null 无效？

比较null，要用  xxxx is null