另外问个问题
HQL里是不是不能select *
而只能select 字段名
HQL里是不是不能select *
而只能select 字段名
解决方案 »
- js list 去掉重复的方法
- 帮忙写一个hql语句
- Hibernate+Spring事务处理?
- 请高手指点Java EE 开发平台的配置
- jquery+ajax+json+struts集成的小问题
- 关于Struts+spirng+hibernate,Tomcat启动报错:No property 'SessionFactory' found
- 急 resin3.x 下怎么配置Servlet
- 请教:jsp怎样调用web services??
- hibernate如何处理复合主键的表
- struts如何清空actionform中的数据呢??
- 要怎么在类中导入自己的写的接口啊,麻烦高手帮看一下
- 超郁闷的问题,关于oracle8i的clob字段
第二个不可能存在这个限制。
我的代码:
Query query = session.createQuery("select * from Student as s where s.id=44");
List list = query.list();
for (int i = 0; i < list.size(); i++)
{
Student stu=(Student)list.get(0);
System.out.println(stu.getStuname());
}
异常:
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: * near line 1, column 8 [select * from hibernatetest.Student as s where s.id=44]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:244) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:155) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:134) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:113) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1602) at hibernatetest.DelStudent.main(DelStudent.java:23)Caused by: line 1:8: unexpected token: * at org.hibernate.hql.antlr.HqlBaseParser.selectClause(HqlBaseParser.java:1330) at org.hibernate.hql.antlr.HqlBaseParser.selectFrom(HqlBaseParser.java:1106) at org.hibernate.hql.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:702) at org.hibernate.hql.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:296) at org.hibernate.hql.antlr.HqlBaseParser.statement(HqlBaseParser.java:159) at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:238) ... 9 more23:43:59,046 ERROR PARSER:33 - line 1:8: unexpected token: *
这样才可以,