dbconnectservlet.java

JAVA编程百例书中各章节的所有例子的源代码,包括套接字编程

package ch03.section03;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class DBConnectServlet
    extends HttpServlet {
  static final private String CONTENT_TYPE = "text/html; charset=gb2312";
  public void doGet(HttpServletRequest request, HttpServletResponse res) throws
      ServletException, IOException {
    res.setContentType(CONTENT_TYPE);
    PrintWriter out = res.getWriter();
    DBConnectionManager connMgr = DBConnectionManager.getInstance(); //连接池管理类
    Connection conn = null;
    conn = connMgr.getConnection("access");
    if (conn == null) {

      System.out.println("数据库连接不成功！");
    }
    else {
      System.out.println("数据库连接成功！");
    }
  }

  public void doPost(HttpServletRequest request, HttpServletResponse res) throws
      ServletException, IOException {
    doGet(request, res);
  }

  public void destroy() {
  }
}