spring+struts+hibernte 多个表的结构一样

[gyzh8310]

spring+struts+hibernte 多个表的结构一样，不可能为每个表再写xml文件对应的javabean。有没有什么好办法，可以每次把表名传入，并且可以像这样查询：
public NxtvUserInfo QueryNxtvUserInfo(String username,String userpassword,String userflag){
NxtvUserInfo user = null;
String hsql = " from NxtvUserInfo s where s.username='"+username+"' and s.userpassword='"+userpassword+"'" +
"and s.userflag='"+userflag+"'";
List list = this.getHibernateTemplate().find(hsql);
if(list != null && !list.isEmpty()){
user = (NxtvUserInfo) list.get(0);
}
return user;
}
而NxtvUserInfo.hbm.xml为
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<hibernate-mapping>
<!--
Created by the Middlegen Hibernate plugin 2.1

http://boss.bekk.no/boss/middlegen/
http://www.hibernate.org/
-->

<class
name="com.nl.nxtv.dt.NxtvUserInfo"
table="NxtvUserInfo"
>

<id
name="id"
type="java.lang.Integer"
column="ID"
>
<generator class="assigned" />
</id>

<property
name="username"
type="java.lang.String"
column="USERNAME"
not-null="true"
length="30"
/>
<property
name="userpassword"
type="java.lang.String"
column="USERPASSWORD"
not-null="true"
length="30"
/>
<property
name="userflag"
type="java.lang.String"
column="USERFLAG"
not-null="true"
length="2"
/>

</class>
</hibernate-mapping>

[matrix1984]

既然用hibernate的东东，需要O/R对应，O应该都是必须的吧。
你说表结构一样？那干吗建那么多表呢？
如果真是这样，那也不麻烦：
查询时传递表名，根据表名通过spring来取的实体XXXInfo对象。

    public Object QueryInfo(String,username,String userpassword,String userflag,String tableName){ 
        //Object user = ApplicationContext.getBean(tableName);
        Object user = null;
        String hsql = " from "+tableName+"s where s.username='"+username+"' and s.userpassword='"+userpassword+"'" + 
                "and s.userflag='"+userflag+"'"; 
        List list = this.getHibernateTemplate().find(hsql); 
        if(list != null && !list.isEmpty()){ 
            user = list.get(0); 
        } 
        return user; 
    } 

然后，取得user对象根据实际情况转化一下，不知道说的对不对。

[liukang4098]

up

[gyzh8310]

up

[gyzh8310]

刚才写了一个：
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)

看来还是要映射，难道没有其他的办法了么，那个高手可以解决一下哈。

[gyzh8310]

up

[mellow_msb]

Up

[gyzh8310]

up

[jianpc]

多个表的结构一样为什么不能做成一个表来维护呢？