转)http://aqsun.blog.sohu.com/39459116.html
1. 安装JDBC驱动
将包含JDBC驱动的jar包放到“${CATALINA_HOME}/common/lib”目录下。
2. 在“${catalina.home}/conf/Catalina/localhost”目录里增加配置文件
(1)配置文件的名称和应用的名称相同;
(2)部分代码为:
<?
xml version="1.0" encoding="UTF-8"
?>
< Context path ="/coding"
docBase ="${catalina.home}/webapps/coding"
debug ="0"
privileged ="true" >
< Resource ...
<ResourceParams ... </ResourceParams >
</ Context >
< Context path ="/coding"
docBase ="${catalina.home}/webapps/coding"
debug ="0"
privileged ="true" >
< Resource ...
<ResourceParams ... </ResourceParams >
</ Context >
<Resource auth="Container"
name ="jdbc/dataSourceName"
type ="javax.sql.DataSource"/>
<ResourceParams name="jdbc/dataSourceName">
<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:@IP:1521:database_name</value>
</parameter>
<parameter>
<name>username</name>
<value>username...</value>
</parameter>
<parameter>
<name>password</name>
<value>password...</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
</ResourceParams>
name ="jdbc/dataSourceName"
type ="javax.sql.DataSource"/>
<ResourceParams name="jdbc/dataSourceName">
<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:@IP:1521:database_name</value>
</parameter>
<parameter>
<name>username</name>
<value>username...</value>
</parameter>
<parameter>
<name>password</name>
<value>password...</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>10000</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>10</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
</ResourceParams>
Context initContext
=
new
InitialContext();
Context envContext = (Context)initContext.lookup( " java:comp/env " );
DataSource dataSource = (DataSource)envContext.lookup( " jdbc/PdataSourceName " );
Connection con = dataSource.getConnection();
......
con.close();
Context envContext = (Context)initContext.lookup( " java:comp/env " );
DataSource dataSource = (DataSource)envContext.lookup( " jdbc/PdataSourceName " );
Connection con = dataSource.getConnection();
......
con.close();