为什么此查询不返回任何值。我的数据库中有该范围内的值
值输入为
Date startDate = (Date) data.get("startDate");//2014-04-01
Date endDate = (Date) data.get("endDate");//2014-04-30
int pagesize=10;
sql查询是
String query = "select * from bill_details "
+ " where status=? "
+ " AND date(add_date) BETWEEN " + startDate + " AND " + endDate
+ " order by add_date desc limit " + pagesize;
ps = con.prepareStatement(query);
ps.setString(1, dataStatus);
System.out.println("Before execution");
res = ps.executeQuery();
试试这个:
Date startDate = (Date) data.get("startDate");//2014-04-01
Date endDate = (Date) data.get("endDate");//2014-04-30
int pagesize=10;
String query = "select * from bill_details "
+ " where status=? "
+ " AND date(add_date) BETWEEN ? AND ?"
+ " order by add_date desc limit ?";
ps = con.prepareStatement(query);
ps.setString(1, dataStatus);
ps.setDate(2, startDate);
ps.setDate(3, endDate);
ps.setInt(4, pagesize);
System.out.println("Before execution");
res = ps.executeQuery();
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句