Guest User

Untitled

a guest
Apr 16th, 2018
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. response.setContentType("text/html");
  2. PrintWriter out = response.getWriter();
  3. String id = request.getParameter("srchbyid");
  4. String ques = request.getParameter("ques");
  5. String lang = request.getParameter("lang");
  6. String opt1 = request.getParameter("opt1");
  7. String opt2 = request.getParameter("opt2");
  8. String opt3 = request.getParameter("opt3");
  9. String opt4 = request.getParameter("opt4");
  10. String ans = request.getParameter("opt");
  11. String selected_ans = (ans.equals("1") ? "1" : ans.equals("2") ? "2" : ans.equals("3") ? "3" : "4");
  12. try {
  13. Class.forName("oracle.jdbc.driver.OracleDriver");
  14. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "nivt", "1234");
  15. PreparedStatement ps = con.prepareStatement("select * from addques where qid=?");
  16.  
  17. ps.setString(1, id);
  18. ResultSet rs = ps.executeQuery();
  19.  
  20. while (rs.next()) {
  21. ques = rs.getString(2);
  22. request.setAttribute("ques", ques);
  23. lang = rs.getString(8);
  24. request.setAttribute("lang", lang);
  25. opt1 = rs.getString(3);
  26. request.setAttribute("opt1", opt1);
  27. opt2 = rs.getString(4);
  28. request.setAttribute("opt2", opt2);
  29. opt3 = rs.getString(5);
  30. request.setAttribute("opt3", opt3);
  31. opt4 = rs.getString(6);
  32. request.setAttribute("opt4", opt4);
  33. RequestDispatcher rd = request.getRequestDispatcher("/welcome.jsp");
  34. rd.forward(request, response);
  35. }
  36. } catch (Exception e) {
  37. out.print(e);
  38.  
  39. }
Add Comment
Please, Sign In to add comment