API tools faq
paste
Guest User

Untitled

a guest
Aug 17th, 2018
137
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.09 KB | None | 0 0
raw download clone embed print report
  1. <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 (a == null) {
  35. return "0";
  36. } else {
  37. return a;
  38. }
  39. }
  40. int antallGodkjente(String a, String b, String c, String d, String e, String f, String g, String h, String i) {
  41. int antall = 0;
  42. if (oving(a)) {
  43. antall = antall + 1;
  44. }
  45. if (oving(b)) {
  46. antall = antall + 1;
  47. }
  48. if (oving(c)) {
  49. antall = antall + 1;
  50. }
  51. if (oving(d)) {
  52. antall = antall + 1;
  53. }
  54. if (oving(e)) {
  55. antall = antall + 1;
  56. }
  57. if (oving(f)) {
  58. antall = antall + 1;
  59. }
  60. if (oving(g)) {
  61. antall = antall + 1;
  62. }
  63. if (oving(h)) {
  64. antall = antall + 1;
  65. }
  66. if (oving(i)) {
  67. antall = antall + 1;
  68. }
  69. return antall;
  70. }
  71. %>
  72. <%
  73. if (oving(request.getParameter("oving1"))) {
  74. out.println("Øving1 er gjort<br/>");
  75. }
  76. if (oving(request.getParameter("oving2"))) {
  77. out.println("Øving2 er gjort<br/>");
  78. }
  79. if (oving(request.getParameter("oving3"))) {
  80. out.println("Øving3 er gjort<br/>");
  81. }
  82. if (oving(request.getParameter("oving4"))) {
  83. out.println("Øving4 er gjort<br/>");
  84. }
  85. if (oving(request.getParameter("oving5"))) {
  86. out.println("Øving5 er gjort<br/>");
  87. }
  88. if (oving(request.getParameter("oving6"))) {
  89. out.println("Øving6 er gjort<br/>");
  90. }
  91. if (oving(request.getParameter("oving7"))) {
  92. out.println("Øving7 er gjort<br/>");
  93. }
  94. if (oving(request.getParameter("oving8"))) {
  95. out.println("Øving8 er gjort<br/>");
  96. }
  97. if (oving(request.getParameter("oving9"))) {
  98. out.println("Øving9 er gjort<br/>");
  99. }
  100. if (oving(request.getParameter("oving10"))) {
  101. out.println("Øving10 er gjort<br/>");
  102. }
  103. if (oving(request.getParameter("oving11"))) {
  104. out.println("Øving11 er gjort<br/>");
  105. }
  106. if ((oving(request.getParameter("oving4")) || oving(request.getParameter("oving10"))) && ((
  107. oving(request.getParameter("oving1")) && oving(request.getParameter("oving2")) &&
  108. oving(request.getParameter("oving3")) && oving(request.getParameter("oving5")) &&
  109. oving(request.getParameter("oving6")) && oving(request.getParameter("oving7")) &&
  110. oving(request.getParameter("oving8"))) || (oving(request.getParameter("oving2")) &&
  111. oving(request.getParameter("oving3")) && oving(request.getParameter("oving5")) &&
  112. oving(request.getParameter("oving6")) && oving(request.getParameter("oving7")) &&
  113. oving(request.getParameter("oving8")) && oving(request.getParameter("oving9"))) ||
  114. (oving(request.getParameter("oving3")) && oving(request.getParameter("oving5")) &&
  115. oving(request.getParameter("oving6")) && oving(request.getParameter("oving7")) &&
  116. oving(request.getParameter("oving8")) && oving(request.getParameter("oving9")) &&
  117. oving(request.getParameter("oving11"))) || oving(request.getParameter("oving1")) &&
  118. oving(request.getParameter("oving2")) && oving(request.getParameter("oving3")) &&
  119. oving(request.getParameter("oving5")) && oving(request.getParameter("oving6")) &&
  120. oving(request.getParameter("oving7")) && oving(request.getParameter("oving9")))) {
  121. out.println("Nok øvinger er godkjent<br/>");
  122. } else {
  123. out.println("Ikke nok øvinger er godkjent<br/>");
  124. }
  125. if (!oving(request.getParameter("oving4")) && !oving(request.getParameter("oving10"))) {
  126. out.println("Du mangler en godkjent auditorieøving.<br/>");
  127. }
  128. if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  129. (request.getParameter("oving3")), (request.getParameter("oving5")),
  130. (request.getParameter("oving6")), (request.getParameter("oving7")),
  131. (request.getParameter("oving8")), (request.getParameter("oving9")),
  132. (request.getParameter("oving11"))) == 0) {
  133. out.println("Du mangler 7 øvinger som ikke er auditorieøvinger.");
  134. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  135. (request.getParameter("oving3")), (request.getParameter("oving5")),
  136. (request.getParameter("oving6")), (request.getParameter("oving7")),
  137. (request.getParameter("oving8")), (request.getParameter("oving9")),
  138. (request.getParameter("oving11"))) == 1) {
  139. out.println("Du mangler 6 øvinger som ikke er auditorieøvinger.");
  140. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  141. (request.getParameter("oving3")), (request.getParameter("oving5")),
  142. (request.getParameter("oving6")), (request.getParameter("oving7")),
  143. (request.getParameter("oving8")), (request.getParameter("oving9")),
  144. (request.getParameter("oving11"))) == 2) {
  145. out.println("Du mangler 5 øvinger som ikke er auditorieøvinger.");
  146. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  147. (request.getParameter("oving3")), (request.getParameter("oving5")),
  148. (request.getParameter("oving6")), (request.getParameter("oving7")),
  149. (request.getParameter("oving8")), (request.getParameter("oving9")),
  150. (request.getParameter("oving11"))) == 3) {
  151. out.println("Du mangler 4 øvinger som ikke er auditorieøvinger.");
  152. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  153. (request.getParameter("oving3")), (request.getParameter("oving5")),
  154. (request.getParameter("oving6")), (request.getParameter("oving7")),
  155. (request.getParameter("oving8")), (request.getParameter("oving9")),
  156. (request.getParameter("oving11"))) == 4) {
  157. out.println("Du mangler 3 øvinger som ikke er auditorieøvinger.");
  158. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  159. (request.getParameter("oving3")), (request.getParameter("oving5")),
  160. (request.getParameter("oving6")), (request.getParameter("oving7")),
  161. (request.getParameter("oving8")), (request.getParameter("oving9")),
  162. (request.getParameter("oving11"))) == 5) {
  163. out.println("Du mangler 2 øvinger som ikke er auditorieøvinger.");
  164. } else if (antallGodkjente((request.getParameter("oving1")),(request.getParameter("oving2")),
  165. (request.getParameter("oving3")), (request.getParameter("oving5")),
  166. (request.getParameter("oving6")), (request.getParameter("oving7")),
  167. (request.getParameter("oving8")), (request.getParameter("oving9")),
  168. (request.getParameter("oving11"))) == 6) {
  169. out.println("Du mangler 1 øving som ikke er auditorieøving.");
  170. }
  171. %></p>
  172. <p> Oppg. 2<br/>
  173. a)<br/>
  174. create table poeng(kandidatnummer int primary key auto_increment, poengsum int);<br/>
  175. b)+c)<br/>
  176. <%@page import = "java.sql.*" %>
  177. <%
  178. Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  179. Connection db = java.sql.DriverManager.getConnection(
  180. "jdbc:mysql://mysql.stud.ntnu.no/chrischa_itgkdb","chrischa_adm","chrischa_adm");
  181. Statement st = db.createStatement();
  182. ResultSet rs = st.executeQuery("select * from poeng ORDER BY kandidatnummer");
  183. out.println("<table border = \"1\"><form action = \"oeving9_1.jsp\" method = \"get\">");
  184. for (int q = -1; q<12; q++) {
  185. if (q == -1){
  186. out.println("<tr><th>Kandidatnummer:</th>");
  187. } else if (q == 0) {
  188. out.println("<th>Poengsum</th>");
  189. } else if (q == 11) {
  190. out.println("<th>Slette Kandidat?</th>");
  191. } else {
  192. out.println("<th>Poeng oppgave "+q+"</th>");
  193. }
  194. } out.println("</tr><tr>");
  195. while(rs.next()){
  196. int kandidatnummer = rs.getInt("kandidatnummer");
  197. int poengsum = rs.getInt("poengsum");
  198. int[] oppg = new int[10];
  199. for (int o = 0; o<10; o++) {
  200. oppg[o] = rs.getInt("oppg" + (o+1));
  201. }
  202. for (int p = -2; p<11; p++) {
  203. if (p == -2) {
  204. out.println("<tr><td>"+kandidatnummer+"</td>");
  205. } else if (p == -1) {
  206. out.println("<td>"+poengsum+"</td>");
  207. } else if (p == 10) {
  208. out.println("<td><center><input type = \"checkbox\" name = \"del"+kandidatnummer+"\" value = \"true\"/></center></td></tr>");
  209. } else out.println("<td>"+oppg[p]+"</td>");
  210. }
  211. }
  212. %>
  213. </table>
  214. <input type = "submit" value = "Slett valgte kandidater!" />
  215. </form>
  216. <form action = "oeving9.jsp" method = "get">
  217. <table border = "1">
  218. <%
  219. for (int i = 0; i<11; i++) {
  220. if (i == 0){
  221. out.println("<tr><th>Kandidatnummer:</th>");
  222. } else {
  223. out.println("<th>Poeng oppgave "+ i +"</th>");
  224. }
  225. } out.println("</tr><tr>");
  226. for (int u = 1; u<12; u++) {
  227. out.println("<td><input = \"text\" name = \"" + u + "\" /></td>");
  228. } out.println("</tr></table>");
  229. %>
  230. <input type = "hidden" name ="post" value="true" />
  231. <input type = "reset" value = "Tøm felt" />
  232. <input type = "submit" value = "Send inn" />
  233. </form>
  234. <%
  235. boolean post = false;
  236. if (boid(request.getParameter("post")) != "0" && request.getParameter("post").equals("true")) {
  237. post = true;
  238. }
  239. int a = Integer.parseInt(boid(request.getParameter("1")));
  240. int b = Integer.parseInt(boid(request.getParameter("2")));
  241. int c = Integer.parseInt(boid(request.getParameter("3")));
  242. int d = Integer.parseInt(boid(request.getParameter("4")));
  243. int e = Integer.parseInt(boid(request.getParameter("5")));
  244. int f = Integer.parseInt(boid(request.getParameter("6")));
  245. int g = Integer.parseInt(boid(request.getParameter("7")));
  246. int h = Integer.parseInt(boid(request.getParameter("8")));
  247. int i = Integer.parseInt(boid(request.getParameter("9")));
  248. int j = Integer.parseInt(boid(request.getParameter("10")));
  249. int k = Integer.parseInt(boid(request.getParameter("11")));
  250. String query = "insert into poeng(kandidatnummer, oppg1, oppg2, oppg3,oppg4, oppg5, oppg6, oppg7, oppg8, oppg9, oppg10, poengsum) values ("+ a +","+b+","+c+","+d+","+e+","+f+","+g+","+h+","+i+","+j+","+k+","+(b+c+d+e+f+g+h+i+j+k)+");";
  251. if (post) {
  252. st.executeUpdate(query);
  253. }
  254. %>
  255. d)<br/>
  256. <%
  257.  
  258. %>
  259. <%
  260. db.close();
  261. %>
  262.  
  263. </body>
  264. </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!