mysql - 如何比较HQL中的时间戳字段？

Question

我的表中有一个 Java.Util.Timestamp 列，但无法与 WHERE 子句中的变量进行比较。使用此代码:

        // Using Calendar to convert Java Date 'horarioEliminar' to Sql Timestamp 't'
        Calendar cal = Calendar.getInstance();
        cal.setTime(horarioEliminar);
        cal.set(Calendar.MILLISECOND, 0);

        Timestamp t = new java.sql.Timestamp(cal.getTimeInMillis());

        String horQ = "FROM Academia.Horarios WHERE horario ="+ t;
        horario = (Horarios) session.createQuery(horQ).uniqueResult();

我遇到了异常:

ERROR [http-nio-8080-exec-873] org.hibernate.hql.internal.ast.ErrorCounter.reportError line 1:57: unexpected token: 10

但我检查了 System.out.println(t) 结果与存储在 horario 列中的值匹配。如何正确比较这两个时间戳？

Answer 1

尝试将时间戳设置为查询参数，如下所示:

 Timestamp t = new java.sql.Timestamp(cal.getTimeInMillis());

 String horQ = "FROM Academia.Horarios WHERE horario = :ts";
 horario = (Horarios) session.createQuery(horQ).setParameter("ts", t).uniqueResult();