<property name="warnDate" column="wlog_warn_date" type="java.util.Date" />
public ArrayList getByPeriod(Date beginDate, Date endDate, Integer pageNum, Integer prePageNum) {
try {SimpleDateFormat fmt = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
return (ArrayList) dao.findByHql("from Warnlog log where log.warnDate > to_date(?,'yyyy-MM-dd hh24:mi:ss') and log.warnDate < to_date(?,'yyyy-MM-dd hh24:mi:ss') order by log.id", new Object[]{fmt.format(beginDate),fmt.format(endDate)}, pageNum,prePageNum);
} catch (ServiceException e) {
e.printStackTrace();
}
return null;
}
日期类型的格式要匹配: 将date类型装换成yyyy-MM-dd hh24:mi:ss
new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
fmt.format(beginDate) string
to_date(?,'yyyy-MM-dd hh24:mi:ss') date