API tools faq
paste
Guest User

Untitled

a guest
Aug 17th, 2018
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.53 KB | None | 0 0
raw download clone embed print report
  1. j<html>
  2. <head>
  3.  
  4. </head>
  5. <body>
  6. <p>Oppg. 1<br/>
  7. a)+b)<br/>
  8. Skjema for godkjente øvinger:
  9. <form action = "oeving9.jsp" method = "get">
  10. <input type = "checkbox" name = "oving1" value = "true"/>Øving1<br/>
  11. <input type = "checkbox" name = "oving2" value = "true"/>Øving2<br/>
  12. <input type = "checkbox" name = "oving3" value = "true"/>Øving3<br/>
  13. <input type = "checkbox" name = "oving4" value = "true"/>Øving4<br/>
  14. <input type = "checkbox" name = "oving5" value = "true"/>Øving5<br/>
  15. <input type = "checkbox" name = "oving6" value = "true"/>Øving6<br/>
  16. <input type = "checkbox" name = "oving7" value = "true"/>Øving7<br/>
  17. <input type = "checkbox" name = "oving8" value = "true"/>Øving8<br/>
  18. <input type = "checkbox" name = "oving9" value = "true"/>Øving9<br/>
  19. <input type = "checkbox" name = "oving10" value = "true"/>Øving10<br/>
  20. <input type = "checkbox" name = "oving11" value = "true"/>Øving11<br/>
  21. <input type="submit" value="Send"/><br/></form>
  22. <%!
  23. boolean oving(String a) {
  24. if (a == null) {
  25. return false;
  26. }
  27. if (a.equals("true")) {
  28. return true;
  29. } else {
  30. return false;
  31. }
  32. }
  33. String boid(String a) {
  34. if (request.getParameter(a) == null) {
  35. return (a = "0");
  36. }
  37. if ((request.getParameter(a) !== null)) {
  38. return a;
  39. }
  40. }
  41. int antallGodkjente(String a, String b, String c, String d, String e, String f, String g, String h, String i) {
  42. int antall = 0;
  43. if (oving(a)) {
  44. antall = antall + 1;
  45. }
  46. if (oving(b)) {
  47. antall = antall + 1;
  48. }
  49. if (oving(c)) {
  50. antall = antall + 1;
  51. }
  52. if (oving(d)) {
  53. antall = antall + 1;
  54. }
  55. if (oving(e)) {
  56. antall = antall + 1;
  57. }
  58. if (oving(f)) {
  59. antall = antall + 1;
  60. }
  61. if (oving(g)) {
  62. antall = antall + 1;
  63. }
  64. if (oving(h)) {
  65. antall = antall + 1;
  66. }
  67. if (oving(i)) {
  68. antall = antall + 1;
  69. }
  70. if (oving(i)) {
  71. antall = antall + 1;
  72. }
  73. return antall;
  74. }
  75. %>
  76. <%
  77. if (oving(request.getParameter("oving1"))) {
  78. out.println("Øving1 er gjort<br/>");
  79. }
  80. if (oving(request.getParameter("oving2"))) {
  81. out.println("Øving2 er gjort<br/>");
  82. }
  83. if (oving(request.getParameter("oving3"))) {
  84. out.println("Øving3 er gjort<br/>");
  85. }
  86. if (oving(request.getParameter("oving4"))) {
  87. out.println("Øving4 er gjort<br/>");
  88. }
  89. if (oving(request.getParameter("oving5"))) {
  90. out.println("Øving5 er gjort<br/>");
  91. }
  92. if (oving(request.getParameter("oving6"))) {
  93. out.println("Øving6 er gjort<br/>");
  94. }
  95. if (oving(request.getParameter("oving7"))) {
  96. out.println("Øving7 er gjort<br/>");
  97. }
  98. if (oving(request.getParameter("oving8"))) {
  99. out.println("Øving8 er gjort<br/>");
  100. }
  101. if (oving(request.getParameter("oving9"))) {
  102. out.println("Øving9 er gjort<br/>");
  103. }
  104. if (oving(request.getParameter("oving10"))) {
  105. out.println("Øving10 er gjort<br/>");
  106. }
  107. if (oving(request.getParameter("oving11"))) {
  108. out.println("Øving11 er gjort<br/>");
  109. }
  110. if ((oving(request.getParameter("oving4")) || oving(request.getParameter("oving10"))) && ((
  111. oving(request.getParameter("oving1")) && oving(request.getParameter("oving2")) &&
  112. oving(request.getParameter("oving3")) && oving(request.getParameter("oving5")) &&
  113. oving(request.getParameter("oving6")) && oving(request.getParameter("oving7")) &&
  114. oving(request.getParameter("oving8"))) || (oving(request.getParameter("oving2")) &&
  115. oving(request.getParameter("oving3")) && oving(request.getParameter("oving5")) &&
  116. oving(request.getParameter("oving6")) && oving(request.getParameter("oving7")) &&
  117. oving(request.getParameter("oving8")) && oving(request.getParameter("oving9"))) ||
  118. (oving(request.getParameter("oving3")) && oving(request.getParameter("oving5")) &&
  119. oving(request.getParameter("oving6")) && oving(request.getParameter("oving7")) &&
  120. oving(request.getParameter("oving8")) && oving(request.getParameter("oving9")) &&
  121. oving(request.getParameter("oving11"))) || oving(request.getParameter("oving1")) &&
  122. oving(request.getParameter("oving2")) && oving(request.getParameter("oving3")) &&
  123. oving(request.getParameter("oving5")) && oving(request.getParameter("oving6")) &&
  124. oving(request.getParameter("oving7")) && oving(request.getParameter("oving9")))) {
  125. out.println("Nok øvinger er godkjent<br/>");
  126. } else {
  127. out.println("Ikke nok øvinger er godkjent<br/>");
  128. }
  129. if (!oving(request.getParameter("oving4")) && !oving(request.getParameter("oving10"))) {
  130. out.println("Du mangler en godkjent auditorieøving.<br/>");
  131. }
  132. if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  133. (request.getParameter("oving3")), (request.getParameter("oving5")),
  134. (request.getParameter("oving6")), (request.getParameter("oving7")),
  135. (request.getParameter("oving8")), (request.getParameter("oving9")),
  136. (request.getParameter("oving11"))) == 0) {
  137. out.println("Du mangler 7 øvinger som ikke er auditorieøvinger.");
  138. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  139. (request.getParameter("oving3")), (request.getParameter("oving5")),
  140. (request.getParameter("oving6")), (request.getParameter("oving7")),
  141. (request.getParameter("oving8")), (request.getParameter("oving9")),
  142. (request.getParameter("oving11"))) == 1) {
  143. out.println("Du mangler 6 øvinger som ikke er auditorieøvinger.");
  144. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  145. (request.getParameter("oving3")), (request.getParameter("oving5")),
  146. (request.getParameter("oving6")), (request.getParameter("oving7")),
  147. (request.getParameter("oving8")), (request.getParameter("oving9")),
  148. (request.getParameter("oving11"))) == 2) {
  149. out.println("Du mangler 5 øvinger som ikke er auditorieøvinger.");
  150. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  151. (request.getParameter("oving3")), (request.getParameter("oving5")),
  152. (request.getParameter("oving6")), (request.getParameter("oving7")),
  153. (request.getParameter("oving8")), (request.getParameter("oving9")),
  154. (request.getParameter("oving11"))) == 3) {
  155. out.println("Du mangler 4 øvinger som ikke er auditorieøvinger.");
  156. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  157. (request.getParameter("oving3")), (request.getParameter("oving5")),
  158. (request.getParameter("oving6")), (request.getParameter("oving7")),
  159. (request.getParameter("oving8")), (request.getParameter("oving9")),
  160. (request.getParameter("oving11"))) == 4) {
  161. out.println("Du mangler 3 øvinger som ikke er auditorieøvinger.");
  162. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  163. (request.getParameter("oving3")), (request.getParameter("oving5")),
  164. (request.getParameter("oving6")), (request.getParameter("oving7")),
  165. (request.getParameter("oving8")), (request.getParameter("oving9")),
  166. (request.getParameter("oving11"))) == 5) {
  167. out.println("Du mangler 2 øvinger som ikke er auditorieøvinger.");
  168. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  169. (request.getParameter("oving3")), (request.getParameter("oving5")),
  170. (request.getParameter("oving6")), (request.getParameter("oving7")),
  171. (request.getParameter("oving8")), (request.getParameter("oving9")),
  172. (request.getParameter("oving11"))) == 6) {
  173. out.println("Du mangler 1 øving som ikke er auditorieøving.");
  174. }
  175. %></p>
  176. <p> Oppg. 2<br/>
  177. a)<br/>
  178. create table poeng(kandidatnummer int primary key auto_increment, poengsum int);<br/>
  179. b)<br/>
  180. <%@page import = "java.sql.*" %>
  181. <%
  182. Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  183. Connection db = java.sql.DriverManager.getConnection(
  184. "jdbc:mysql://mysql.stud.ntnu.no/chrischa_itgkdb","chrischa_adm","chrischa_adm");
  185. Statement st = db.createStatement();
  186. ResultSet rs = st.executeQuery("select * from poeng ORDER BY kandidatnummer");
  187. out.println("<table border = \"1\"><tr><td>Kandidatnummer</td><td>Poengsum</td></tr>");
  188. while(rs.next()){
  189. int kandidatnummer = rs.getInt("kandidatnummer");
  190. int poengsum = rs.getInt("poengsum");
  191. out.println("<tr><td>"+kandidatnummer+"</td><td>"+poengsum+"</td></tr>");
  192. }
  193. out.println("</table>");
  194. %>
  195.  
  196. <form action = "oeving9.jsp" method = "get">
  197. <table border = "1"><tr><td>Kandidatnummer:</td><td>Oppg.1</td><td>Oppg.2</td><td>Oppg.3</td><td>Oppg.4</td><td>Oppg.5</td><td>Oppg.6</td><td>Oppg.7</td><td>Oppg.8</td><td>Oppg.9</td><td>Oppg.10</td></tr>
  198. <tr><td><input = "text" name = "a"></td><td><input = "text" name = "1"></td><td><input = "text" name = "2"></td><td><input = "text" name = "3"></td><td><input = "text" name = "4"></td><td><input = "text" name = "5"></td>
  199. <td><input = "text" name = "6"></td><td><input = "text" name = "7"></td><td><input = "text" name = "8"></td><td><input = "text" name = "9"></td><td><input = "text" name = "10"></td></tr></table>
  200. <input type = "reset" value = "Tøm felt">
  201. <input type = "submit" value = "Send inn">
  202. <%
  203. String a;
  204. String b;
  205. String c;
  206. String d;
  207. String e;
  208. String f;
  209. String g;
  210. String h;
  211. String i;
  212. String j;
  213. String k;
  214. db.close();
  215. %>
  216. </body>
  217. </html>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!