import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; import java.util.*; public final class TestePool extends HttpServlet { private DBConnectionManager dbm; private Connection conexao; private Statement st; public void service (HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { this.dbm = DBConnectionManager.getInstance(); this.conexao = this.dbm.getConnection("db1"); /* Class.forName("org.gjt.mm.mysql.Driver").newInstance(); String url= "jdbc:mysql://localhost:3306/dbteste1?user=root&password="; conexao = DriverManager.getConnection(url); */ this.st = this.conexao.createStatement(); } catch(Exception e) {e.printStackTrace();}; ResultSet resultado = null; String sqlQuery = "SELECT * FROM testepool"; try { resultado = this.st.executeQuery(sqlQuery); } catch (SQLException e) {e.printStackTrace();} PrintWriter out=null; 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(""); try { while (resultado.next()) { out.println(""); out.println(""); out.println(""); out.println(""); } } catch (SQLException e) {e.printStackTrace();} out.println("
CodigoDescricao
"+ Integer.toString(resultado.getInt("sequencia")) + ""+ resultado.getString("texto") + "
"); out.println(""); out.println(""); out.close(); try { this.st.close(); //this.conexao.close(); } catch (SQLException e) {e.printStackTrace();} this.dbm.freeConnection("tag_ambiente",this.conexao); } }