jdbc条件中的时间参数

通常情况下把时间转换成字符串可以用来直接拼接的sql条件的,

else if (f0.getType().equals(Date.class)) {
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
if(!field0.equals(field1))sqlwhere.append(" and ( ").append(fs[i]).append(" between '").append(df.format((Date)field0)).append("' and '").append(df.format((Date)field1)+"')");
else sqlwhere.append(" and (DATEDIFF(DAY, ").append(fs[i]).append(" , ").append(field0+")=0 )");
}

 rxnyr between 2012-07-12 and 2014-02-21是查不出来的, rxnyr between '2012-07-12' and '2014-02-21'才是正解