Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package clases;
- import java.io.IOException;
- import java.io.PrintWriter;
- import javax.servlet.ServletException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import java.sql.*;
- import javax.servlet.RequestDispatcher;
- public class muestra extends HttpServlet {
- protected void doPost(HttpServletRequest request, HttpServletResponse response)
- throws ServletException, IOException {
- response.setContentType("text/html;charset=UTF-8");
- PrintWriter out = response.getWriter();
- String nombre = request.getParameter("nom");
- try{
- Class.forName("com.mysql.jdbc.Driver");
- Connection cn = DriverManager.getConnection("nombjdbc:mysql://localhost:3306/pruebajsp", "root", "");
- Statement st = cn.createStatement();
- String sql = "Select * from prueba where nombre='"+nombre+"'";
- ResultSet rs = st.executeQuery(sql);
- while(rs.next()){
- String telefono = rs.getString("telefono");
- String men = "El telefono es "+telefono+"";
- out.println("<html>");
- out.println("<head></head>");
- out.println("<body>");
- out.println("El Numero es"+men+"");
- out.println("</body>");
- out.println("</html>");
- rs.close();
- st.close();
- cn.close();
- }
- }
- catch(Exception e){
- System.out.println(e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement