Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- response.setContentType("text/html");
- PrintWriter out = response.getWriter();
- String id = request.getParameter("srchbyid");
- String ques = request.getParameter("ques");
- String lang = request.getParameter("lang");
- String opt1 = request.getParameter("opt1");
- String opt2 = request.getParameter("opt2");
- String opt3 = request.getParameter("opt3");
- String opt4 = request.getParameter("opt4");
- String ans = request.getParameter("opt");
- String selected_ans = (ans.equals("1") ? "1" : ans.equals("2") ? "2" : ans.equals("3") ? "3" : "4");
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "nivt", "1234");
- PreparedStatement ps = con.prepareStatement("select * from addques where qid=?");
- ps.setString(1, id);
- ResultSet rs = ps.executeQuery();
- while (rs.next()) {
- ques = rs.getString(2);
- request.setAttribute("ques", ques);
- lang = rs.getString(8);
- request.setAttribute("lang", lang);
- opt1 = rs.getString(3);
- request.setAttribute("opt1", opt1);
- opt2 = rs.getString(4);
- request.setAttribute("opt2", opt2);
- opt3 = rs.getString(5);
- request.setAttribute("opt3", opt3);
- opt4 = rs.getString(6);
- request.setAttribute("opt4", opt4);
- RequestDispatcher rd = request.getRequestDispatcher("/welcome.jsp");
- rd.forward(request, response);
- }
- } catch (Exception e) {
- out.print(e);
- }
Add Comment
Please, Sign In to add comment