Facebook
From deandong, 9 Months ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 273
  1. out.println("<tr><td>"+res.getString(1)+"</td>");
  2.  
  3. out.println("<td>"+res.getString(2)+"</td></tr>");
  4.  
  5. out.println("<tr><td>&lt;input type=radio name="+qno+"
  6.  
  7. value="+res.getString(3)+"&gt;&lt;/td><td>"+res.getString(3)+"</td></tr>");
  8.  
  9. out.println("<tr><td>&lt;input type=radio name="+qno+"
  10.  
  11. value="+res.getString(4)+"&gt;&lt;/td><td>"+res.getString(4)+"</td></tr>");
  12.  
  13. out.println("<tr><td>&lt;input type=radio name="+qno+"
  14.  
  15. value="+res.getString(5)+"&gt;&lt;/td><td>"+res.getString(5)+"</td></tr>");
  16.  
  17. out.println("<tr><td>&lt;input type=radio name="+qno+"
  18.  
  19. value="+res.getString(6)+"&gt;&lt;/td><td>"+res.getString(6)+"</td></tr>");
  20.  
  21. }
  22.  
  23. }catch(Exception e) {out.println(e);}
  24.  
  25. out.println("</table>");
  26.  
  27. out.println("&lt;input type=reset&gt;");
  28.  
  29. out.println("&lt;input type=submit value=SUBMIT &gt;");
  30.  
  31. out.println("&lt;/form&gt;");
  32.  
  33. }}
  34.  
  35. ShowResult.java-
  36.  
  37. package mypack;
  38.  
  39. import java.io.*;
  40.  
  41. import java.sql.*;
  42.  
  43. import javax.servlet.*;
  44.  
  45. import javax.servlet.http.*;
  46.  
  47. public class ShowResult extends HttpServlet {
  48.  
  49. public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  50.  
  51. response.setContentType("text/html;charset=UTF-8");
  52.  
  53. PrintWriter out = response.getWriter();
  54. public class ShowResult extends HttpServlet {
  55.  
  56. public void doGet(HttpServletRequest request, HttpServletResponse response)
  57.  
  58. throws ServletException, IOException {
  59.  
  60. response.setContentType("text/html;charset=UTF-8");
  61.  
  62. PrintWriter out = response.getWriter();
  63.  
  64. try {
  65.  
  66. Class.forName("com.mysql.jdbc.Driver");
  67.  
  68. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/qadb", "root","root");
  69.  
  70. Statement stmt = con.createStatement();
  71.  
  72. ResultSet res = stmt.executeQuery("select ans from quiz");
  73.  
  74. int count =0, qno=0;
  75.  
  76. while(res.next()) {
  77.  
  78. if(res.getString(1).equals(request.getParameter("""+(++qno))))
  79.  
  80. { count++;
  81.  
  82. out.println("<h1>Correct </h1>");
  83.  
  84. }
  85.  
  86. else {
  87.  
  88. out.println("<h1>Incorrect </h1>");
  89.  
  90. }
  91.  
  92. }
  93.  
  94. out.println("<h1>Your Score is "+count+" </h1>");
  95.  
  96. }catch(Exception e) {out.println(e);}}}