PublicPagination Getlookpage (beanpatrolscheduling beanpatrolscheduling,intPageNo,intpageSize) { SimpleDateFormat dateformat = new SimpleDateFormat ("Yyyy-mm-dd"); pagination Pagination=Newpagination (); StringBuffer SQL=NewStringBuffer (); 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=NewArraylist<beanpatrolscheduling>(); if(list!=NULL&&list.size () >0){ for(Object object:list) {inti = 0; Beanpatrolscheduling Modell=Newbeanpatrolscheduling (); 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 blockE.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); returnpagination; }
Hibernate query returns a list, date type append data