notepadservlet.java

JAVA Servlet2.3外文书籍源码

package sessions;

import java.sql.*;

import javax.servlet.http.HttpServlet;

/**
 * This class provides the common database related functionality for
 * the servlets in the NotePad web application.
 */
public abstract class NotePadServlet extends HttpServlet {

    /**
     * This method returns a database connection
     */
    protected Connection getConnection() throws SQLException 
    { 
	try {
	    Class.forName("org.gjt.mm.mysql.Driver");
	    Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/notepad");
	    return connection;
	}
	catch(ClassNotFoundException cnfe) {
	    throw new SQLException("Unable to load the driver: " + cnfe.getMessage());
	}
    }
}