basecontorller.java

实现用户登录查询删除等功能

package org.inspure.testservletpro.controller;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import javax.servlet.ServletConfig;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;

public class BaseContorller extends HttpServlet {
	Connection conn;

	private String url;

	private String username;

	private String password;

	public void init(ServletConfig config) throws ServletException {

		ServletContext context = config.getServletContext();

		this.url = context.getInitParameter("url");
		this.username = context.getInitParameter("username");
		this.password = context.getInitParameter("password");
		String className = context.getInitParameter("driver_manager");

		try {
			Class.forName(className);
			this.conn = DriverManager.getConnection(url, username, password);
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}

	}
}