67,515
社区成员
发帖
与我相关
我的任务
分享
public Connection getConnection()
{
Connection conn=this.getSession().connection();
return conn;
}
<bean id="DataSourceDAO"
class="net.segns.dataSource.DataSourceImp" >
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
public static void main(String[] args) {
int c=0;
try {
Connection conn=getCon();
PreparedStatement ps=conn.prepareStatement("select * from sys_area order by areaid");
ResultSet rs=ps.executeQuery();
while( rs.next())
c++;
} catch (Exception e) {
System.out.println("有:"+c);
e.printStackTrace();
}
}
有:1068
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.validateClosedState(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateClosedState(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.commonFetchInitialize(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.next(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:196)
at net.segns.common.util.db.SQLHandle.main(SQLHandle.java:305)
package net.segns.dataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class DataSourceImp extends HibernateDaoSupport implements DataSource {
public void eee()
{
Connection conn=this.getSession().connection();
int c=0;
try {
PreparedStatement ps=conn.prepareStatement("select * from sys_area order by areaid");
ResultSet rs=ps.executeQuery();
while( rs.next())
c++;
rs.close();
ps.close();
conn.close();
} catch (Exception e) {
System.out.println("有:"+c);
e.printStackTrace();
}
}
}
package net.segns.dataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class DataSourceImp extends HibernateDaoSupport implements DataSource {
public Connection getConnection()
{
Connection conn=this.getSession().connection();
int c=0;
try {
PreparedStatement ps=conn.prepareStatement("select * from sys_area order by areaid");
ResultSet rs=ps.executeQuery();
while( rs.next())
c++;
rs.close();
ps.close();
conn.close();
} catch (Exception e) {
System.out.println("有:"+c);
e.printStackTrace();
}
return conn;
}
}
<!DOCTYPE beans PUBLIC "-//SPRING/DTD BEAN/EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<description>sessionFactory</description>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="mappingResources">
<list>
<value>hibernatecfg/org_broadcastschedule.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>
</beans>
<bean id="DataSourceDAO"
class="net.segns.dataSource.DataSourceImp" >
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
public static void main(String[] args) {
try {
DataSource ds=(DataSource)SpringApplicationContextFactory
.getService("DataSourceDAO");
ds.eee();
} catch (Exception e) {
e.printStackTrace();
}
}
有:1930
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.validateClosedState(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateClosedState(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.commonFetchInitialize(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.next(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:196)
at net.segns.dataSource.DataSourceImp.eee(DataSourceImp.java:21)
at net.segns.common.util.db.SQLHandle.main(SQLHandle.java:304)
<!DOCTYPE beans PUBLIC "-//SPRING/DTD BEAN/EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<description>sessionFactory</description>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="mappingResources">
<list>
... <value>hibernatecfg/org_broadcastschedule.hbm.xml</value>
...
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>
</bean>
</beans>
Session session = this.getSession();
Connection con = session.connection();
PreparedStatement ps = con.prepareStatement(select * from sys_area order by areaid);//预处理
ps.execute();//执行操作