构造器的顺序需要和hql中的顺序一致。否则会出现如下错误:
Exception in thread "main" org.hibernate.hql.ast.QuerySyntaxException: Unable to locate appropriate constructor on class [com.flyinsky.eagle.user.po.UserInforPO] [select new UserInforPO(carId,name) from com.flyinsky.eagle.user.po.UserInforPO where name = ? and password = ?]
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:225)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158)
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:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)
at com.flyinsky.eagle.user.dao.UserDAO.getAllUsers(UserDAO.java:263)
at com.flyinsky.eagle.user.test.TestHibernate.main(TestHibernate.java:69)
Caused by: Unable to locate appropriate constructor on class [com.flyinsky.eagle.user.po.UserInforPO]
[cause=org.hibernate.PropertyNotFoundException: no appropriate constructor in class: com.flyinsky.eagle.user.po.UserInforPO]
at org.hibernate.hql.ast.tree.ConstructorNode.resolveConstructor(ConstructorNode.java:122)
at org.hibernate.hql.ast.tree.ConstructorNode.prepare(ConstructorNode.java:88)
at org.hibernate.hql.ast.HqlSqlWalker.processConstructor(HqlSqlWalker.java:837)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExpr(HqlSqlBaseWalker.java:1952)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectExprList(HqlSqlBaseWalker.java:1821)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectClause(HqlSqlBaseWalker.java:1392)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:553)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218)
... 10 more
public class UserInforPO {
private int carId;
private String name;
private int age;
private String password;
private Date regDate;
private List<UserAddressPO> allAddress = new ArrayList<UserAddressPO>();
private String email;
public UserInforPO() {
}
public UserInforPO(String name,int carId) {
this.name = name;
this.carId = carId;
}
public UserInforPO(String name, int age, List address) {
this.name = name;
this.allAddress = address;
this.age = age;
}
public void getAllUsers(UserInforPO userPO){
String hql = "select new UserInforPO(carId,name) from UserInforPO " +
"where name = ? and password = ?";//安位置进行数值绑定
Session session = DBUtil.getSession();
Query query = session.createQuery(hql);
query.setParameter(0, userPO.getName());
query.setParameter(1, userPO.getPassword());
List list = query.list();
for(int i = 0; i < list.size(); i++){
UserInforPO user = (UserInforPO)list.get(i);
System.out.println(user.getCarId() + " " + user.getName());
}
将PO改为如下就可以了
public class UserInforPO {
private int carId;
private String name;
private int age;
private String password;
private Date regDate;
private List<UserAddressPO> allAddress = new ArrayList<UserAddressPO>();
private String email;
public UserInforPO() {
}
public UserInforPO(int carId,String name) {
this.name = name;
this.carId = carId;
}
分享到:
相关推荐
NULL 博文链接:https://yaofeng911.iteye.com/blog/1061070
Hibernate中po对象的三种状态分析[借鉴].pdf
hibernate中文API,hibernate中文参考手册,hibernate API
hibernate_中文乱码hibernate_中文乱码hibernate_中文乱码hibernate_中文乱码hibernate_中文乱码hibernate_中文乱码
hibernate中文文档hibernate中文文档hibernate中文文档hibernate中文文档hibernate中文文档
Hibernate 中文文档Hibernate 中文文档Hibernate 中文文档Hibernate 中文文档
hibernate中session的管理描述。 hibernate中session的管理描述。
Hibernate中Example的用法
注意:在Hibernate3中,第二个要求并非是Hibernate强制必须的。但最好这样做。 你不能使用一个IdentifierGenerator产生组合关键字。一个应用程序必须分配它自己的标识符。 使用<composite-id> 标签(并且内嵌元素...
hibernate中的generator的生成方式 hibernate中的generator的生成方式
Hibernate 中文手册 3.2.pdf
hibernate中英文API文档 hibernate中英文API文档 hibernate中英文API文档hibernate中英文API文档 hibernate中英文API文档
Hibernate中文Api最新参考文档
所有的持久化类(persistent classes)都要求有无参的构造器,因为Hibernate必须使用Java反射机制来为你创建对象。构造器(constructor)的访问级别可以是private,然而当生成运行时代理(runtime proxy)的时候则...
Hibernate开发者指南,包括HIBERNATE - Relational Persistence for Idiomatic Java.pdf,Hibernate Getting Started Guide.pdf,Hibernate Developer Guide.pdf,Hibernate 中文API文档.chm,Hibernate3.2.chm。
Hibernate中Criteria的完整用法
hibernate orm框架api中文文档,学习资料,框架详解资料。
Hibernate框架中文帮助文档 CHM格式