在tomcat\conf\server.xml的<Host>中添加:
5.5.*版本:
5.0版本:
web.xml
JAVA测试:
5.5.*版本:
<Context path="/Test">
<Resource
name="jdbc/test"
type="javax.sql.DataSource"
password="password"
driverClassName="com.mysql.jdbc.Driver"
maxIdle="2"
maxWait="5000"
username="root"
url="jdbc:mysql://127.0.0.1/test"
maxActive="4"/>
</Context>
5.0版本:
<Resource name="jdbc/test" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/test">
<parameter>
<name>factory</name>
<value>
org.apache.commons.dbcp.BasicDataSourceFactory
</value>
</parameter>
<!-- DBCP database connection settings -->
<!-- JDBC URL -->
<parameter>
<name>url</name>
<value>jdbc:mysql://127.0.0.1/test</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>username</name>
<value>root</value>
</parameter>
<parameter>
<name>password</name>
<value>password</value>
</parameter>
<!-- DBCP connection pooling options -->
<parameter>
<name>maxWait</name>
<value>3000</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
</ResourceParams>
web.xml
<resource-ref>
<description>JNDI JDBC DataSource</description>
<res-ref-name>jdbc/test</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
JAVA测试:
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");//得到环境
DataSource ds = (DataSource)envContext.lookup("jdbc/test"); //得到数据源
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT id,name FROM type");
while(rs.next()){
System.out.println(rs.getString(1)+"------------");
}
//...