equipment is not mapped 哈哈

HQL大小写敏感问题

最新推荐文章于 2024-07-22 14:52:57 发布

最新推荐文章于 2024-07-22 14:52:57 发布 · 432 阅读

文章标签：

#SQL

SSH 专栏收录该内容

12 篇文章

订阅专栏

本文探讨了在使用Hibernate查询语言(HQL)时遇到的大小写敏感问题，具体表现为查询所有记录时因类名大小写不一致导致的错误。通过对比两段几乎相同的代码，突出了Java类名在HQL查询中正确书写的重要性。

	public List allEquipment() {
		Session session = MySessionFactory.getSession();
		List list= new ArrayList();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			String HQL = "select a from equipment as a order by a.id";
			Query query = session.createQuery(HQL);
			list = query.list();
			ts.commit();
		} catch (Exception e) {
			ts.rollback();
			System.out.println("查询所有，系统出现错误，原因为：");
			e.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}
		return list;
	}

上面这个和下面这个有什么不同呢？不过上面这个就是不能运行报这个错误：equipment is not mapped

	public List allEquipment() {
		Session session = MySessionFactory.getSession();
		List list = new ArrayList();
		Transaction ts = null;
		try {
			ts = session.beginTransaction();
			String HQL = "select a from Equipment as a order by a.id";
			Query query = session.createQuery(HQL);
			list = query.list();
			ts.commit();
		} catch (Exception e) {
			ts.rollback();
			System.out.println("查询所有，系统出现错误，原因为：");
			e.printStackTrace();
		}finally{
			MySessionFactory.closeSession();
		}
		return list;
	}

注意sql 语句

上面：String HQL = "select a from equipment as a order by a.id";
下面：String HQL = "select a from Equipment as a order by a.id";
这个家伙大小写不行啊。。。