String birthday = date == null ? "" : sdf.format(date)

最新推荐文章于 2022-10-14 21:29:07 发布

一切为了个人信息化

最新推荐文章于 2022-10-14 21:29:07 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： Java 学习笔记文章标签： date string null email security class

本文链接：https://blog.youkuaiyun.com/gz_xiangjun/article/details/7258281

Java 学习笔记专栏收录该内容

33 篇文章

订阅专栏

本文介绍了一种从数据库中获取并处理用户信息的方法，通过解析查询结果集来填充用户信息对象，包括基本信息、部门信息及权限信息等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

private UserInfo getUserInfo(ResultSet rs) throws SQLException{
  String id = rs.getString("ID");
  String loginName = rs.getString("LOGIN_NAME");
  String realName = rs.getString("REAL_NAME");
  String password = rs.getString("PASSWORD");
  String gender = rs.getString("GENDER");
  String position = rs.getString("POSITION");
  Date date = rs.getDate("BIRTHDAY");
  SimpleDateFormat sdf = new SimpleDateFormat(PlatformConstants.DATE_FORMAT);
  String birthday = date == null ? "" : sdf.format(date);
  String email = rs.getString("EMAIL");
  String phone = rs.getString("PHONE");
  String note = rs.getString("NOTE");
  String departmentId = rs.getString("DEPT_ID");
  String departmentName = rs.getString("DEPT_NAME");
  String securityClassName = rs.getString("SECU_CLASS_NAME");

  UserInfo info = new UserInfo();
  info.id = StringUtil.filterNull(id);
  info.loginName = StringUtil.filterNull(loginName);
  info.realName = StringUtil.filterNull(realName);
  info.password = StringUtil.filterNull(password);
  info.gender = StringUtil.filterNull(gender);
  info.position = StringUtil.filterNull(position);
  info.birthday = StringUtil.filterNull(birthday);
  info.email = StringUtil.filterNull(email);
  info.phone = StringUtil.filterNull(phone);
  info.note = StringUtil.filterNull(note);
  info.departmentId = StringUtil.filterNull(departmentId);
  info.securityClass = rs.getInt("SECURITY_CLASS");
  if(rs.getInt("STATUS") != 2){
   if(isLock(info)){
    info.status = 3;
   }else info.status = rs.getInt("STATUS");
  }else{
   info.status = rs.getInt("STATUS");
  }
  info.departmentName = StringUtil.filterNull(departmentName);
  info.securityClassName = StringUtil.filterNull(securityClassName);
  info.roles = getRolesByUserId(id);
  info.groups = getGroupsByUserId(id);
  return info;
}