十步搞定tomcat4.1.18 Servlet中的SQL SERVER2000数据库连接池

最新推荐文章于 2022-11-11 10:10:16 发布

原创最新推荐文章于 2022-11-11 10:10:16 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库连接池 #sql server #servlet #tomcat #import #microsoft

数据库相关专栏收录该内容

8 篇文章

订阅专栏

十步搞定tomcat4.1.18 Servlet中的SQL SERVER2000数据库连接池

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三个文件,将三个文件COPY到TOMCAT 4.1下commonlib文件夹中

2.在TOMCAT 4.1的SERVER.XML中HOST域中添加如下代码

   factory
         org.apache.commons.dbcp.BasicDataSourceFactory


   maxActive
         100


   maxIdle
         30


         maxWait
         10000


   username
   sa

   password
   你的密码

   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",并添加如下内容

    "http://java.sun.com/dtd/web-app_2_3.dtd">

My Web

   invoker
   /servlet/*

   jdbc/mydb
   javax.sql.DataSource
   Container

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("");
        out.println("");
        out.println("");
        out.println("");
        out.println("");
        out.println("