Hibernate Hql 查询出现 USER is not mapped [FROM USER WHERE

最新推荐文章于 2018-03-31 20:34:42 发布

sourny

最新推荐文章于 2018-03-31 20:34:42 发布

阅读量8.9k

点赞数 8

分类专栏： hibernate 文章标签： hibernate

本文链接：https://blog.youkuaiyun.com/sourny/article/details/45671309

版权

hibernate 专栏收录该内容

1 篇文章

订阅专栏

本文解决了一个在数据库查询中遇到的错误问题，该错误源于未正确映射实体类名。通过将实体类名更正为正确的类名，问题得以解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

页面错误部分：

HTTP ERROR 500

Problem accessing /struts/helloWorld. Reason:

    USER is not mapped [FROM USER WHERE GRADE='admin' AND NAME='admin' AND PASSWORD='admin']
Caused by:

org.hibernate.hql.ast.QuerySyntaxException: USER is not mapped [FROM USER WHERE GRADE='admin' AND NAME='admin' AND PASSWORD='admin']
	at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
	at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
	at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
	at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:255)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
	at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
	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:228)
	at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
	at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
	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:1623)
	at com.young.dao.BaseDao.query(BaseDao.java:23)
	at com.young.dao.impl.UserDaoImpl.isValidAdmin(UserDaoImpl.java:26)
	at com.young.action.HelloWorldAction.helloWorld(HelloWorldAction.java:32)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)

String hql = "FROM USER WHERE GRADE='admin' AND NAME='"+username+"' AND PASSWORD='"+password+"'";

这里写的USER不能是数据库的表明要是实体文件的名称也就是 model包下的 User.java 的User

String hql = "FROM User WHERE GRADE='admin' AND NAME='"+username+"' AND PASSWORD='"+password+"'";

就没有问题了