API tools faq
paste
Advertisement
Guest User

result_view.jsp

a guest
Feb 10th, 2016
93
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.11 KB | None | 0 0
raw download clone embed print report
  1. <%--
  2. Document : result_view
  3. Created on : 3 Jan, 2016, 1:55:40 PM
  4. Author : Tarequzzaman
  5. --%>
  6.  
  7. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  8. <!DOCTYPE html>
  9. <html>
  10. <head>
  11. <meta charset="utf-8">
  12. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  13. <meta name="viewport" content="width=device-width, initial-scale=1">
  14. <link href="css/bootstrap.min.css" rel="stylesheet">
  15.  
  16. <title>Result View</title>
  17.  
  18.  
  19. </head>
  20.  
  21. <%
  22. session.setAttribute("log", "logged");
  23. %>
  24. <body >
  25. <nav class="navbar navbar-inverse navbar-fixed-top" id="mynavbar">
  26. <div class="container-fluid">
  27. <div class="navbar-header">
  28.  
  29. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#navbar-collapse">
  30. <span class="icon-bar"></span>
  31. <span class="icon-bar"></span>
  32. <span class="icon-bar"></span>
  33. <span class="icon-bar"></span>
  34. </button>
  35. <a href="home.jsp" class="navbar-brand">SEC</a>
  36. </div>
  37.  
  38. <div class="collapse navbar-collapse" id="navbar-collapse">
  39. <ul class="nav navbar-nav" >
  40. <li><a href="#">Home</a> </li>
  41. <li><a href="#">Photo Gallary</a> </li>
  42. <li><a href="#">Student Profile</a> </li>
  43. <li><a href="templete.jsp">Result</a> </li>
  44. <li><a href="#">About us</a> </li>
  45. <li><a href="#">Contact</a> </li>
  46.  
  47. </ul>
  48. </div>
  49. </div>
  50. </nav>
  51. <div class="jumbotron">
  52. <header>
  53. <div class="container-fluid">
  54.  
  55. <hr>
  56. <div class="row">
  57. <div class="col-lg-12">
  58. <div class="col-sm-1">
  59. <div class="img-responsive">
  60. <a href="templete.jsp"> <img src="image/bd_logo.png" /></a>
  61. </div>
  62. </div>
  63. <div class="col-sm-10">
  64. <h1>Sylhet Engineering College</h1>
  65. </div>
  66. </div>
  67. </div>
  68. </div>
  69. </header>
  70. </div>
  71. <%
  72. String name = (String) request.getAttribute("name");
  73. String reg_no = (String) request.getAttribute("reg");
  74. String session_ = (String) request.getAttribute("session");
  75. String semest = (String) request.getParameter("semester");
  76. int semester = Integer.parseInt(semest);
  77. %>
  78.  
  79.  
  80.  
  81. <section>
  82. <div class="container">
  83. <div class="col-lg-2">
  84.  
  85. </div>
  86.  
  87. <div class="col-lg-8">
  88.  
  89. <div class="row text-center">
  90.  
  91.  
  92. <br>
  93. <br>
  94. </div>
  95. <div class="raw">
  96. <div>
  97. <label>Name :<%=name%></label>
  98. </div>
  99. <div>
  100. <label>Registration No : <%=reg_no%></label>
  101. </div>
  102. <div>
  103. <label>Semester : <%=semester%></label>
  104. </div>
  105.  
  106. <div>
  107. <label >session : <%=session_%> </label>
  108. </div>
  109. </div>
  110.  
  111. <div>
  112. <table class="table table-bordered table-hover table-responsive text-center">
  113. <tr class="info">
  114. <th class="text-center">Subject</th>
  115. <th class="text-center">GPA</th>
  116. </tr>
  117. <%
  118. double total_credit = 0;
  119. double marks_credit = 0;
  120. %>
  121. <%!
  122. double gpacalculate(double marks) {
  123. double cra = 0;
  124. if (marks >= 80) {
  125. cra = 4.00;
  126. } else if (marks >= 75 && marks <= 79) {
  127. cra = 3.75;
  128. } else if (marks >= 70 && marks <= 74) {
  129. cra = 3.50;
  130. } else if (marks >= 65 && marks >= 69) {
  131. cra = 3.25;
  132. } else if (marks >= 60 && marks >= 64) {
  133. cra = 3.00;
  134. } else if (marks >= 55 && marks >= 59) {
  135. cra = 2.75;
  136. } else if (marks >= 50 && marks >= 54) {
  137. cra = 2.50;
  138. } else if (marks >= 45 && marks >= 49) {
  139. cra = 2.25;
  140. } else if (marks >= 40 && marks >= 44) {
  141. cra = 2.00;
  142. }
  143. return cra;
  144. }
  145. %>
  146. <%@ page import ="java.sql.*" %>
  147. <%
  148. try {
  149. // out.print("<p>-"+registration+"-</p>");
  150. Class.forName("oracle.jdbc.driver.OracleDriver");
  151. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "pro", "sec");
  152. long registration_no = Long.parseLong(reg_no);
  153. ResultSet rs, rs1, rs2;
  154. String sql1, sql2, sql3;
  155. sql1 = "select course_id,marks_TT,marks_partB,marks_partA ,credit from partB join partA using (course_id,registration_no,semester,session_) join Termtest using (course_id,registration_no,semester,session_) join course using (course_id)where semester=" + semester + " and session_='" + session_ + "' and registration_no=" + registration_no + " order by course_id";
  156.  
  157. Statement st = con.createStatement();
  158. rs = st.executeQuery(sql1);
  159. while (rs.next()) {
  160. out.println("<tr>");
  161. String course_id = rs.getString(1);
  162. out.println("<td>" + course_id + "</td>");
  163. float markstt = rs.getFloat(2);
  164. float markspb = rs.getFloat(3);
  165. float markspa = rs.getFloat(4);
  166. double marks = markstt + markspa + markspb;
  167. double gpa;
  168. if (marks >= 40) {
  169. gpa = gpacalculate(marks);
  170. float credit = rs.getFloat(5);
  171. total_credit += credit;
  172. marks_credit += credit * gpa;
  173.  
  174. } else {
  175. gpa = 0.00;
  176. }
  177. out.println("<td>" + gpa + "</td>");
  178.  
  179. out.println("</tr>");
  180. }
  181. sql2 = "select course_id ,marks_lab ,credit from Lab join course using (course_id) where registration_no=" + registration_no + " and semester=" + semester + " and session_='" + session_ + "' order by course_id";
  182. rs = st.executeQuery(sql2);
  183.  
  184.  
  185. while (rs.next()) {
  186. out.println("<tr >");
  187. String course_id = rs.getString(1);
  188. out.println("<td>" + course_id + "</td>");
  189.  
  190. float markslb = rs.getFloat(2);
  191. double marks = markslb;
  192. double gpa;
  193. if (marks >= 40) {
  194. gpa = gpacalculate(marks);
  195. float credit = rs.getFloat(3);
  196. total_credit += credit;
  197. marks_credit += credit * gpa;
  198.  
  199. } else {
  200. gpa = 0.00;
  201. }
  202. out.println("<td>" + gpa + "</td>");
  203.  
  204. out.println("</tr>");
  205. }
  206.  
  207. sql3 = "select course_id from absent where registration_no=" + registration_no + " and semester=" + semester + " and session_='" + session_ + "'";
  208.  
  209. while (rs.next()) {
  210. out.println("<tr>");
  211. String course_id = rs.getString(1);
  212. out.println("<td>" + course_id + "</td>");
  213.  
  214.  
  215. double gpa = 0.00;
  216.  
  217. out.println("<td>" + gpa + "</td>");
  218.  
  219. out.println("</tr>");
  220. }
  221. } catch (Exception e) {
  222. out.println("" + e);
  223. %>
  224.  
  225. <% }
  226. %>
  227. <tr class="active">
  228.  
  229. <td>CGPA </td>
  230. <%
  231. double gpa = marks_credit / total_credit;
  232. String s = "" + gpa;
  233. char ch[] = s.toCharArray();
  234. int length = s.length();
  235. int m = ch[6] - 48;
  236.  
  237. if (m == 9) {
  238. ch[5] = '0';
  239. int l = ch[4] - 48;
  240. l = l + 1 + 48;
  241. ch[4] = (char) l;
  242.  
  243. } else if (m > 5) {
  244. int l = ch[5] - 48;
  245. l = l + 1 + 48;
  246. char ch1 = (char) l;
  247. ch[5] = ch1;
  248.  
  249. }
  250.  
  251.  
  252. String res = "";
  253. for (int i = 0; i <= 5; i++) {
  254. res += ch[i];
  255. }
  256. out.println("<td>" + res + "</td>");
  257.  
  258. %>
  259. </tr>
  260.  
  261. <tr class="info">
  262.  
  263. <td>Total CGPA </td>
  264.  
  265.  
  266.  
  267. <%
  268. semester = semester - 1;
  269. while (semester > 0) {
  270.  
  271.  
  272. try {
  273.  
  274. Class.forName("oracle.jdbc.driver.OracleDriver");
  275. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "pro", "sec");
  276. long registration_no = Long.parseLong(reg_no);
  277. ResultSet rs;
  278. Statement st = con.createStatement();
  279. String sql = "select course_id,marks_TT,marks_partB,marks_partA ,credit from partB join partA using (course_id,registration_no,semester,session_) join Termtest using (course_id,registration_no,semester,session_) join course using (course_id)where semester=" + semester + " and session_='" + session_ + "' and registration_no=" + registration_no + " order by course_id";
  280. rs = st.executeQuery(sql);
  281. while (rs.next()) {
  282.  
  283. String course_id = rs.getString(1);
  284.  
  285. float markstt = rs.getFloat(2);
  286. float markspb = rs.getFloat(3);
  287. float markspa = rs.getFloat(4);
  288. double marks = markstt + markspa + markspb;
  289. double gpa1;
  290. if (marks >= 40) {
  291. gpa1 = gpacalculate(marks);
  292. float credit = rs.getFloat(5);
  293. total_credit += credit;
  294. marks_credit += credit * gpa1;
  295.  
  296. }
  297.  
  298. }
  299.  
  300. sql = "select course_id ,marks_lab ,credit from Lab join course using (course_id) where registration_no=" + registration_no + " and semester=" + semester + " and session_='" + session_ + "'";
  301. rs = st.executeQuery(sql);
  302. while (rs.next()) {
  303.  
  304. String course_id = rs.getString(1);
  305.  
  306.  
  307. float markslb = rs.getFloat(2);
  308. double marks = markslb;
  309. double gpa2;
  310. if (marks >= 40) {
  311. gpa2 = gpacalculate(marks);
  312. float credit = rs.getFloat(3);
  313. total_credit += credit;
  314. marks_credit += credit * gpa2;
  315.  
  316. }
  317.  
  318. }
  319.  
  320. } catch (Exception ex) {
  321. }
  322. semester = semester - 1;
  323.  
  324. }
  325. double cgpa = marks_credit / total_credit;
  326. String s1 = "" + cgpa;
  327. char ch1[] = s1.toCharArray();
  328. if (m == 9) {
  329. ch1[5] = '0';
  330. int l = ch1[4] - 48;
  331. l = l + 1 + 48;
  332. ch1[4] = (char) l;
  333.  
  334. } else if (m > 5) {
  335. int l = ch1[5] - 48;
  336. l = l + 1 + 48;
  337. char ch2 = (char) l;
  338. ch1[5] = ch2;
  339.  
  340. }
  341.  
  342.  
  343. String total_res = "";
  344. for (int i = 0; i <= 5; i++) {
  345. total_res += ch1[i];
  346. }
  347. out.println("<td>" + total_res + "</td>");
  348.  
  349. %>
  350. </tr>
  351. </table>
  352. </div>
  353. </div>
  354. </div>
  355.  
  356. <div class="col-lg-2">
  357.  
  358. </div>
  359.  
  360.  
  361.  
  362. </section>
  363.  
  364.  
  365.  
  366.  
  367.  
  368. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
  369. <script src="js/bootstrap.min.js"></script>
  370. </body>
  371. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!