Hibernate: user is not mapped

最新推荐文章于 2021-05-04 07:34:18 发布

efine_dxq

最新推荐文章于 2021-05-04 07:34:18 发布

阅读量504

点赞数

分类专栏： spring+struts+hibernate 文章标签： Hibernate

本文链接：https://blog.csdn.net/efine_dxq/article/details/71512246

版权

spring+struts+hibernate 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

报错截取：

org.hibernate.hql.internal.ast.QuerySyntaxException: user is not mapped [from user where name=:name and password=:password]
    org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.java:96)
    org.hibernate.QueryException.wrapWithQueryString(QueryException.java:120)
    org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:234)
    org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
    org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:126)
    org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:88)
    org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:190)
    org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
    org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
    org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1800)

代码、配置段：

(1).applicationContext.xml

<!-- mappingResources用来列出全部映射文件 -->
		<property name="annotatedClasses">
			<list>
<!-- 				以下用来列出所有的PO类 -->
				<value>edu.qtech.myclouds.domain.User</value>
			</list>
		</property>
		<!-- 自动扫描注解方式配置的hibernate类文件 -->
<!-- 		<property name="packagesToScan"> -->
<!-- 			<list> -->
<!-- 				<value>edu.qtech.myclouds.domain.</value> -->
<!-- 			</list> -->
<!-- 		</property> -->

(2).User.java

@Entity
@Table(name="user")
public class User {
	private int id;
	private String name;
	private String email;
	private String password;
	@Id
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	public int getId() {
		return id;
	}
   ...
}

(3).UserDaoImpl

public User queryUser(String name,String password) {
		// TODO Auto-generated method stub
		String hql="from user where name=:name and password=:password";
		Query query=sessionFactory.getCurrentSession().createQuery(hql);
		query.setParameter("name", name);
		query.setParameter("password", password);
		List<User> list = query.list();
		if(list.size()>0){
			return list.get(0);
		}else{
			return null;
		}
	}

原因：

hql语句写错了。user应该写成User。因为hql操作的是类、实例、属性，而不再是 sql 语句的表名。