项目经验：oracle 日期查询 to_char()

/**

      * 查询对应evModel的测站水质评价历史数据

      */

     public List<ZxDDbsszzpjjg> getDbspjjgHistory(EvModel evModel){

           List<ZxDDbsszzpjjg> dbsszzpjjglist = new ArrayList<ZxDDbsszzpjjg>();

           String params[] = evModel.getStcdSeq().split("\\s*[,]\\s*" );// 参数之间可能存在空格

           String  hql=  "  from  ZxDDbsszzpjjg  where to_char(id.pjsj,'yyyy-mm-dd')=to_char(?,'yyyy-mm-dd') and id.pjsd=? and id.jclb=? and id.stcd in (:strs)";

           Session session = template.getSessionFactory().getCurrentSession();

           Query  query  =  session.createQuery(hql);

           query.setTimestamp(0, evModel.getStarttime());

           query.setLong(1, evModel.getPjsd());

           query.setString(2, evModel.getJclb());

           query.setParameterList( "strs", params);

           dbsszzpjjglist = query.list();

           

           List<ZxDXmpjjg> xmpjjglist = new ArrayList<ZxDXmpjjg>();

           String  hql1=  "  from  ZxDXmpjjg  where to_char(id.pjsj,'yyyy-mm-dd')=to_char(?,'yyyy-mm-dd') and id.pjsd=? and id.jclb=? and id.stcd in (:strs)";

           Session session1 = template.getSessionFactory().getCurrentSession();

           Query  query1  =  session1.createQuery(hql1);

           query1.setTimestamp(0, evModel.getStarttime());

           query1.setLong(1, evModel.getPjsd());

           query1.setString(2, evModel.getJclb());

           query1.setParameterList( "strs", params);

           xmpjjglist =  query1.list();

           

            for(ZxDDbsszzpjjg dbsszzpjjg:dbsszzpjjglist){

                List<ZxDXmpjjg> list = new ArrayList<ZxDXmpjjg>();

                 for(ZxDXmpjjg xmpjjg:xmpjjglist){

                     ZxDSzjczjbxx zxDSzjczjbxx = new ZxDSzjczjbxx();

                     ZxDXmjbxx zxDXmjbxx = new ZxDXmjbxx();

                      if(xmpjjg.getId().getStcd().equals(dbsszzpjjg.getId().getStcd())){

                           list.add(xmpjjg);

                           xmpjjg.setZxDSzjczjbxx(zxDSzjczjbxx);

                           xmpjjg.setZxDXmjbxx(zxDXmjbxx);

                     }

                }

                dbsszzpjjg.setXmpjjgList(list);

           }

            return dbsszzpjjglist;

     }