两天之间的休眠标准 [英] Hibernate criteria between two days

问题描述

我正在尝试获取两个日期之间的行数. 第一个日期是今天，第二个日期是15天之前.

I'm trying to get number of rows between two dates. First date is today, second one is 15 days ago.

Criteria criteria = session.createCriteria(Order.class);
            Calendar c15DaysAgo = Calendar.getInstance(); // 15 days ago
            c15DaysAgo.add(Calendar.DAY_OF_YEAR, -15);

            Calendar today = Calendar.getInstance(); // today
            today.add(Calendar.DAY_OF_YEAR, 0);

            criteria.add(Expression.between("orderTime", today, c15DaysAgo));
            totalCount = (Integer) criteria.setProjection(Projections.rowCount()).uniqueResult();

我遇到此异常:

java.lang.ClassCastException: java.util.GregorianCalendar cannot be cast to java.util.Date
    at org.hibernate.type.TimestampType.toString(TimestampType.java:55)
    at org.hibernate.type.NullableType.nullSafeToString(NullableType.java:93)
    at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:140)
    at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:116)
    at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1707)
    at org.hibernate.loader.Loader.bindParameterValues(Loader.java:1678)
    at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1563)
    at org.hibernate.loader.Loader.doQuery(Loader.java:673)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
    at org.hibernate.loader.Loader.doList(Loader.java:2220)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
    at org.hibernate.loader.Loader.list(Loader.java:2099)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569)
    at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
    at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)

有什么方法可以计数吗?

Is there some way I can do count?

推荐答案

您需要today.getTime().休眠状态需要日期，而不是日历...

You need today.getTime(). Hibernate wants a Date, not a Calendar...

这篇关于两天之间的休眠标准的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！