API tools faq
paste
Advertisement
Guest User

code

a guest
Sep 29th, 2016
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.19 KB | None | 0 0
raw download clone embed print report
  1. package Usuarios;
  2.  
  3. import java.io.IOException;
  4. import java.io.PrintWriter;
  5. import java.sql.*;
  6. import java.util.logging.Level;
  7. import java.util.logging.Logger;
  8. import javax.servlet.ServletException;
  9. import javax.servlet.http.HttpServlet;
  10. import javax.servlet.http.HttpServletRequest;
  11. import javax.servlet.http.HttpServletResponse;
  12. import javax.servlet.http.HttpSession;
  13. import Objetos.Tipo;
  14.  
  15. public class ConsultarUsuario extends HttpServlet {
  16.  
  17. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  18. throws ServletException, IOException, SQLException, ClassNotFoundException{;
  19. response.setContentType("text/html;charset=UTF-8");
  20. PrintWriter out = response.getWriter();
  21. try {
  22. Connection conexion = null;
  23. Statement sentencia = null;
  24. ResultSet resultado = null;
  25. Class.forName("com.mysql.jdbc.Driver");
  26. String direccionDriver = "jdbc:mysql://localhost/bd_ventas";
  27. String usuarioot = "root";
  28. String passusuarioot = "n0m3l0";
  29.  
  30. conexion = DriverManager.getConnection(direccionDriver,usuarioot,passusuarioot);
  31.  
  32. sentencia = conexion.createStatement();
  33.  
  34.  
  35. // Inserción de usuario
  36.  
  37. resultado = sentencia.executeQuery("SELECT * FROM usuarios;");
  38. String nombus;
  39. String contus;
  40. int tipus;
  41. // HTML
  42.  
  43. out.println("<html>");
  44. out.println("<head>");
  45. out.println("<title>JSP Page</title>");
  46. out.println("<link rel='stylesheet' type='text/css' href='cssProyectoPsw/cssProyecto.css'>");
  47. out.println("</head>");
  48. HttpSession ses=request.getSession();
  49. int tipip = 0;
  50. String usu = (String)(ses.getAttribute("usuario"));
  51. Tipo bustip = new Tipo();
  52. tipip = bustip.darTipo(usu);
  53. out.println("<body>");
  54. out.println("<header>");
  55. out.println("<nav>");
  56. out.println("<h1>Sistema de ventas de cuentas challenger</h1>");
  57. out.println("<a href='Inicio.jsp'>Inicio</a>");
  58. if (tipip == 3) {
  59. out.println("<a href='Productos.jsp'>Productos</a>");
  60. out.println("<a href='Usuarios.jsp'>Usuarios</a>");
  61. out.println("<a href='Inventario.jsp'>Inventario</a>");
  62. } else if(tipip == 2) {
  63. out.println("<a href='Productos.jsp'>Productos</a>");
  64. }
  65. out.println("<a href='Ventas.jsp'>Ventas</a>");
  66. out.println("<a href='CerrarSesion'>Cerrar Sesion</a>");
  67.  
  68. out.println("</nav>");
  69. out.println("</header>");
  70. out.println("<h1>Distribuidor Orientado a Transacciones Aceptables</h1>");
  71. out.println("<table border='0'>");
  72. out.println("<thead>");
  73. out.println("<tr>");
  74. out.println("<th>Usuarios</th>");
  75. out.println("</tr>");
  76. out.println("</thead>");
  77. out.println("<tbody>");
  78. out.println("<tr>");
  79. out.println("<td><a href='AgregarUsuario.jsp'>Agregar usuarios</a></td>");
  80. out.println("<td><a href='ConsultarUsuario'>Consultar usuarios</a></td>");
  81. out.println("<td><a href='ModificarUsuario'>Modificar usuarios</a>");
  82. out.println("<td><a href='EliminarUsuario'>Eliminar usuarios</a></td>");
  83. out.println("</tr>");
  84. out.println("</tbody>");
  85. out.println("</table>");
  86. out.println("<h3>Consulta de usuarios</h3>");
  87.  
  88.  
  89. out.println("<table border='1'>");
  90. out.println("<thead>");
  91. out.println("<tr>");
  92. out.println("<th>Nombre de usuario</th>");
  93. out.println("<th>Contraseña</th>");
  94. out.println("<th>Tipo</th>");
  95. out.println("</tr>");
  96. out.println("</thead>");
  97. out.println("<tbody>");
  98. while(resultado.next())
  99. {
  100. nombus = resultado.getString("usuario");
  101. contus = resultado.getString("contrasena");
  102. tipus = resultado.getInt("tipo");
  103. out.println("<tr>");
  104. out.println("<td>" + nombus + "</td>");
  105. out.println("<td>" + contus + "</td>");
  106. if(tipus == 1)
  107. out.println("<td>Cliente</td>");
  108. else if(tipus == 2)
  109. out.println("<td>Provedor</td>");
  110. else
  111. out.println("<td>Administrador</td>");
  112. out.println("</tr>");
  113. }
  114.  
  115. out.println("</body>");
  116. out.println("</html>");
  117.  
  118. }
  119. finally
  120. {
  121.  
  122. }
  123. }
  124.  
  125. @Override
  126. protected void doGet(HttpServletRequest request, HttpServletResponse response)
  127. throws ServletException, IOException {
  128. PrintWriter out = response.getWriter();
  129. try {
  130. processRequest(request, response);
  131. } catch (SQLException ex) {
  132. Logger.getLogger(AltaUsuario.class.getName()).log(Level.SEVERE, null, ex);
  133. out.println("no jala" + ex);
  134. } catch (ClassNotFoundException ex) {
  135. Logger.getLogger(AltaUsuario.class.getName()).log(Level.SEVERE, null, ex);
  136. out.println("no jala" + ex);
  137. }
  138. }
  139.  
  140. @Override
  141. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  142. throws ServletException, IOException {
  143. PrintWriter out = response.getWriter();
  144. try {
  145. processRequest(request, response);
  146. } catch (SQLException ex) {
  147. Logger.getLogger(ConsultarUsuario.class.getName()).log(Level.SEVERE, null, ex);
  148. out.println("no jala" + ex);
  149. } catch (ClassNotFoundException ex) {
  150. Logger.getLogger(ConsultarUsuario.class.getName()).log(Level.SEVERE, null, ex);
  151. out.println("no jala" + ex);
  152. }
  153. }
  154.  
  155. @Override
  156. public String getServletInfo() {
  157. return "Short description";
  158. }
  159.  
  160. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!