String hql = "from com.dc.portal.common.entity.FpKc c where kfhm=? and kprid=? and kczt='1' and nsrsbh=? and fs>(select count(1) from FpKp k where k.fpdm=c.fpDm and k.fphm>= c.fpqh and k.fphm<= c.fpzh)";
Query query = session.createQuery(hql);
query.setInteger(0, kfhm);
query.setString(1, kprid);
query.setString(2, nsrsbh);
return query.list();
语句有什么错误呢!
Query query = session.createQuery(hql);
query.setInteger(0, kfhm);
query.setString(1, kprid);
query.setString(2, nsrsbh);
return query.list();
语句有什么错误呢!
SQL语句有问题?没有SELECT FROM ?
2.你去了别名,但是where kfhm=? and kprid=? and kczt='1' 这几个都没有用别名。