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("數(shù)據(jù)庫(kù)連接不成功！");
    }
    else {
      System.out.println("數(shù)據(jù)庫(kù)連接成功！");
    }
  }

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

  public void destroy() {
  }
}