Tomcat5.0数据库连接池

在 的config中的server.xml文件中修改(增加):

<Context path="/webroot" docBase="gxsf/webroot" debug="0"
                 reloadable="true" crossContext="true">
                  <Resource name="jdbc/gxsf" auth="Container" type="javax.sql.DataSource"/>
           <ResourceParams name="jdbc/gxsf">
            <parameter>

              <name>factory</name>

              <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>

       </parameter>

            <parameter>

              <name>maxActive</name>

              <value>200</value>

       </parameter>
       <parameter>

              <name>maxIdle</name>

              <value>20</value>

       </parameter>

           <parameter>
           <name>username</name>
           <value>gxsf</value>
           </parameter>
           <parameter>
           <name>password</name>
           <value>gxsfgxsf</value>
           </parameter>
            <parameter>

              <name>driverClassName</name>

              <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>

       </parameter>

          <parameter>

              <name>url</name>

              <value>jdbc:microsoft:sqlserver://202.116.138.104:1433;databaseName=gxsf</value>

      

       </parameter>

    </ResourceParams>

 </Context>

在程序的调用方法: Context env = (Context)new InitialContext().lookup("java:comp/env");

DataSource source = (DataSource) env.lookup("jdbc/"+strcon);

this.con = source.getConnection();