刚才写了一个：
public List getSSXSList(String tname){
System.out.println("---getSSXSList is begin---");
String hsql = " from "+tname+" s where s.PHONE not in(select phone from cancelphone) order by TIME desc";
System.out.println("hsql = " + hsql);
List list = this.getHibernateTemplate().find(hsql);
System.out.println("---getSSXSList is end---" );
return list;
}
提示：
---getSSXSList is begin---
hsql = from JTGB_COMMENT s where s.PHONE not in(select phone from cancelphone) order by TIME desc
2008-8-8 10:01:17 com.nl.nxtv.action.NxtvPublicAction ssxs
严重: JTGB_COMMENT is not mapped [ from JTGB_COMMENT s where s.PHONE not in(select phone from cancelphone) order by TIME desc]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: JTGB_COMMENT is not mapped [ from JTGB_COMMENT s where s.PHONE not in(select phone from cancelphone) order by TIME desc]
org.springframework.orm.hibernate3.HibernateQueryException: JTGB_COMMENT is not mapped [ from JTGB_COMMENT s where s.PHONE not in(select phone from cancelphone) order by TIME desc]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: JTGB_COMMENT is not mapped [ from JTGB_COMMENT s where s.PHONE not in(select phone from cancelphone) order by TIME desc]
Caused by: org.hibernate.hql.ast.QuerySyntaxException: JTGB_COMMENT is not mapped [ from JTGB_COMMENT s where s.PHONE not in(select phone from cancelphone) order by TIME desc]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
看来还是要映射，难道没有其他的办法了么，那个高手可以解决一下哈。
