Mine

package practice;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import managers.MemberManager;

import java.sql.*;
import beans.*;

import java.util.*;

 public class GetMemberServlet extends javax.servlet.http.HttpServlet 
 										implements javax.servlet.Servlet 
 {
   
	private static final long serialVersionUID = 1L;
	private ServletContext application;
	
	protected void service(HttpServletRequest request,HttpServletResponse response) 
							throws ServletException, IOException 
							{
		try
        {
		       
        
        	MemberManager manager = new MemberManager();
        	ArrayList list = manager.getMembers();
        	//dispatch(request,response,"/success.jsp");
//                Class.forName("org.gjt.mm.mysql.Driver");
//                Connection dbConn = DriverManager.getConnection("jdbc:mysql://antares.nait.ca:3306/dracula","cst6492","cst6492");
//                String sql ="Select * from member";
//                PreparedStatement dbStatement = dbConn.prepareStatement(sql);
//                ResultSet dbResultSet = dbStatement.executeQuery();
//                Vector members = new Vector();
//                while(dbResultSet.next())
//                {
//               	 Member bean = new Member();
//               	 bean.setMemberId(dbResultSet.getString("memberId"));
//               	 bean.setMemberPassword(dbResultSet.getString("memberPassword"));
//               	 members.add(bean);               	 
//                }
        	if (list !=null)
        	{
                request.setAttribute("memberList", list);
        		dispatch(request, response,"/DisplayMembers.jsp");
//                dbStatement.close();
//                dbConn.close();
        	}       	
        	else   
        	{
        		request.setAttribute("errorMessage","Error:" + "bad deal");
                dispatch(request,response,"/error.jsp");
        	}
        }
		
	
        catch(Exception e)
        {
                request.setAttribute("errorMessage","Error:" + e);
                dispatch(request,response,"/error.jsp");
        }
	}
 
	public void init() throws ServletException 
	{		
		application = getServletContext();
	}
	
	private void dispatch(	HttpServletRequest request, HttpServletResponse response, String path) 
							throws ServletException, IOException 
	{		
		RequestDispatcher dispatcher = application.getRequestDispatcher(path);
		dispatcher.forward( request, response );
	}
	   	  	    
}