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);
}
终于解决了问题。