-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathvirtualsecurity1.jsp
82 lines (51 loc) · 1.69 KB
/
virtualsecurity1.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
<%@ page import="java.util.date.*,java.util.text.DateFormat.*,java.text.ParseException.*"%>
<%@page import="com.oreilly.servlet.*,java.sql.*,java.lang.*,databaseconnection.*,java.text.SimpleDateFormat,java.util.*,java.io.*,javax.servlet.*, javax.servlet.http.*" %>
<%@ page import = "java.util.Date,java.text.SimpleDateFormat,java.text.ParseException"%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<%
String u1=request.getParameter("uname");
String u2=request.getParameter("pwd");
String u3=request.getParameter("dob1");
String u4=request.getParameter("proof");
String u5=request.getParameter("answer");
String u6=request.getParameter("answer1");
int id=(Integer)session.getAttribute("userid");
Connection con=null;
Statement st=null;
ResultSet rs=null;
String x1=null,x2=null,x3=null,x4=null,x5=null,x6=null;
try
{
con=databasec.getconnection();
st=con.createStatement();
rs=st.executeQuery("select * from signup,securitysp where signup.userid='"+id+"'and securitysp.userid='"+id+"'");
while(rs.next())
{
x1=rs.getString("signup.username");
x2=rs.getString("signup.password");
x3=rs.getString("signup.dob");
x4=rs.getString("securitysp.proofnumber");
x5=rs.getString("securitysp.answer1");
x6=rs.getString("securitysp.answer2");
}
if((u1.equals(x1)) && (u2.equals(x2)) && (u3.equals(x3)) && (u4.equals(x4)) && (u5.equals(x5)) && (u6.equals(x6)))
{
response.sendRedirect("owner.jsp");
}
else
{
out.print("You entered wrong security parameter...so try again..");
}
}
catch(Exception e)
{
out.print(e);
}
%>
</body>
</html>