from XXX as x where x.date between ? and ?;
然后再填参数
setDate(0,xxxx)
setDate(1,xxxx) //xxxx为 util.Date()类型
放心,Hibernate很智能~
public List
StringBuffer hql = new StringBuffer();
hql.append("FROM CustomerItem po ");
List value = new ArrayList();
if (dateFrom != null && dateTo != null) {
hql.append(" WHERE po.creationDate BETWEEN ? AND ? ");
value.add(dateFrom);
value.add(dateTo);
}
int parLen = value.size();
if (parLen <= 0)="" {="" return="" null;="" }="" object[]="" conditions="new" object[parlen];="" value.toarray(conditions);="" return="" find(hql.tostring(),="" conditions);="">=>
楼主,说实话哈 日期居然用varchar类型,后期操作来回转换多麻烦啊,api里的方法还不能直接用。。。为什么不用datetime呢,直接映射timestamp类,可以直接存储,操作也方便totimestamp方法就可以变成string,还能作比较...