表名 is not mapped
「已注销」 2016-06-25 07:11:37 11在数据库里面执行:
代码如下:
select r.PermissionID from role_permission r where r.RoleID in(select us.RoleID from user_role us where exists(select u.User ID from user u where u.UserID=us.UserID and u.UserName="古贝子" and u.UserPwd="123456"));
运行结果如下:
| PermissionID |
+--------------+
| 1 |
| 2 |
| 3 |
| 4 |
+--------------+
4 rows in set
2\在项目中的代码如下:
BookDao类:
String hql ="select r.PermissionID from role_permission r where r.RoleID in(select us.RoleID from user_role us where exists(select u.UserID from user u where u.UserID=us.UserID and u.UserName='"+uname+"' and u.UserPwd='"+pwd+"'))";
List list = super.list(hql);
HibernateDao子类:
protected List list(String hql){
List list = new ArrayList();//返回值
try{
list=super.getHibernateTemplate().find(hql);
}catch(Exception e){
e.printStackTrace();
}
return list;
}
项目中运行出错信息:
role_permission is not mapped
问题:在数据库里面可以查询出数据,但是把语句放到项目就报表不能映射(实体类和映射文件都市自动生成的)。