这是application
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver">
</property>
<property name="url"
value="jdbc:oracle:thin:@192.168.1.60:1521:ORCL">
</property>
<property name="username" value="user_jpolice"></property>
<property name="password" value="user_jpolice"></property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.Oracle9Dialect
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/po/TSysFilterword.hbm.xml</value></list>
</property></bean>
<bean id="TSysFilterwordDAO" class="com.dao.impl.TSysFilterwordDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
这是需要修改的
public class TSysFilterwordDAO implements ITSysFilterwordDAO{

private Session session=null;
private Transaction transaction=null;
public TSysFilterwordDAO(){
Configuration config=new Configuration().configure();
SessionFactory factory=config.buildSessionFactory();
this.session=factory.openSession();
}

//%%%%%%%%%%%%%%%%%%%%%%%%%%%%%表查询%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
public List<TSysFilterword> selectAll() throws SQLException{
Query query=session.createQuery("from TSysFilterword");
List<TSysFilterword> tables =new ArrayList<TSysFilterword>();
tables=query.list();  return tables;
}
sessionsshsessionfactory