十步搞定tomcat4.1.18 Servlet中的SQL SERVER2000資料庫連線池 (轉)[@more@]

1.從.com/s/details.x?FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&DisplayLang=en#filelist">"Microsoft SERVER 2000 for JC",並,得到msbase.jar,mssqlserver.jar和msutil.jar三個,將三個檔案COPY到 4.1下commonlib資料夾中

2.在TOMCAT 4.1的SERVER.中HOST域中新增如下程式碼

 
 
 
 factory
   org..commons.dbcp.BasicDataSourceFactory
   
   
 maxActive
   100
   
   
 maxIdle
   30
   
   
   maxWait
   10000
   
 
 username
 sa
 
 
 pass
 你的密碼
 
 
 driverClassName
 com.microsoft.jdbc.sqlserver.SQLServerDriver
 
 
 url
 jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs
  
 

3.在webapps下新建資料夾"myweb","mywebWEB-INF","mywebWEB-INFclasses"

4.在WEB-INF下新建檔案"web.xml",並新增如下內容

BR>  "">

 My Web
 
 invoker
 /servlet/*
 
 
 jdbc/mydb
 javax.sql.DataSource
 Container
 

5.編寫servletJDBCPoolServ.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(" * 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("");
  out.println("

");
  out.println("");
  out.println("");
  out.println("");
  out.println("

" + val + "

");
  out.println("");
  out.println("");
  }
}

6.編譯JDBCPoolServ.java得到JDBCPoolServ.class(注意加入servlet.jar包),將其COPY到"mywebWEB-INFclasses"下

7.啟動2000

8.啟動TOMCAT

9.瀏覽

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

注意:如果無法正常執行請檢查以上資料夾名,URL和JAVA類名大小寫是否一致

to:BluePengui@china.com">BluePengui@china.com

BluePenguin
-2-11