public List<RsUserLimitManagement> findByGrade(Long limitManagementId) {
try{
String queryString = "select l.limitManagementId, l.limitRole, l.limitGrade from RsUserLimitManagement as l where limitGrade > (select f.limitGrade from RsUserLimitManagement as f where f.limitManagementId = ?)";
Query queryObject = getSession().createQuery(queryString);
queryObject.setParameter(0, limitManagementId);
return queryObject.list();
}catch (Exception e) {
e.printStackTrace();
return null;
}RsUserLimitManagement 这是类名
public class RsUserLimitManagement implements java.io.Serializable {
// Fields
private Long limitManagementId;
private String limitRole;
private Long limitGrade;}
org.hibernate.hql.ast.QuerySyntaxException:unexpected token: RsUserLimitManagement near line 1, column 143 [select l.limitManagementId, l.limitRole, l.limitGrade from com.rs.bean.RsUserLimitManagement as l where limitGrade > (select f.limitGradefrom RsUserLimitManagement as f where f.limitManagementId = ?)]
请问我这语句该怎样修改?
try{
String queryString = "select l.limitManagementId, l.limitRole, l.limitGrade from RsUserLimitManagement as l where limitGrade > (select f.limitGrade from RsUserLimitManagement as f where f.limitManagementId = ?)";
Query queryObject = getSession().createQuery(queryString);
queryObject.setParameter(0, limitManagementId);
return queryObject.list();
}catch (Exception e) {
e.printStackTrace();
return null;
}RsUserLimitManagement 这是类名
public class RsUserLimitManagement implements java.io.Serializable {
// Fields
private Long limitManagementId;
private String limitRole;
private Long limitGrade;}
org.hibernate.hql.ast.QuerySyntaxException:unexpected token: RsUserLimitManagement near line 1, column 143 [select l.limitManagementId, l.limitRole, l.limitGrade from com.rs.bean.RsUserLimitManagement as l where limitGrade > (select f.limitGradefrom RsUserLimitManagement as f where f.limitManagementId = ?)]
请问我这语句该怎样修改?
from RsUserLimitManagement as l ,RsUserLimitManagement as f
where l.limitGrade > (select limitGrade from f where limitManagementId = ?)";