Resultado da Consulta

import java.io.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*; public class ConsultaTexto extends HttpServlet { Connection con=null; String url= "jdbc:mysql://localhost:3306/DELBONI?user=root&password="; public void init(ServletConfig s) throws ServletException { super.init(s); try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 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 { HttpSession sessao = request.getSession(false); String tttt = (String)sessao.getValue("variavel"); try { Statement st = con.createStatement(); PrintWriter out=null; ResultSet rs = st.executeQuery("SELECT * from texto"); response.setContentType("text/html"); out = response.getWriter(); out.println(""); out.println(""); out.println(" Resultado da Consulta "); out.println(""); out.println(""); out.println(""); String texto=new String(); out.println(""); out.println(""); out.println(""); while (rs.next()) { out.println(""); out.println(""); out.println(""); } rs.first(); out.println(""); out.println(""); out.println(""); //out.println(""); out.println("

tttt=" + tttt + "

" + rs.getString("linha") + texto + "

" + rs.getString("linha") + "primeira linha" + "

"); rs.close(); st.close(); out.println(""); out.println(""); out.close(); } catch(Exception e){ System.out.println(e); } } }