-
Notifications
You must be signed in to change notification settings - Fork 0
/
StuListFiles.jsp
119 lines (94 loc) · 3.58 KB
/
StuListFiles.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
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="w3.css">
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>List File Records</title>
</head>
<body>
<header class="w3-container w3-row w3-teal">
<div class="w3-col m4" >
<img src="jntuk.jpg" alt="jntuk logo" style="width:45%; height: 100%;">
</div>
<div class="w3-col m4 w3-center"><h1>LEARN CUBE-JNTUK</h1></div>
<div class="w3-col m4 w3-center">
<p>Welcome Id:xxxxxxxxxxxx<br><br>
<a class="w3-btn w3-teal">Logout</a>
</p>
</div>
</header>
<div class="w3-topnav w3-center w3-xlarge w3-blue">
<a href="shomepage.html"><i class="material-icons w3-xlarge">home</i></a>
<a href="sresources.html">Resources</a>
<a href="scollegecalendar.html">College Calendar</a>
<a href="scircularstab.html">Circulars/Notifications</a>
<a href="http://jntucek.ac.in/library.php">Online Library</a>
</div>
<sql:setDataSource
var="myDS"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/newfilesdb"
user="root" password="sainath"
/>
<sql:query var="listFiles" dataSource="${myDS}">
SELECT * FROM files_upload where subject = 'Web Technologies'
</sql:query>
<div class="w3-container">
<table class="w3-table w3-bordered w3-border w3-hoverable w3-centered">
<caption><h2>List of files selected</h2></caption>
<thead>
<tr>
<th>Upload ID</th>
<th>subject</th>
<th>Resource Type</th>
<th>Title</th>
<th>Description</th>
<th></th>
</tr>
</thead>
<tbody>
<c:forEach var="file" items="${listFiles.rows}">
<tr>
<td><c:out value="${file.upload_id}" /></td>
<td><c:out value="${file.Subject}" /></td>
<td><c:out value="${file.Resource_type}" /></td>
<td><c:out value="${file.Title}" /></td>
<td><c:out value="${file.Description}" /></td>
</tr>
</c:forEach>
</tbody>
</table>
</div>
<div style="margin:auto; width:60%; padding:15px; align:center;">
<div style="margin:auto; width:60%; padding:15px; align:center;">
<h3 style="align:center;">Select Upload ID of the File to Download</h3>
</div>
<form method="get" action="downloadFileServlet" enctype="multipart/form-data">
upload id : <input type="text" name="id" size="25" style="align:center;"/><br><br>
<div style="margin:auto; width:60%; padding:15px; align:center;">
<input type="submit" value="Save" class="w3-btn w3-red" onclick="validate()"/>
</div>
</form>
</div>
<style>
#footer {
width: 100%;
bottom: 0;
position:static;
height: 4em;
}
</style>
<div id="footer">
<footer class="w3-container w3-blue-grey">
<p> ©Department Of Computer Science</p>
</footer>
</div>
</body>
</html>