Advertisement
Guest User

Untitled

a guest
Sep 27th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. public class SignIn extends HttpServlet {
  2. private static final long serialVersionUID = 1L;
  3.  
  4.  
  5. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  6. throws ServletException, IOException {
  7. response.setContentType("text/html;charset=UTF-8");
  8. PrintWriter out = response.getWriter();
  9.  
  10. String uname = request.getParameter("uname");
  11. String pass = request.getParameter("pass");
  12.  
  13. Registration.setOnline(uname);
  14. try {
  15. // loading drivers for mysql
  16. Class.forName("com.mysql.jdbc.Driver");
  17.  
  18. // creating connection with the database
  19. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ted", "root", "root");
  20. PreparedStatement ps = con.prepareStatement("select * from user");
  21. ResultSet rs = ps.executeQuery();
  22. out.println("<table>");
  23. while (rs.next()) {
  24. uname = rs.getString(1);
  25. pass = rs.getString(2);
  26. out.println("<tr><th>" + uname +"</th><th>"+ pass + "</th></tr>");
  27. }
  28. out.println("</table>");
  29.  
  30. } catch (Exception e) {
  31. e.printStackTrace();
  32. }
  33.  
  34.  
  35. RequestDispatcher res = request.getRequestDispatcher("html/index.html");
  36. res.include(request, response);
  37.  
  38. }
  39. }
  40.  
  41. <servlet-mapping>
  42. <servlet-name>SignIn</servlet-name>
  43. <url-pattern>/signIn</url-pattern>
  44. </servlet-mapping>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement