Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: unexpected token: class near line 1, column 29 [FROM lixin.study.po.ClassPO class , lixin.study.po.UserPO user where class.classNum=490701]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)
at lixin.study.dao.ClassDAO.queryByClassNum(ClassDAO.java:40)
at lixin.study.test.test.main(test.java:15)
这个是我的代码:
public void queryByClassNum(int classNum){
Session session =this.getSession();
String hql="FROM ClassPO class , UserPO user where class.classNum="+classNum;
Query query=session.createQuery(hql);
List<ClassPO> list=query.list();
ClassPO classPO=list.get(0);
Set<UserPO> set=classPO.getUserPOs();
Iterator iterator=set.iterator();
while(iterator.hasNext()){
System.out.println("you");
}
session.close();
}请问问题出在哪里 ? 是什么原因 , 我是初学hibernate的
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1651)
at lixin.study.dao.ClassDAO.queryByClassNum(ClassDAO.java:40)
at lixin.study.test.test.main(test.java:15)
这个是我的代码:
public void queryByClassNum(int classNum){
Session session =this.getSession();
String hql="FROM ClassPO class , UserPO user where class.classNum="+classNum;
Query query=session.createQuery(hql);
List<ClassPO> list=query.list();
ClassPO classPO=list.get(0);
Set<UserPO> set=classPO.getUserPOs();
Iterator iterator=set.iterator();
while(iterator.hasNext()){
System.out.println("you");
}
session.close();
}请问问题出在哪里 ? 是什么原因 , 我是初学hibernate的
解决方案 »
- 在用struct2开发时,提示如下错误怎样解决呀?(好像是web.xml中的过滤器问题)
- 有没有谁试过在 foreach 里使用jsp:include
- tiles框架 页面刷新问题 急急急急急急急急急急急急急急急急急急急急急急急急!!!!
- 急需解决一个Hibernate的HQL语句问题
- 求ACCESS连接代码
- Tomcat5+MySQL+JDBC的乱码问题
- 都有什么样的服务器支持jsp????????
- 如何去get方式传递的参数进行加密处理??在线等!急
- JSP开发和运行环境的配置问题!!!
- 关于 jBoss & tomcat的问题
- jdbc的一个问题
- jsp连接SQL数据库,在数据库显示的中文乱码问题
FROM ClassPO as c
下面用c 例如c.name ClassPO 是数据库的表名 c 相当于是缩写 name就是属性
String hql="FROM ClassPO as class where class.classNum="+classNum;
==-