-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsviewtachievements1.jsp
96 lines (83 loc) · 3.18 KB
/
sviewtachievements1.jsp
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Development of Online College Year Book</title>
<link rel="stylesheet" href="style.css">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr" crossorigin="anonymous">
</head>
<body>
<!-- Main Header -->
<header class="main-header">
<center><h1>Development of Online College Year Book</h1></center>
</header>
<!-- Dropdown Navbar -->
<nav>
<ul>
<li><a href="studenthome.jsp">Home</a></li>
<li><a href="supdateprofile.jsp">Update Profile</a></li>
<li><a href="sviewachievements.jsp" class="active">View Achievements</a></li>
<li><a href="logout.jsp">Logout</a></li>
</ul>
</nav>
<!-- Login Form -->
<%@page import="java.sql.*"%>
<%@ include file="connect.jsp" %>
<%@ page session="true" %>
<%
String year = request.getParameter("year");
String branch = request.getParameter("branch");
String sql="select * from teacherevents where yr = '"+year+"' and branch = '"+branch+"'";
Statement st=connection.createStatement();
ResultSet rs=st.executeQuery(sql);
if(rs.next()){
String sql2="select * from teacherevents where yr = '"+year+"' and branch = '"+branch+"'";
Statement st2=connection.createStatement();
ResultSet rs1=st2.executeQuery(sql2);
%>
<br/><br/>
<center>
<h2><font color="black" size="5"> Teacher Achievements</font></h2>
<style>
td{
text-align: center;
height: 25px;
}
th{
text-align: center;
height: 25px;
}
</style>
<table border="2" width="90%">
<tr style="background-color: brown">
<th><font color="black"> Name</th>
<th><font color="black">Year</th>
<th><font color="black">Branch</th>
<th><font color="black">View Details</th>
</tr>
<% while (rs1.next()) {
%>
<tr>
<td><font color="black"><%=rs1.getString("username")%></td>
<td><font color="black"><%=rs1.getString("yr")%></td>
<td><font color="black"><%=rs1.getString("branch")%></td>
<td><a href="sviewtachievements2.jsp?username=<%=rs1.getString("username")%>&year=<%=rs1.getString("yr")%>&branch=<%=rs1.getString("branch")%>"><button type="button">View Details</button></a></td>
</tr>
<%
}
}
else{
out.println("<br/><br/><br/><br/><br/><center><font color='red' size='5'>No Achievements to Display...</font></center> ");
}
%>
</table>
<br/><br/><a href="sviewtachievements.jsp"><button type="button">Back</button></a>
</center>
<br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/><br/>
<br>
<!-- Main Footer -->
<footer class="main-footer">
<p>Developed by <a href="https://www.1000projects.org" target="_blank"> 1000Projects </a></p>
</footer>
</body>
</html>