Advertisement
Guest User

Untitled

a guest
Mar 4th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.49 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>Student Registration</title>
  5. <meta charset="UTF-8">
  6. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7. </head>
  8. <body>
  9. <form action="http://localhost:8080/DataBaseApp1/StudentReg" method="post">
  10. <table>
  11. <tr>
  12. <td>Username</td>
  13. <td><input type="text" name="usr"></td>
  14. </tr>
  15. <tr>
  16. <td>Password</td>
  17. <td><input type="text" name="Pwd"></td>
  18. </tr>
  19. <tr>
  20. <td>Address</td>
  21. <td><input type="text" name="Addr"></td>
  22. </tr>
  23. <tr>
  24. <td>Gender</td>
  25. <td><input type="text" name="Gdr"></td>
  26. </tr>
  27. <tr>
  28. <td><input type="submit" value="insert"></td>
  29. </tr>
  30. </table>
  31. </form>
  32. </body>
  33. </html>
  34.  
  35. import java.io.IOException;
  36. import java.io.PrintWriter;
  37. import javax.servlet.ServletException;
  38. import javax.servlet.annotation.WebServlet;
  39. import javax.servlet.http.HttpServlet;
  40. import javax.servlet.http.HttpServletRequest;
  41. import javax.servlet.http.HttpServletResponse;
  42. import java.sql.*;
  43. /**
  44. *
  45. * @author DEEN_KADIR
  46. */
  47. @WebServlet(urlPatterns = {"/StudentReg"})
  48. public class StudentReg extends HttpServlet {
  49.  
  50. /**
  51. * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
  52. * methods.
  53. *
  54. * @param request servlet request
  55. * @param response servlet response
  56. * @throws ServletException if a servlet-specific error occurs
  57. * @throws IOException if an I/O error occurs
  58. */
  59. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  60. throws ServletException, IOException {
  61. response.setContentType("text/html;charset=UTF-8");
  62. PrintWriter out = response.getWriter();
  63. int rowsAffected;
  64.  
  65. String username = request.getParameter("usr");
  66. String pass = request.getParameter("pwd");
  67. String address = request.getParameter("Adr");
  68. String gender = request.getParameter("Gdr");
  69.  
  70. try
  71. {
  72. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  73. Connection con = DriverManager.getConnection("jdbc:sqlserver://DEEN:1433;databaseName=StudentRegistration;user=Deenkadir;password=12345");
  74. PreparedStatement stat = con.prepareStatement("insert into StudentDetails(Username, Password, Address, gender) values(?, ?, ?, ?, ?)");
  75. stat.setString(1, username);
  76. stat.setString(2, pass);
  77. stat.setString(3, address);
  78. stat.setString(4, gender);
  79. rowsAffected = stat.executeUpdate();
  80. if(rowsAffected > 0)
  81. {
  82. System.out.println("Values inserted successfully");
  83. // out.println("Success");
  84. }
  85. }
  86. catch(Exception e)
  87. {
  88. //System.out.println("Exception Occured");
  89. e.printStackTrace();
  90. }
  91.  
  92. }
  93.  
  94. // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
  95. /**
  96. * Handles the HTTP <code>GET</code> method.
  97. *
  98. * @param request servlet request
  99. * @param response servlet response
  100. * @throws ServletException if a servlet-specific error occurs
  101. * @throws IOException if an I/O error occurs
  102. */
  103. @Override
  104. protected void doGet(HttpServletRequest request, HttpServletResponse response)
  105. throws ServletException, IOException {
  106. processRequest(request, response);
  107. }
  108.  
  109. /**
  110. * Handles the HTTP <code>POST</code> method.
  111. *
  112. * @param request servlet request
  113. * @param response servlet response
  114. * @throws ServletException if a servlet-specific error occurs
  115. * @throws IOException if an I/O error occurs
  116. */
  117. @Override
  118. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  119. throws ServletException, IOException {
  120. processRequest(request, response);
  121. }
  122.  
  123. /**
  124. * Returns a short description of the servlet.
  125. *
  126. * @return a String containing servlet description
  127. */
  128. @Override
  129. public String getServletInfo() {
  130. return "Short description";
  131. }// </editor-fold>
  132.  
  133. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement