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

public class Consulta extends HttpServlet
{ 
    Connection con=null;
	String url= "jdbc:odbc:BANCO";										

    public void init(ServletConfig s) throws ServletException {
    	super.init(s);
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection(url);
		}
		catch (Exception e){
			System.out.println(e);
		}
    }

    public void destroy (){
		try {
				con.close();
		}
		catch (Exception e){}
    }

    public void service (HttpServletRequest request,
                         HttpServletResponse response) 
        throws ServletException, IOException
        {
		try {

		    Statement st = con.createStatement();		 
		    String sql = "SELECT * from cadastro";
		    PrintWriter out=null;	           
			ResultSet rs = st.executeQuery(sql);
			response.setContentType("text/html");
	        out = response.getWriter();

			out.println("<HTML>");
			out.println("<HEAD>");
			out.println("<TITLE> Resultado da Consulta </TITLE>");
			out.println("</HEAD>");
			out.println("<BODY>");
			out.println("<TABLE BORDER=1 >");
			out.println("<TR>");
			out.println("<TH>Nome</TH>");
			out.println("<TH>Estado</TH>");
			out.println("<TH>Sexo</TH>");
			out.println("<TH>Socio?</TH>");
			out.println("<TH>Email</TH>");
			out.println("</TR>");
		
			while (rs.next())
			{
			out.println("<TR>");	
			out.println("<TD>"+ "<A HREF=/examples/servlet/Detalhes?nome="+ rs.getString("nome")+">"+rs.getString("nome")+ "</A></TD>");
			out.println("<TD>"+ rs.getString("estado")+ "</TD>");
			out.println("<TD>"+ rs.getString("sexo")+ "</TD>");
			out.println("<TD>"+ rs.getString("socio")+ "</TD>");
			out.println("<TD>"+ rs.getString("email")+ "</TD>");	
			out.println("</TR>");
			}	

			out.println("</TABLE>");
			rs.close();
			st.close();
			out.println("</BODY>");
			out.println("</HTML>");
			out.close();
		}
		catch(Exception e){
				System.out.println(e);
		}            
            		
       }
}
 

