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(""); out.println(""); out.println(" Resultado da Consulta "); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); while (rs.next()) { out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); out.println(""); } out.println("
NomeEstadoSexoSocio?Email
"+ ""+rs.getString("nome")+ ""+ rs.getString("estado")+ ""+ rs.getString("sexo")+ ""+ rs.getString("socio")+ ""+ rs.getString("email")+ "
"); rs.close(); st.close(); out.println(""); out.println(""); out.close(); } catch(Exception e){ System.out.println(e); } } }