Advertisement
Guest User

Untitled

a guest
Jun 19th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.70 KB | None | 0 0
  1. package clases;
  2.  
  3. import java.io.IOException;
  4. import java.io.PrintWriter;
  5. import javax.servlet.ServletException;
  6. import javax.servlet.http.HttpServlet;
  7. import javax.servlet.http.HttpServletRequest;
  8. import javax.servlet.http.HttpServletResponse;
  9. import java.sql.*;
  10. import javax.servlet.RequestDispatcher;
  11.  
  12. public class muestra extends HttpServlet {
  13.  
  14.     protected void doPost(HttpServletRequest request, HttpServletResponse response)
  15.     throws ServletException, IOException {
  16.         response.setContentType("text/html;charset=UTF-8");
  17.         PrintWriter out = response.getWriter();
  18.  
  19.             String nombre = request.getParameter("nom");
  20.  
  21.             try{
  22.             Class.forName("com.mysql.jdbc.Driver");
  23.             Connection cn = DriverManager.getConnection("nombjdbc:mysql://localhost:3306/pruebajsp", "root", "");
  24.             Statement st = cn.createStatement();
  25.             String sql = "Select * from prueba where nombre='"+nombre+"'";
  26.             ResultSet rs = st.executeQuery(sql);
  27.             while(rs.next()){
  28.                 String telefono = rs.getString("telefono");
  29.                 String men = "El telefono es "+telefono+"";
  30.                 out.println("<html>");
  31.                 out.println("<head></head>");
  32.                 out.println("<body>");
  33.                 out.println("El Numero es"+men+"");
  34.                 out.println("</body>");
  35.                 out.println("</html>");
  36.                 rs.close();
  37.                 st.close();
  38.                 cn.close();
  39.                 }
  40.            
  41.            
  42.         }
  43.             catch(Exception e){
  44.                 System.out.println(e.getMessage());
  45.             }
  46.            
  47.            
  48.            
  49.        
  50.     }
  51. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement