mysql - 在两个日期之间搜索的查询

Question

大家好，我有一个搜索查询，它应该显示设定日期范围内的所有结果

查询:

public List<Appointment> appointmentRangeSearch(Date startdatetime, Date endDate) {
    Query q = em.createQuery("SELECT u FROM Appointment U WHERE u.startDatetime BETWEEN : date1 AND : date2 ");
    q.setParameter("date1", startdatetime, TemporalType.TIMESTAMP);
    q.setParameter("date2", endDate, TemporalType.TIMESTAMP);
    return q.getResultList();
}

它返回错误:

Caused by: Exception [EclipseLink-0] (Eclipse Persistence Services - 2.5.0.v20130507-3faac2b): org.eclipse.persistence.exceptions.JPQLException
Exception Description: Syntax error parsing [SELECT u FROM Appointment U WHERE u.startDatetime BETWEEN : date1 AND : date2 ]. 
[34, 77] The expression is not a valid conditional expression.

表中的数据存储:

2013-12-15 00:00:00.0

我怎样才能完成这个搜索？

谢谢大家

Answer 1

从 : date1 中删除 : 和 date1 之间的空格。所以你的查询应该是这样的:

SELECT u FROM Appointment U WHERE u.startDatetime BETWEEN :date1 AND :date2