web项目取得spring配置的数据源的简单实现方法:
1.spring配置:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@192.168.100.180:1521:torcl</value>
</property>
<property name="username">
<value>mr</value>
</property>
<property name="password">
<value>mr123</value>
</property>
</bean>
<bean id="dataSource_iod" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>oracle.jdbc.driver.OracleDriver</value>
</property>
<property name="url">
<value>jdbc:oracle:thin:@10.248.112.6:1521:fssms</value>
</property>
<property name="username">
<value>tdssms</value>
</property>
<property name="password">
<value>tdssms#0757</value>
</property>
</bean>
2.初始化
public static void init(BeanFactory _beanFactory) {
filepath = com.tds.framework.util.Environment
.getProperty("filepath_applicationContext.xml");
ApplicationContext ac = new FileSystemXmlApplicationContext(filepath);
bds = (BasicDataSource) ac.getBean("dataSource");
bds_iod = (BasicDataSource) ac.getBean("dataSource_iod");
或者
ApplicationContext ac = new FileSystemXmlApplicationContext("D:/Program Files/apache-tomcat-6.0.18/webapps/ccp_boss_client_web/WEB-INF/classes/applicationContext.xml");
bds = (BasicDataSource)ac.getBean("dataSource");
bds_iod = (BasicDataSource)ac.getBean("dataSource_iod");
// 设置登录
// System.out.println("初始化boss登录开始");
// com.tds.simulate.login.LoginSimulate.initClent_static();
// System.out.println("初始化boss登录结束");
}
3.取得datasource
public static Connection getSpringFrameworkDBConnect() {
try {
//if(context==null) context = new ContextHelper().getContext();
//if(ds==null)ds = (DataSource) context.getBean("dataSource");
if(bds==null) {
ApplicationContext ac = new FileSystemXmlApplicationContext("D:/Program Files/apache-tomcat-6.0.18/webapps/ccp_boss_client_web/WEB-INF/classes/applicationContext.xml");
bds = (BasicDataSource)ac.getBean("dataSource");
}
return bds.getConnection();
//return ds.getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
// 可能因为连接池耗尽,无法取得连接
return null;
}
4.调用:
Connection conn=com.tds.framework.util.Tool.getSpringFrameworkDBConnect("iod");