| | |
| | | //5.1查询所有员工信息(包含1002) |
| | | public PageInfo<User_inf> searchUserPage(PageInfo page) { |
| | | String numberSql = "SELECT FOUND_ROWS() number"; |
| | | String sql = "select SQL_CALC_FOUND_ROWS distinct(tb_user_inf.uid),uName " + |
| | | " from db_user.tb_user_inf " + |
| | | String sql = "select SQL_CALC_FOUND_ROWS distinct(inf.uid),uName,login_type,face.id as faceId,face.url as faceUrl " + |
| | | " from db_user.tb_user_inf inf" + |
| | | " left join db_user.tb_user_face face on inf.face_id=face.id " + |
| | | " order by uid limit ?,?"; |
| | | Connection conn = DBUtil.getConn(); |
| | | List list = DAOHelper |
| | |
| | | User_inf userinf = new User_inf(); |
| | | userinf.setUId(rs.getInt("uId")); |
| | | userinf.setUName(rs.getString("uName")); |
| | | userinf.setLoginType(rs.getInt("login_type")); |
| | | |
| | | Face face = new Face(); |
| | | |
| | | face.setId(rs.getInt("faceId")); |
| | | face.setUrl(rs.getString("faceUrl")); |
| | | userinf.setFace(face); |
| | | |
| | | list.add(userinf); |
| | | } |
| | | } catch (SQLException e) { |