关于Hql语句，这条语句为什么查不出数据

Question

hql = "from A a where a.timeDate <= "+time+" and a.name not in (select b.name from B b)";
super.findTopByHql(hql, 20);
这条语句有没有问题啊，为什么查不到数据

Answer 1

检查下日期有没有引号，是否合法

最好是使用参数
hql = "from A a where a.timeDate <= :time and a.name not in (select b.name from B b)";
String[] params = { "time" };
Object[] args = { time };
,,,