/** 分页查询所有的管理员 */ public PageModel<AdminUserInfo> queryAll(int pageNo) { String sql = "SELECT adminuserinfo.*,NAME as areaName FROM adminuserinfo JOIN provincialinfo ON adminuserinfo.areaId = provincialinfo.provincialID WHERE LEVEL= 1" + " UNION SELECT adminuserinfo.*,NAME FROM adminuserinfo JOIN cityinfo ON adminuserinfo.areaId = cityinfo.cityId WHERE LEVEL= 2" + " UNION SELECT adminuserinfo.*,NAME FROM adminuserinfo JOIN countyinfo ON adminuserinfo.areaId = countyinfo.countyID WHERE LEVEL= 3"; PageModel<AdminUserInfo> pm = new PageModel<AdminUserInfo>(); pm.setSumCount(querySumCount()); pm.setCurrentPage(pageNo); sql += " ORDER BY id DESC limit " + (pageNo - 1) * pm.getSize() + "," + pm.getSize(); List<AdminUserInfo> list = DBHelper.commQuery(sql, AdminUserInfo.class); pm.setData(list); return pm; }
/** * 返回用户列表 * * @param pageNo 页数 * @param name 查询关键字 * @return */ public PageModel<Userinfo> getUserInfoList(int pageNo, String keyword) { PageModel<Userinfo> pm = new PageModel<Userinfo>(); pm.setSumCount(getCountyCount(keyword)); pm.setCurrentPage(pageNo); String sql = "select * from userinfo where username like ?"; // 默认表示全国 sql += " order by checkin desc"; sql += " limit " + ((pageNo - 1) * pm.getSize() + "," + pm.getSize()); List<Userinfo> list = DBHelper.commQuery(sql, Userinfo.class, keyword); pm.setData(list); return pm; }