/** 根据用户名查找用户 */ @SuppressWarnings("unchecked") public List<User> searchUserByUserName(String userName) { Object[] params = null; String selectHql = null; selectHql = "from User as u where u.userName = '******'"; String countHql = "select count(*) " + selectHql; List<User> userList = PageService.searchByPage(selectHql, countHql, params, null, userDAO); return userList; }
/** 是否存在此用户,存在返回true,不存在返回false */ @SuppressWarnings("unchecked") public boolean isUserNameExist(String userName) { Object[] params = null; String selectHql = "from User as u where u.userName='******'"; // 创建获取HQL返回记录总行数语句 String countHql = "select count(*) " + selectHql; List<User> userList = PageService.searchByPage(selectHql, countHql, params, null, userDAO); if (userList.isEmpty()) { return false; } else return true; }
/** 用户登录验证 */ @SuppressWarnings("unchecked") public User login(String userName, String password) { Object[] params = null; String selectHql = "from User as u where u.userName='******' and u.password='******'"; // 创建获取HQL返回记录总行数语句 String countHql = "select count(*) " + selectHql; List<User> userList = PageService.searchByPage(selectHql, countHql, params, null, userDAO); if (userList.isEmpty()) { return null; } else return userList.get(0); }
/** 获取指定用户信息 */ @SuppressWarnings("unchecked") public List<User> getUser(PageBean page, String sort, String order) { Object[] params = null; String selectHql = null; selectHql = "from User"; if (sort != null && order != null) { selectHql = selectHql + " order by " + sort + " " + order; } String countHql = "select count(*) " + selectHql; List<User> list = PageService.searchByPage(selectHql, countHql, params, page, userDAO); return list; }
/** * 按条件查询和分页支持 * * <p>根据用户名执行模糊匹配查找,通过Page对象执行分页。 * * @userName:会员登录账号 * @page:分页对象 */ @SuppressWarnings("unchecked") public List<User> searchUser(String userName, PageBean page) { Object[] params = null; // 创建HQL查询语句 String selectHql = null; if ((userName == null) || (userName.equals(""))) { selectHql = "from User"; } else { selectHql = "from User where userName like '%" + userName + "%'"; } // 创建获取HQL返回记录总行数语句 String countHql = "select count(*) " + selectHql; // 执行按条件查询和分页支持 List<User> userList = PageService.searchByPage(selectHql, countHql, params, page, userDAO); return userList; }