Hibernate 发出这个异常HibernateQueryException: could not resolve property: 请教各位高手怎末办

Question

属性没有，where op.oplevel=22
大小写有没错？oplevel是什么类型？

Answer 1

检查一下oplevel是否跟com.dk.ykt.model.OperFunction 里的属性对应，

Answer 2

高手帮忙改下,急用!!!!谢谢public ArrayList getliststudent(String depname) {
ArrayList list=new ArrayList();
Session session = HibernateSessionFactory.getSession();
String hql="from Departments  d where d.depname='"+depname+"'";
List list1=session.createQuery(hql).list();
Departments depart=new Departments();
Iterator iter1=list1.iterator();
if(iter1.hasNext()){
depart=(Departments) iter1.next();
int id=depart.getDep_id();
String hql1="from Student stu where stu.dep_id='"+id+"'";
list= (ArrayList) session.createQuery(hql1).list();
      System.out.print(list.size());
}
return list;

}
注:dep_id是外键
报错:
org.hibernate.QueryException: could not resolve property: dep_id of: pojo.Student [from pojo.Student stu where stu.dep_id='1']
org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:44)
org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:38)
org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1358)
org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:279)
org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:386)
org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:566)
org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:241)
org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:188)
org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:94)
org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:90)
org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:728)
org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1216)
org.hibernate.hql.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4041)
org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3525)
org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1762)
org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776)
org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577)
org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
dao.AssignDao.getliststudent(AssignDao.java:28)
action.AssignAction.search(AssignAction.java:38)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
file.MYFileter.doFilter(MYFileter.java:25)