dbservlet.java

孙鑫的Java Web开发详解一书的源代码

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

public class DBServlet extends HttpServlet
{
    final static String driver="com.mysql.jdbc.Driver";
    final static String url="jdbc:mysql://localhost:3306/bookstore";
    final static String user="root";
    final static String password="12345678";
    
    public synchronized void doGet(HttpServletRequest req, HttpServletResponse resp)
               throws ServletException,IOException
    {
        try
        {
            Class.forName(driver);
            Connection conn=DriverManager.getConnection(url,user,password);
        }
        catch(Exception ce)
        {
            throw new UnavailableException("加载数据库驱动失败！");
        }
        ...   
    }
}