Spring 獲取Connection
applicationContext.xml里面設置
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" lazy-init="default" autowire="default" dependency-check="default">
<property name="jndiName">
<value>JDBC/TEST</value>
</property>
</bean> 或者
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:ora"></property>
<property name="username" value="test"></property>
<property name="password" value="123456"></property>
</bean>
通過DataSourceUtils.getConnection(DataSource);就能獲取到設置的DataSource 然后獲得connection
public static Connection getConnection()
throws SQLException
{
return DataSourceUtils.getConnection((DataSource)ServiceLocator.getBean("dataSource"));
}
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean" lazy-init="default" autowire="default" dependency-check="default">
<property name="jndiName">
<value>JDBC/TEST</value>
</property>
</bean> 或者
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:ora"></property>
<property name="username" value="test"></property>
<property name="password" value="123456"></property>
</bean>
通過DataSourceUtils.getConnection(DataSource);就能獲取到設置的DataSource 然后獲得connection
public static Connection getConnection()
throws SQLException
{
return DataSourceUtils.getConnection((DataSource)ServiceLocator.getBean("dataSource"));
}
posted on 2008-03-05 12:45 Pitey 閱讀(3999) 評論(1) 編輯 收藏 所屬分類: Spring