首页 > Web开发 > 详细

hibernate查询返回一个list ,Date类型追加数据

时间:2016-12-05 14:47:46      阅读:211      评论:0      收藏:0      [点我收藏+]
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;
    }

 

hibernate查询返回一个list ,Date类型追加数据

原文:http://www.cnblogs.com/xinxin1994/p/6133539.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!