Advertisement
Guest User

Untitled

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