行行好! 那位给我一段Oracle数据库数据池的连接方式JSP代码！

Question

<Context path="/chen_project" reloadable="true" docBase="C:\eclipse\workspace\chen_project" workDir="C:\eclipse\workspace\chen_project\work\org\apache\jsp" />
 <Context  path=""  docBase="ROOT"  debug="0">  
 <Resource  name="jdbc/OracleDB"  auth="Container"  type="javax.sql.DataSource"/>  
       <ResourceParams  name="jdbc/OracleDB">  
       <parameter>  
       <name>factory</name>  
   <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>  
   </parameter>  
   <parameter>  
      <name>driverClassName</name>  
  <value>oracle.jdbc.driver.OracleDriver</value>  
   </parameter>  
   <parameter>  
      <name>url</name>  
  <value>jdbc:oracle:thin:@10.10.11.144:1521:edu</value>  
   </parameter>  
   <parameter>  <name>username</name>  <value>study1</value>  </parameter>  
   <parameter>  <name>password</name>  <value>study1</value>  </parameter> 
   <parameter>  <name>maxActive</name>  <value>20</value>  </parameter>  
   <parameter>  <name>maxIdle</name>  <value>10</value>  </parameter>  
   <parameter>  <name>maxWait</name>  <value>-1</value>  </parameter>  
   </ResourceParams>  
</Context>

Answer 1

/*
 * Created on 2004-8-17
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.youcompany.struts.database;/**
 * @author admin1
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
//import java.util.*;public class ConnectionPool {

public static String JNDI_NAME="java:comp/env/jdbc/OracleDB";
private DataSource ds;
private static ConnectionPool mySelf;

    // ConnectionPool类构造函数
private ConnectionPool(DataSource ds){
this.ds=ds;
}
//getInstance()方法建立数据库连接池  由Biz层来调用
public static ConnectionPool getInstance(){
try{
if(mySelf==null){
Context initCtx=new InitialContext();
DataSource ds =(DataSource)initCtx.lookup(JNDI_NAME);
mySelf=new ConnectionPool(ds);
}
return mySelf;
}catch(NamingException ex){
ex.printStackTrace();
throw new RuntimeException("error.unexpected1234");
}
}
public Connection getConnction(boolean autoCommit) throws SQLException{
Connection con=ds.getConnection();
con.setAutoCommit(autoCommit);
return con;
}}

Answer 2

private String strDriver = "oracle.jdbc.driver.OracleDriver";
private String strPwd = "pass";
private String strURL = "jdbc:oracle:thin:@10.13.11.1:1521:oradb";
private String strUser = "user";
try {
Class.forName(strDriver);
this.sqlConn = DriverManager.getConnection(strURL, strUser, strPwd);
return sqlConn;
} catch (Exception e) {
e.printStackTrace();
return null;
}

Answer 3

TO;licheng7000(licheng7000) 后面的是JAVA类文件  前面一篇的是啥?

Answer 4

我有！直接在JSP中。下次发给你！

Answer 5

To:sparkling_lwp(It's My Life ! ~ ~) 
给你分真冤呀！！！！！