Tomcat配置JNDI数据源

在tomcat\conf\server.xml的<Host>中添加：
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)+"------------");
}
//...