web项目取得spring配置的数据源的简单实现方法

来源：互联网发布：网络真人视频赌博揭秘编辑：程序博客网时间：2024/06/01 15:19

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");