[转自互联网]tomcat5.0中配置sqlserver2000数据库连接池_tomcat5.0连接sql2000数据库-优快云博客

本文链接：https://blog.youkuaiyun.com/learningjsp/article/details/574700

在tomcat文件中配置文件中加入：
<Context path="/DBTest" docBase="D:/rautinee work/db/"
debug="5" reloadable="true" crossContext="true">

<ResourceParams name="jdbc/TestDB">
   <parameter>
     <name>factory</name>
     <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
   </parameter>

<parameter>
     <name>maxActive</name>
     <value>100</value>
   </parameter>

<parameter>
     <name>maxIdle</name>
     <value>30</value>
   </parameter>

<parameter>
     <name>maxWait</name>
     <value>10000</value>
   </parameter>

<parameter>
    <name>username</name>
    <value>sa</value>
   </parameter>
   <parameter>
    <name>password</name>
    <value></value>
   </parameter>

<parameter>
      <name>driverClassName</name>
      <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
   </parameter>

<parameter>
     <name>url</name>
     <value>jdbc:microsoft:sqlserver://localhost:1433;databasename=Northwind</value>
   </parameter>
</ResourceParams>
</Context>

连接池测试DBTest.java：
package foo;

import javax.naming.*;
import javax.sql.*;
import java.sql.*;

public class DBTest {

String foo = "Not Connected";
String bar = "oo";

public void init() {
   try{
     Context ctx = new InitialContext();
     if(ctx == null )
         throw new Exception("Boom - No Context");

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/TestDB");

     if (ds != null) {
       Connection conn = ds.getConnection();

       if(conn != null) {
           foo = "Got Connection "+conn.toString();
           Statement stmt = conn.createStatement();
           ResultSet rst =
               stmt.executeQuery("select * from orders");
           if(rst.next()) {
              foo=rst.getString("CustomerID");
              bar=rst.getString("OrderID");
           }
           conn.close();
       }
     }
   }catch(Exception e) {
     e.printStackTrace();
   }
}