/
login.java
100 lines (77 loc) · 2.31 KB
/
login.java
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
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class Login extends HttpServlet
{
Connection con;
PreparedStatement ps;
public void init() throws ServletException
{
ServletContext context=getServletContext();
String driver=context.getInitParameter("p1");
String cs=context.getInitParameter("p2");
String username=context.getInitParameter("p3");
String password=context.getInitParameter("p4");
try
{
Class.forName(driver);
con=DriverManager.getConnection(cs,username,password);
ps=con.prepareStatement("select * from registration1 where username=? and password=? and user_type=?");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException
{
PrintWriter writer=response.getWriter();
HttpSession session=request.getSession();
String username=request.getParameter("username");
String password=request.getParameter("password");
String type=request.getParameter("type");
System.out.println(username+password+type);
session.setAttribute("user",username);
try
{
writer.println("<html>");
writer.println("<body bgcolor=green>");
writer.println("<center>");
ps.setString(1,username);
ps.setString(2,password);
ps.setString(3,type);
ResultSet rs=ps.executeQuery();
if(rs.next())
{
writer.println("<h1>LOGIN SUCCESSFUL</h1><br><br>");
writer.println("<a href=account.html>click here to see your account</a>");
}
else
{
writer.println("<h1>LOGIN FAILED</h1><br><br>");
writer.println("<a href=login.html>click here to login again</a>");
}
writer.println("</center>");
writer.println("</body>");
writer.println("</html>");
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void destroy()
{
try
{
// session.close();
ps.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}