hibernate中PO的构造器顺序

最新推荐文章于 2021-02-24 01:30:34 发布

原创最新推荐文章于 2021-02-24 01:30:34 发布 · 236 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Hibernate #Java #DAO #thread

ぁ开发日志ぁ博客ぁ专栏收录该内容

12 篇文章

订阅专栏

本文介绍了一个关于Hibernate HQL查询中构造器顺序与类构造器参数顺序不匹配导致的异常问题，并提供了解决方案。

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