Advertisement
Guest User

Untitled

a guest
Jan 14th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.15 KB | None | 0 0
  1. Servlets and JSP blank
  2. import java.io.IOException;
  3. import java.io.PrintWriter;
  4. import java.sql.Connection;
  5. import java.sql.DriverManager;
  6. import java.sql.ResultSet;
  7. import java.sql.SQLException;
  8. import java.sql.Statement;
  9. import java.util.ArrayList;
  10.  
  11. import javax.servlet.RequestDispatcher;
  12. import javax.servlet.ServletException;
  13. import javax.servlet.annotation.WebServlet;
  14. import javax.servlet.http.HttpServlet;
  15. import javax.servlet.http.HttpServletRequest;
  16. import javax.servlet.http.HttpServletResponse;
  17. import javax.servlet.http.HttpSession;
  18.  
  19. /**
  20. * Servlet implementation class TutorAssign
  21. */
  22. @WebServlet("/TutorAssign")
  23. public class TutorAssign extends HttpServlet {
  24. private static final long serialVersionUID = 1L;
  25.  
  26. /**
  27. * @see HttpServlet#HttpServlet()
  28. */
  29. public TutorAssign() {
  30. super();
  31. // TODO Auto-generated constructor stub
  32. }
  33.  
  34. /**
  35. * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  36. */
  37. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  38. // TODO Auto-generated method stub
  39. }
  40.  
  41. private void sendBack(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  42. HttpSession session = request.getSession(true);
  43. //Set data you want to send back to the request (will be forwarded to the page)
  44. //Can set string, int, list, array etc.
  45.  
  46. String sql = "SELECT l.id,s.name,l.day,l.time,l.room" +
  47. " FROM subject s, lab l " +
  48. " WHERE s.user_id="+(Integer)session.getAttribute("id");
  49.  
  50. try{
  51. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/wae","root","");
  52. System.out.println("got boobs");
  53. System.out.println(session.getAttribute("id"));
  54.  
  55. Statement stmt = con.createStatement();
  56. ResultSet res = stmt.executeQuery(sql);
  57. System.out.println(res);
  58. ArrayList<String> list1 = new ArrayList<String>();
  59. ArrayList<String> list2 = new ArrayList<String>();
  60. if (res.next()){
  61. do{
  62. list1.add(res.getString(1));
  63. list2.add(res.getString(2)+" "+res.getString(3)+" "+res.getString(4)+" "+res.getString(5));
  64.  
  65.  
  66. }while(res.next());
  67. System.out.println("Outside");
  68. String[] arr1 = list1.toArray(new String[list1.size()]);
  69. String[] arr2 = list2.toArray(new String[list2.size()]);
  70. System.out.println(list1);
  71. request.setAttribute("res1", arr1);
  72. request.setAttribute("res2", arr2);
  73.  
  74. }
  75.  
  76.  
  77.  
  78. }catch (SQLException e) {
  79. }
  80. catch (Exception e) {
  81. }
  82.  
  83.  
  84. //Decides what page to send the request data to
  85. RequestDispatcher view = request.getRequestDispatcher("TutorAssign.jsp");
  86. //Forward to the page and pass the request and response information
  87. view.forward(request, response);
  88. }
  89.  
  90. /**
  91. * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  92. */
  93. protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  94.  
  95.  
  96. int user_id = Integer.parseInt(request.getParameter("id"));
  97. int lab_id = 0;
  98.  
  99. String message = null;
  100. try {
  101. Class.forName("com.mysql.jdbc.Driver");
  102. Connection con =
  103. DriverManager.getConnection("jdbc:mysql://localhost:3306/wae","root","");
  104. System.out.println("got connection");
  105. System.out.println(user_id);
  106. Statement s = con.createStatement();
  107.  
  108. String sql = "INSERT INTO user_lab" +
  109. " (user_id, lab_id)" +
  110. " VALUES" +
  111. " ('" + user_id + "'," +
  112. " '" + lab_id + "')";
  113.  
  114. System.out.println(sql);
  115. int i = s.executeUpdate(sql);
  116. if (i==1) {
  117. message = "Successfully assigned a tutor.";
  118. response.sendRedirect("Lecturer_labs");
  119. }
  120.  
  121. s.close();
  122. con.close();
  123. }
  124. catch (SQLException e) {
  125. message = "Error." + e.toString();
  126. boolean error = true;
  127. }
  128. catch (Exception e) {
  129. message = "Error." + e.toString();
  130. boolean error = true;
  131. }
  132. if (message!=null) {
  133. PrintWriter out = response.getWriter();
  134. out.println("<B>" + message + "</B><BR>");
  135. out.println("<HR><BR>");
  136. }
  137.  
  138. }
  139. // TODO Auto-generated method stub
  140.  
  141.  
  142. }
  143.  
  144. protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  145. sendBack(request,response);
  146. }
  147.  
  148. } catch (SQLException e) {
  149. logger.log(Level.INFO,"SQL Error encountered",e);
  150. } catch (Exception e) {
  151. logger.log(Level.INFO,"Other error encountered",e);
  152. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement