API tools faq
paste
Guest User

Untitled

a guest
Sep 1st, 2018
52
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.87 KB | None | 0 0
raw download clone embed print report
  1. /*
  2. * To change this template, choose Tools | Templates
  3. * and open the template in the editor.
  4. */
  5. package mypack;
  6.  
  7. //import java.beans.Statement;
  8. import java.io.IOException;
  9. import java.io.PrintWriter;
  10. import java.sql.Connection;
  11. //import java.sql.Connection;
  12. import java.sql.DriverManager;
  13. import java.sql.ResultSet;
  14. import java.sql.Statement;
  15. import javax.servlet.RequestDispatcher;
  16. import javax.servlet.ServletException;
  17. import javax.servlet.http.HttpServlet;
  18. import javax.servlet.http.HttpServletRequest;
  19. import javax.servlet.http.HttpServletResponse;
  20. import javax.servlet.http.HttpSession;
  21.  
  22. /**
  23. *
  24. * @author LAB2PC3
  25. */
  26. public class a extends HttpServlet {
  27.  
  28. /**
  29. * Processes requests for both HTTP
  30. * <code>GET</code> and
  31. * <code>POST</code> methods.
  32. *
  33. * @param request servlet request
  34. * @param response servlet response
  35. * @throws ServletException if a servlet-specific error occurs
  36. * @throws IOException if an I/O error occurs
  37. */
  38. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  39. throws ServletException, IOException {
  40. response.setContentType("text/html;charset=UTF-8");
  41. PrintWriter out = response.getWriter();
  42. try {
  43. /* TODO output your page here. You may use following sample code. */
  44. out.println("<!DOCTYPE html>");
  45. out.println("<html>");
  46. out.println("<head>");
  47. out.println("<title>Servlet LoginServlet</title>");
  48. out.println("</head>");
  49. out.println("<body>");
  50. out.println("<h1>Servlet LoginServlet at " + request.getContextPath() + "</h1>");
  51. out.println("</body>");
  52. out.println("</html>");
  53. } finally {
  54. out.close();
  55.  
  56. }
  57. }
  58.  
  59. // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left
  60. to edit the code.">
  61. /**
  62. * Handles the HTTP
  63. * <code>GET</code> method.
  64. *
  65. * @param request servlet request
  66. * @param response servlet response
  67. * @throws ServletException if a servlet-specific error occurs
  68. * @throws IOException if an I/O error occurs
  69. */
  70. @Override
  71. protected void doGet(HttpServletRequest request, HttpServletResponse response)
  72. throws ServletException, IOException {
  73. //processRequest(request, response);
  74. }
  75.  
  76. /**
  77. * Handles the HTTP
  78. * <code>POST</code> method.
  79. *
  80. * @param request servlet request
  81. * @param response servlet response
  82. * @throws ServletException if a servlet-specific error occurs
  83. * @throws IOException if an I/O error occurs
  84.  
  85. */
  86. @Override
  87. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  88. throws ServletException, IOException {
  89. // processRequest(request, response);
  90.  
  91. response.setContentType("text/html");
  92. System.out.println("MySQL Connect Example.");
  93. Connection conn = null;
  94. String url = "jdbc:mysql://localhost:3306/user_register";
  95. String driver = "com.mysql.jdbc.Driver";
  96. String userName = "root";
  97. String password = "1234";
  98. String username = "";
  99. String userpassword = "";
  100. String strQuery = "";
  101. Statement st = null;
  102. ResultSet rs = null;
  103. HttpSession session = request.getSession(true);
  104. RequestDispatcher dispatcher;
  105. try {
  106. Class.forName(driver).newInstance();
  107. conn = DriverManager.getConnection(url,userName,password);
  108. if (request.getParameter("username") != null
  109. && request.getParameter("username") != "" && request.getParameter("password") !=
  110. null
  111. && request.getParameter("password") != "") {
  112. username = request.getParameter("username").toString();
  113.  
  114. userpassword = request.getParameter("password").toString();
  115. strQuery = "select * from userregister where username='" + username + "' and
  116. userpassword='"+userpassword+"'";
  117. System.out.println(strQuery);
  118. st = conn.createStatement();
  119. rs = st.executeQuery(strQuery);
  120. int count = 0;
  121. while (rs.next()) {
  122. request.setAttribute("username", rs.getString(1));
  123. count++;
  124. }
  125.  
  126. if (count > 0) {
  127. dispatcher = (RequestDispatcher) request.getRequestDispatcher("welcome.jsp");
  128. } else {
  129. request.setAttribute("errorMessage", "Invalid user name or password");
  130. dispatcher = (RequestDispatcher) request.getRequestDispatcher("login.jsp");
  131. }
  132. } else {
  133. dispatcher = (RequestDispatcher) request.getRequestDispatcher("login.jsp");
  134. request.setAttribute("errorMessage", "user name and password canot be empty");
  135. }
  136. dispatcher.forward(request, response);
  137. System.out.println("Connected to the database");
  138. conn.close();
  139. System.out.println("Disconnected from database");
  140.  
  141. } catch (Exception e) {
  142.  
  143. e.printStackTrace();
  144. }
  145. }
  146. }
Add Comment
Please, Sign In to add comment
Public Pastes
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!