|
楼主 |
发表于 2013-11-15 09:56:56
|
显示全部楼层
问题解决了。是我ACTION中写的语句逻辑不对,按下面的写就没问题了。
if(!"".equals(KSSJ)&&!"".equals(JSSJ)&&!(KSSJ==null)&&!(JSSJ==null)){
// System.out.println(">>>>>>>>>"+KSSJ+"??????????"+JSSJ);
oracle += " and HTQDRQ between to_date('"+KSSJ+"','YYYY-MM-DD') and to_date('"+JSSJ+"','YYYY-MM-DD')";
}
else{
// System.out.println(">>>>>>>>>"+KSSJ+"!!!!!!!!!"+JSSJ);
//oracle += " and HTQDRQ between to_date('2012-01-01','YYYY-MM-DD') and to_date('2013-12-26','YYYY-MM-DD')";
}
if(!"".equals(HTBH)&&!(HTBH==null)){
oracle += " and HTBH like '%"+HTBH+"%'";
}
这段代码同时实现了按照日期查询和按照HTBH查询两种功能。 |
|