-
Notifications
You must be signed in to change notification settings - Fork 0
/
viewusers.jsp
71 lines (60 loc) · 1.07 KB
/
viewusers.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
<%@ page import="java.sql.*" %>
<%!
Connection con;
Statement st;
ResultSet rs;
%>
<%
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:xe","username","password");
st=con.createStatement();
rs=st.executeQuery("select email from users order by email");
%>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<style>
body{
background-image: url("images/bg.jpg");
background-size: 1250px 750px;
}
</style>
</HEAD>
<BODY BGCOLOR="#99CCFF">
<FORM METHOD=POST ACTION="viewuser.jsp">
<CENTER>
<B><FONT SIZE="5" COLOR="">USER DETAILS</FONT></B><br><br>
<TABLE>
<tr>
<TD><b>Email</TD>
<td><SELECT NAME="email" required>
<option>--select user--
<%
while(rs.next())
{
String temp=rs.getString(1);
%>
<option><%=temp%>
<%
}
%>
</SELECT></td>
</TR>
</TABLE>
<br>
<INPUT TYPE="submit" VALUE="SHOW">
<BR><BR>
<INPUT TYPE="button" onClick="window.location='admin.html'" value="BACK">
</CENTER>
</FORM>
</BODY>
</HTML>
<%
}
catch(Exception e)
{
out.println(e.toString());
}
%>