struts中数据源的配置

package mypack.common;

import java.sql.Connection;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.sql.DataSource;

import org.apache.struts.action.ActionServlet;
import org.apache.struts.action.PlugIn;
import org.apache.struts.config.ModuleConfig;

public class ConnPool implements PlugIn {
    private static DataSource ds=null;
    private static Connection conn=null;
 public void destroy() {
  ds=null;
 }

 public void init(ActionServlet servlet, ModuleConfig config)
   throws ServletException {
  ds=(DataSource)servlet.getServletContext().getAttribute("oracle1");
       
 }
 public static Connection getConn(){
  if(ds!=null){
   try {
    conn=ds.getConnection();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
  return conn;
 }

}

 

 

 

 

说明：

方法一:
1.写ConnPool.java文件。
2.在struts-config.xml中配置如下：
<data-sources>
  <data-source key="oracle1"
   type="org.apache.commons.dbcp.BasicDataSource">
   <set-property property="driverClassName"
    value="oracle.jdbc.driver.OracleDriver" />
    <set-property property="url"
    value="jdbc:oracle:thin:@localhost:1521:ORASID"/>
    <set-property property="username" value="bb"/>
                 <set-property property="password" value="bb"/>
                  <set-property property="maxActive" value="20"/>
                   <set-property property="maxIdle" value="4"/>
                    <set-property property="maxWait" value="200000"/>
                    <set-property property="autoCommit" value="true"/>
  </data-source>
 </data-sources>
在action中输入下列代码
DataSource rs=this.getDataSource(request, "oracle1");
方法二：
1.写ConnPool.java文件。
2.在struts-config.xml中配置如下：
<data-sources>
  <data-source key="oracle1"
   type="org.apache.commons.dbcp.BasicDataSource">
   <set-property property="driverClassName"
    value="oracle.jdbc.driver.OracleDriver" />
    <set-property property="url"
    value="jdbc:oracle:thin:@localhost:1521:ORASID"/>
    <set-property property="username" value="bb"/>
                 <set-property property="password" value="bb"/>
                  <set-property property="maxActive" value="20"/>
                   <set-property property="maxIdle" value="4"/>
                    <set-property property="maxWait" value="200000"/>
                    <set-property property="autoCommit" value="true"/>
  </data-source>
 </data-sources>
<plug-in className="mypack.common.ConnPool"></plug-in>
3.在jsp页面中调用ConnPool.getConn();