十步搞定tomcat4.1.18 Servlet中的SQL SERVER2000數(shù)據(jù)庫(kù)連接池

1.從http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&DisplayLang=en#filelist 下載"Microsoft SQL Server 2000 Driver for JDBC",并安裝,得到msbase.jar,MSSQLserver.jar和msutil.jar三個(gè)文件,將三個(gè)文件COPY到TOMCAT 4.1下common\lib文件夾中

2.在TOMCAT 4.1的SERVER.XML中HOST域中添加如下代碼
<Context path="/myWeb" docBase="myweb" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/mydb" auth="Container" type="Javax.sql.DataSource"/>
<ResourceParams name="jdbc/mydb">
<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://127.0.0.1:1433;DatabaseName=pubs</value>
</parameter>
</ResourceParams>
</Context>

3.在webapps下新建文件夾"myweb","myweb\WEB-INF","myweb\WEB-INF\classes"

4.在WEB-INF下新建文件"web.xml",并添加如下內(nèi)容
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java./dtd/web-app_2_3.dtd">
<web-app>
<display-name>My Web</display-name>
<Servlet-mapping>
  <servlet-name>invoker</servlet-name>
  <url-pattern>/servlet/*</url-pattern>
</servlet-mapping>
<resource-ref>
  <res-ref-name>jdbc/mydb</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
</resource-ref>
</web-app>

5.編寫servlet程序JDBCPoolServ.java
import java.sql.*;
import javax.naming.Context;
import javax.sql.DataSource;
import javax.naming.InitialContext;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;

public class JDBCPoolServ extends HttpServlet
{
public void doGet(HttpServletRequest request,
  HttpServletResponse response) throws ServletException,IOException {
   DataSource ds=null;
   Connection con=null;
   String val="null",title="JDBC Pooling Test";

   try{
     Context initCtx = new InitialContext();
     if(initCtx == null )
            throw new Exception("Boom - No Context");

     ds = (DataSource)initCtx.lookup(
      "java:comp/env/jdbc/mydb");
     if (ds != null){
      con = ds.getConnection();
      if (con != null){
       Statement stmt=con.createStatement();
       ResultSet rs=stmt.executeQuery("select * from authors");
       rs.next();

       val=rs.getString("au_id");
       rs.close();
       stmt.close();
      }
      con.close();
     }

   }
   catch(Exception ex){
     System.out.println(ex.getMessage());
   }

   response.setContentType("text/html");
  PrintWriter out = response.getWriter();
  out.println("<html>");
        out.println("<head>");
        out.println("<title>" + title + "</title>");
        out.println("</head>");
        out.println("<body bgcolor=\"white\">");
        out.println("<h1>" + val + "</h1>");
        out.println("</body>");
        out.println("</html>");
    }
}

6.編譯JDBCPoolServ.java得到JDBCPoolServ.class(注意加入servlet.jar包),將其COPY到"myweb\WEB-INF\classes"下

7.啟動(dòng)SQL SERVER2000

8.啟動(dòng)TOMCAT

9.瀏覽http://127.0.0.1:8080/myweb/servlet/JDBCPoolServ

10.在IE中可看到"172-32-1176"

注意:如果無(wú)法正常運(yùn)行請(qǐng)檢查以上文件夾名,URL和JAVA類名大小寫是否一致

BluePengui@china.com

BluePenguin
2003-2-11

乡下人产国偷v产偷v自拍,国产午夜片在线观看,婷婷成人亚洲综合国产麻豆,久久综合给合久久狠狠狠9

十步搞定tomcat4.1.18 Servlet中的SQL SERVER2000數(shù)據(jù)庫(kù)連接池