hibernate中PO的构造器顺序

构造器的顺序需要和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;
	}