-
Notifications
You must be signed in to change notification settings - Fork 0
/
loginvalidate.jsp
49 lines (45 loc) · 1.21 KB
/
loginvalidate.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
<%@ page import="java.sql.*"%>
<%! PreparedStatement ps;
ResultSet rs;
%>
<%
String uname=request.getParameter("username");
String pass=request.getParameter("pass");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/projectdatabase", "root", " ");
ps=conn.prepareStatement("Select * from maintable where Email=?");
ps.setString(1,uname);
rs=ps.executeQuery();
rs.next();
String fullname=rs.getString(2);
String dbpass=rs.getString(8);
String YOS=rs.getString(3);
String dept=rs.getString(5);
String email=rs.getString(7);
String name1=fullname;
if(pass.equals(dbpass))
{
%>
<jsp:forward page="profile.jsp">
<jsp:param name="fullname" value="<%=name1%>"/>
<jsp:param name="YOS" value="<%=YOS%>"/>
<jsp:param name="dept" value="<%=dept%>"/>
<jsp:param name="email" value="<%=email%>"/>
<jsp:param name="message" value="login successful!!!" />
</jsp:forward>
<%
}
else
{
%>
<jsp:forward page="login.jsp">
<jsp:param name="message" value="Wrong Password"/>
</jsp:forward>
<%
}
}
catch(SQLException e) {
out.println("SQLException caught: " +e.getMessage());
}
%>