dbconnectservlet.java

来自「Java 2实用编程百例,一些比较实用的J2SE小程序,可以通过这些程序熟悉JA」· Java 代码 · 共 35 行

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() {
  }
}