Tomcat连接池设置

              今天总算把Tomcat的连接池给搞定了,搞了我好几天的心血啊,现在总算轻松了!可以舒口气了,现在我把 Tomcat连接池的具体方法和步骤写下来:

我先声明下我的环境:Tomcat 5.5.20+SQLSERVER2000 开发版(打了SP4补丁)+Microsoft JDBC Driver SP3+Windows xp sp2

首先,我们在CATALINA_HOME/webapps/目录下按如下所示建好目录:

CATALINA_HOME/webapps/
                                              |--/TomcatPool/
                                              |                      |--/WEB-INF/ 
                                              |                                        |--/web.xml
                                              |--/test.jsp

然后,我们来写test.jsp的内容,如下:

<% @ page contentType = " text/html; charset=GBK " %>
<% @ page  import = " java.sql.* " %>
<% @ page  import = " javax.sql.* " %>
<% @ page  import = " javax.naming.* " %>
< html >
< head >
     < title > 测试 </ title >
</ head >

< body >
<%
try ... {
Context context = new InitialContext();
DataSource ds = (DataSource) context.lookup("java:comp/env/jdbc/Pool");
Connection conn =ds.getConnection();
if(conn!=null)
        out.print("恭喜你，数据库连接池连接成功！");
conn.close();
}
catch (Exception ex) ... {
    out.print(ex.getMessage());
    ex.printStackTrace();
}
%>
</ body >
</ html >

 

第三,我们来写web.xml,如下:

 

<? xml version="1.0" encoding="ISO-8859-1" ?>
<! DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >

< web-app >
      < display-name > TomcatPoolTest </ display-name >
     < description > Test Tomcat Pool </ description >
    
     < resource-ref >
             < description > DB Connection </ description >
             < res-ref-name > jdbc/Pool </ res-ref-name >
             < res-type > javax.sql.DataSource </ res-type >
             < res-auth > Container </ res-auth >
       </ resource-ref >     
</ web-app >

最后,我们还要修改一个地方,那就是CATALINA_HOME/conf/server.xml文件,打开此文件,找到:

<Host appBase="webapps" name="localhost">,在<host></host>中间加入<context>片段,具体如下:

 

< Host
           appBase ="webapps"
          name ="localhost" >
< Context
          path ="/TomcatPool"     
         docBase ="/TomcatPool"            
         crossContext ="true"
         reloadable ="true" >
         < Resource
                      auth ="Container"
                name ="jdbc/Pool"
                type ="javax.sql.DataSource"
                password ="123456"                    //这里是连接你数据库用户sa的密码
                driverClassName ="com.microsoft.jdbc.sqlserver.SQLServerDriver"
                maxIdle ="30"
                maxWait ="10000"
                username ="sa"                //这里是连接数据库的用户sa    
                url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test"      //DatabaseName是你要连接的数据库的名字
                maxActive ="100" />
</ Context >

</ Host >

现在就可以了,打开Tomcat和SQLSERVER,然后就在IE里面输入地址:http://localhost:8080/TomcatPool/test.jsp 你就可以看到了结果了,快去看看吧!