-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdateuser.jsp
84 lines (71 loc) · 1.52 KB
/
updateuser.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
<%@ page import="java.sql.*" %>
<%!
Connection con;
Statement stm;
ResultSet rs;
String q,email;
%>
<%
try
{
Class.forName("oracle.jdbc.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:xe","username","password");
email=session.getAttribute("su2").toString();
q="select * from users where email=?";
PreparedStatement stm = con.prepareStatement(q);
stm.setString(1,email);
rs=stm.executeQuery();
%>
<html>
<HEAD>
<TITLE>update_user</TITLE>
<style>
body{
background-image: url("images/bg.jpg");
background-size: 1250px 750px;
}
</style>
</HEAD>
<BODY BGCOLOR="#99CCFF">
<FORM METHOD=POST ACTION="updateuser1.jsp">
<%
while(rs.next())
{
%>
<CENTER>
<B><FONT SIZE="5" COLOR="">USER DETAILS</FONT></B><br><br>
<TABLE border="2" style="border-collapse: collapse">
<TR>
<TD><B>Email</TD>
<TD><b><%=email%><input type="hidden" name="email" value="<%=email%>"></TD>
</tr>
<tr>
<TD><B>Password</TD>
<TD><INPUT TYPE="text" NAME="password" value="<%=rs.getObject(2)%>" size=15 maxlength=12></TD>
</TR>
<TR>
<TD><B>Designation</TD>
<TD><SELECT NAME="desig">
<option><%=rs.getObject(3)%>
<OPTION>administrator</OPTION>
<OPTION>staff</OPTION>
<OPTION>customer</OPTION>
</SELECT></TD>
</TR>
</TABLE><BR>
<input type="submit" value="UPDATE">
<INPUT TYPE="button" onClick="window.location='viewusers.jsp'" value="BACK">
<%
}
%>
</FORM>
</BODY>
</html>
<%
}
catch(Exception e)
{
out.println(e.toString());
}
%>