根据起止日期拼接hql,进行查询

来源：互联网发布：精准扶贫大数据平台编辑：程序博客网时间：2024/05/16 16:00

controller.java

int total = acrossDeptApplyService.findTotal();

       int startDate =0;
       int endDate =0;
       SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
       if (start!=null&&start.trim().length()>0){
           //startDate=DateUtil.getOnlyDate(start);
           //startDate = Integer.parseInt(sdf.format(start));
           startDate=Integer.parseInt(sdf.format(DateFormat.getDateInstance().parse(start)));
       }
       if (end!=null&&end.trim().length()>0){
           //endDate =DateUtil.getOnlyDate(end);
           //endDate = Integer.parseInt(sdf.format(end));
           endDate=Integer.parseInt(sdf.format(DateFormat.getDateInstance().parse(end)));

}

DaoImpl.java

if (startDate!=0){
           buffer.append("and to_number(to_char(applyTime,'yyyyMMdd')) >= ?");
           params.add(startDate);
       }
       if (endDate!=0){
           buffer.append("and to_number(to_char(applyTime,'yyyyMMdd')) <= ?");
           params.add(endDate);
       }

终于解决了问题。

0 0