API tools faq
paste
Guest User

dbStudent

a guest
Oct 14th, 2018
41
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.97 KB | None | 0 0
raw download clone embed print report
  1. import java.sql.*;
  2. import java.io.IOException;
  3. import java.io.PrintWriter;
  4. import java.util.logging.Level;
  5. import java.util.logging.Logger;
  6. import javax.servlet.ServletException;
  7. import javax.servlet.http.HttpServlet;
  8. import javax.servlet.http.HttpServletRequest;
  9. import javax.servlet.http.HttpServletResponse;
  10.  
  11.  
  12. public class dbStudent extends HttpServlet {
  13.  
  14.  
  15. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  16. throws ServletException, IOException, ClassNotFoundException, SQLException {
  17. response.setContentType("text/html;charset=UTF-8");
  18. try (PrintWriter out = response.getWriter()) {
  19. String title="Student Data";
  20. /* TODO output your page here. You may use following sample code. */
  21. out.println("<!DOCTYPE html>");
  22. out.println("<html>");
  23. out.println("<head>");
  24. out.println("<title>DB STUDENT</title>");
  25. out.println("</head>");
  26. out.println("<body>");
  27. out.println("<h1>STUDENT RECORD</h1>");
  28.  
  29. String asd = request.getParameter("search");
  30.  
  31.  
  32. try {
  33. Connection con = null;
  34. Class.forName("com.mysql.jdbc.Driver");
  35. con = DriverManager.getConnection("jdbc:mysql://localhost:3306/awd","root", "");
  36.  
  37. Statement stUser = con.createStatement();
  38. ResultSet rsUser = stUser.executeQuery("SELECT * FROM clerk WHERE name like '"+asd+"'");
  39.  
  40. while (rsUser.next()){
  41.  
  42. String name = rsUser.getString("name");
  43. String ic = rsUser.getString("ic");
  44. String address = rsUser.getString("address");
  45. String trainer = rsUser.getString("trainer");
  46. String license = rsUser.getString("license");
  47. String trainingfee = rsUser.getString("training_fee");
  48. String traininghours = rsUser.getString("training_hours");
  49. String totalpayment = rsUser.getString("total_payment");
  50.  
  51. out.println("<center>");
  52. out.println("<h3>The information you have registered</h3>");
  53. out.println("<table bgcolor='#FFE4B5' border='0' cellspacing='1' cellpadding='10'>");
  54. out.println("<tr>");
  55. out.println("<td>Name : </td><td>:</td><td>"+ name + "</td>");
  56. out.println("</tr>");
  57. out.println("<tr>");
  58. out.println("<td>Number I/C :</td><td>:</td><td>" + ic + "</td>");
  59. out.println("</tr>");
  60. out.println("<tr>");
  61. out.println("<td>Address :</td><td>:</td><td>" + address + "</td>");
  62. out.println("</tr>");
  63. out.println("<tr>");
  64. out.println("<td>Trainer : </td><td>:</td><td>" + trainer+ "</td>");
  65. out.println("</tr>");
  66. out.println("<tr>");
  67. out.println("<td>License : </td><td>:</td><td>" + license+ "</td>");
  68. out.println("</tr>");
  69. out.println("<tr>");
  70. out.println("<td>Training Fee : </td><td>:</td><td>" + trainingfee+ "</td>");
  71. out.println("</tr>");
  72. out.println("<tr>");
  73. out.println("<td>Training Hours : </td><td>:</td><td>" + traininghours+ "</td>");
  74. out.println("</tr>");
  75. out.println("<tr>");
  76. out.println("<td>Total Payment : </td><td>:</td><td>" + totalpayment+ "</td>");
  77. out.println("</tr>");
  78.  
  79. out.println("</center>");
  80. out.println("</table>");
  81. out.println("<br>");
  82.  
  83.  
  84. }
  85.  
  86. } catch (Exception exc) {
  87.  
  88. }
  89.  
  90. out.println("</body>");
  91. out.println("</html>");
  92. }
  93. }
  94.  
  95. // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
  96. /**
  97. * Handles the HTTP <code>GET</code> method.
  98. *
  99. * @param request servlet request
  100. * @param response servlet response
  101. * @throws ServletException if a servlet-specific error occurs
  102. * @throws IOException if an I/O error occurs
  103. */
  104. @Override
  105. protected void doGet(HttpServletRequest request, HttpServletResponse response)
  106. throws ServletException, IOException {
  107. try {
  108. processRequest(request, response);
  109. } catch (ClassNotFoundException ex) {
  110. Logger.getLogger(dbStudent.class.getName()).log(Level.SEVERE, null, ex);
  111. } catch (SQLException ex) {
  112. Logger.getLogger(dbStudent.class.getName()).log(Level.SEVERE, null, ex);
  113. }
  114. }
  115.  
  116. /**
  117. * Handles the HTTP <code>POST</code> method.
  118. *
  119. * @param request servlet request
  120. * @param response servlet response
  121. * @throws ServletException if a servlet-specific error occurs
  122. * @throws IOException if an I/O error occurs
  123. */
  124. @Override
  125. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  126. throws ServletException, IOException {
  127. try {
  128. processRequest(request, response);
  129. } catch (ClassNotFoundException ex) {
  130. Logger.getLogger(dbStudent.class.getName()).log(Level.SEVERE, null, ex);
  131. } catch (SQLException ex) {
  132. Logger.getLogger(dbStudent.class.getName()).log(Level.SEVERE, null, ex);
  133. }
  134. }
  135.  
  136. /**
  137. * Returns a short description of the servlet.
  138. *
  139. * @return a String containing servlet description
  140. */
  141. @Override
  142. public String getServletInfo() {
  143. return "Short description";
  144. }// </editor-fold>
  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!