1 问题及解决
1.1 问题
调用接口时出现异常,根据日志信息显示为空指针异常,并且定位到出现空指针异常的代码为下列代码的最后一行return StringUtils.isNotEmpty(one.getPassword());
public boolean isHasPwd(Long userId){
QueryWrapper<SysUser> wrapper =Wrappers.<SysUser>query().select("password").eq("id",userId);
final SysUser one = this.getOne(wrapper);
return StringUtils.isNotEmpty(one.getPassword());
}
结合代码和空指针异常,不难推断出,当one为空时,当前现象可成立。
以下是发生空指针异常前的sql查询日志:
==> Preparing: SELECT password FROM sys_user WHERE deleted=0 AND (id = ?)
==> Parameters: 1(Long)
<== Columns: password
<== Row: null
<== Total: 1
通过sql打印的日志发现,total为1,就是说,是可以查出来一条数据的,那是否就意味着one对象不应该是null呢?还是实际验证一下吧,结果是one为null !!
看一下数据库,id为1的这条数据是存在的,只是password这个字段为null
如果password为空字符串呢:
看下结果(下图),one这个对象是存在的,password为空字符串;在这种情况下也是不会出现空指针异常的。
所以在这种只查询某个字段的时候,如果字段为null,查询的实体对象就会为null,这点一定要注意。
1.2 解决
为避免空指针异常,应先判断one对象是否为null,不为null时再判断password是否为空,即
public boolean isHasPwd(Long userId){
QueryWrapper<SysUser> wrapper =Wrappers.<SysUser>query().select("password").eq("id",userId);
final SysUser one = this.getOne(wrapper);
return ObjectUtils.isNotEmpty(one) && StringUtils.isNotEmpty(one.getPassword());
}
2 测试及结论
2.1 测试
如果查询的是多个字段,会是什么情况呢?接下来就查询两个字段测试一下,测试代码如下:
@Test
public void testAddUser() {
QueryWrapper<SysUser> wrapper = Wrappers.<SysUser>query().select("password", "salt").eq("id",1);
final SysUser one = sysUserService.getOne(wrapper);
System.out.println(one);
}
- 测试1 :password字段为空字符串,salt字段为null
日志:
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f422ecc] was not registered for synchronization because synchronization is not active
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@5c1348c6] will not be managed by Spring
==> Preparing: SELECT password,salt FROM sys_user WHERE deleted=0 AND (id = ?)
==> Parameters: 1(Integer)
<== Columns: password, salt
<== Row: , null
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f422ecc]
SysUser(id=null, userName=null, nickName=null, password=, salt=null, phone=null, email=null, sex=null, head=null, remark=null, state=null, stateName=null, lockState=null, lockTime=null, lockStateName=null, pwdLastUpdae=null, departmentId=null, roleId=null, deleted=null, version=null, createTime=null, updateTime=null)
可看出,此情况下,one对象是存在的,password为空字符串,salt字段为null
- 测试2 :password和salt字段都为null
日志:
Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5e8f1db2] was not registered for synchronization because synchronization is not active
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@1b48784a] will not be managed by Spring
==> Preparing: SELECT password,salt FROM sys_user WHERE deleted=0 AND (id = ?)
==> Parameters: 1(Integer)
<== Columns: password, salt
<== Row: null, null
<== Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5e8f1db2]
null
可看出,此情况下,one对象是不存在的
2.2 结论
查询特定字段时,如果查询的字段全部为null,则返回的对象是null。