public Pagination getLookPage(BeanPatrolScheduling beanPatrolScheduling, int pageNo, int pageSize) { SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd"); Pagination pagination = new Pagination(); StringBuffer sql = new StringBuffer(); sql.append(" select "); sql.append(" ps.id,ju.username,ps.patrol_times,ps.patrol_month, ps.result,ps.parkid"); sql.append(" from patrol_scheduling ps, "); sql.append(" company_emp ce, "); sql.append(" jc_user ju "); sql.append(" where ps.emp_id=ce.id "); sql.append(" and ce.id=ju.user_id "); sql.append(" and ps.data_status=0"); if(beanPatrolScheduling.getUserName()!= null && beanPatrolScheduling.getUserName()!= ""){ sql.append(" and ju.username like '%"+beanPatrolScheduling.getUserName()+"%'" ); } String sqls = sql.toString(); Query query = sessionFactory.getCurrentSession().createSQLQuery(sqls.toString()); List list = query.list(); List<BeanPatrolScheduling> result=new ArrayList<BeanPatrolScheduling>(); if(list!=null&&list.size()>0){ for (Object object : list) { int i = 0; BeanPatrolScheduling modell=new BeanPatrolScheduling(); Object[] temp = (Object[]) object; modell.setId(Integer.parseInt( temp[i++] +"")); modell.setUserName(String.valueOf( temp[i++])); modell.setPatrol_times(Integer.parseInt( temp[i++] +"")); try { modell.setPatrol_month(dateformat.parse( temp[i++] +"")); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } modell.setResult(Integer.parseInt( temp[i++] +"")); modell.setParkid(String.valueOf(temp[i++])); result.add(modell); } } pagination.setList(result); pagination.setPageNo(pageNo); pagination.setPageSize(pageSize); return pagination; }