Advertisement
Guest User

Untitled

a guest
Jul 3rd, 2017
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.08 KB | None | 0 0
  1. <tr>
  2. <td>Q. No.</td>
  3. <td>Questions</td>
  4. <td>Excellent</td>
  5. <td>Better</td>
  6. <td>Good</td>
  7. <td>Poor</td>
  8. </tr>
  9. <%
  10. try{
  11. Class.forName("com.mysql.jdbc.Driver");
  12. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/feedback","root", "");
  13. Statement st = con.createStatement();
  14. ResultSet rs;
  15.  
  16. if(count>0){
  17. rs = st.executeQuery("select * from question");
  18. while(rs.next()){
  19. int qno= rs.getInt(1);
  20. String qname= rs.getString(2);
  21. %>
  22. <tr>
  23. <td class="member"><%=qno %></td>
  24. <td class="member"><%=qname %></td>
  25. <td><input name="<%=qno %>" type="radio" value="1" required="true"/></td>
  26. <td><input name="<%=qno %>" type="radio" value="2" required="true"/></td>
  27. <td><input name="<%=qno %>" type="radio" value="3" required="true"/></td>
  28. <td><input name="<%=qno %>" type="radio" value="4" required="true"/></td>
  29. </tr>
  30. <%
  31. }%>
  32. <tr>
  33. <td><input type="submit" value="Submit" /></td>
  34. <td><input type="reset" value="Reset" /></td>
  35. </tr>
  36.  
  37. <tr>
  38. <td>1</td>
  39. <td>How is your faculty communication</td>
  40. <td><input name="1" type="radio" value="1" required="true"/></td>
  41. <td><input name="1" type="radio" value="2" required="true"/></td>
  42. <td><input name="1" type="radio" value="3" required="true"/></td>
  43. <td><input name="1" type="radio" value="4" required="true"/></td>
  44. </tr>
  45. <tr>
  46. <td>2</td>
  47. <td>How is your study matrial</td>
  48. <td><input name="2" type="radio" value="1" required="true"/></td>
  49. <td><input name="2" type="radio" value="2" required="true"/></td>
  50. <td><input name="2" type="radio" value="3" required="true"/></td>
  51. <td><input name="2" type="radio" value="4" required="true"/></td>
  52. </tr>
  53. <tr>
  54. <td>3</td>
  55. <td>How your faculty language</td>
  56. <td><input name="3" type="radio" value="1" required="true"/></td>
  57. <td><input name="3" type="radio" value="2" required="true"/></td>
  58. <td><input name="3" type="radio" value="3" required="true"/></td>
  59. <td><input name="3" type="radio" value="4" required="true"/></td>
  60. </tr>
  61.  
  62. int totque=0;
  63. rs = st.executeQuery("select * from question");
  64. while(rs.next()){
  65. ++totque;
  66. int qno= rs.getInt(1);
  67. String qname= rs.getString(2);
  68. String qnos=Integer.toString(qno);
  69. %>
  70. <tr>
  71. <td class="member"><%=qnos %></td>
  72. <td class="member"><%=qname %></td>
  73. <td><input name="<%=qnos %>" type="radio" value="1" required/></td>
  74. <td><input name="<%=qnos %>" type="radio" value="2" required/></td>
  75. <td><input name="<%=qnos %>" type="radio" value="3" required/></td>
  76. <td><input name="<%=qnos %>" type="radio" value="4" required/></td>
  77. </tr>
  78. <%
  79. }%>
  80. <tr>
  81. <td>&nbsp;</td>
  82. <td>&nbsp;</td>
  83. <td>&nbsp;</td>
  84. <td><input type="hidden" id="thisField" name="inputName" value="<%=totque %>"></td>
  85. <td><input type="submit" value="Submit" /></td>
  86. <td><input type="reset" value="Reset" /></td>
  87. </tr>
  88.  
  89. <% String hidden = request.getParameter("inputName");
  90. int j=Integer.parseInt(hidden);
  91. %>
  92.  
  93. <% String s[] = new String[j];
  94. int k=0;
  95. for (int i=0; i<j; i++){
  96. k++;
  97. s[i] = request.getParameter(Integer.toString(k));
  98. out.println(s[i]);
  99. }%>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement