-
Notifications
You must be signed in to change notification settings - Fork 0
/
logincheck.jsp
38 lines (36 loc) · 1.3 KB
/
logincheck.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
<%@ page import="java.sql.*"%>
<%@ page language="java" session="true"%>
<%
String action = request.getParameter("action");
if(action.equals("Login")){
String username = request.getParameter("username");
session.setAttribute("usname", username);
String password = request.getParameter("password");
session.setAttribute("ppass", password);
try{
Class.forName("com.mysql.jdbc.Driver");
String uname = "root";
String pass = "";
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/data",uname,pass);
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("SELECT * FROM datain WHERE name='"+username+"' AND password='"+password+"'");
if(rs.next()){
response.sendRedirect("startit.jsp?name="+username);
}
else{
%>
<script>
alert("Invalid username or password");
window.location.href = "signin.jsp";
</script>
<%
}
}
catch(Exception e){
out.println(e);
}
}
else if(action.equals("Create Account")){
response.sendRedirect("createaccount.jsp");
}
%>