MCAENDTERMEXAM/ques1.java at main · amitjuyal/MCAENDTERMEXAM · GitHub

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
//Index Html
<!DOCTYPE html>
<html>
<head>
<title>question one</title>
</head>
<body>
	<form action="login">
		<label>User name</label> <input type="text" placeholder="enter your username.."
		name="login"/> <br/><br/>
		<label>Password</label> <input type="text" placeholder="enter password..."
		name="password"/> <br/><br/>
		<button type="submit">login</button><br/>
	</form>
</body>
</html>

//Connection
import java.sql.*;

public class conn {
    public static boolean checkUser(String email,String pass)
    {
        boolean st =false;
        try {
        	Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","abcd");
            PreparedStatement ps = con.prepareStatement("select * from login where username=? and password=?");
			ps.setString(1, email);
			ps.setString(2, pass);
            ResultSet rs =ps.executeQuery();
            st = rs.next();
        }
        catch(Exception e) {
            e.printStackTrace();
        }
        return st;
    }
}

//Welcome java file

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class welcome extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        out.println("Welcome user");
    }
}

//Login file
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class Login extends HttpServlet {

    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();

        String username = request.getParameter("username");
        String pass = request.getParameter("password");

        if(conn.checkUser(username, pass)){
            RequestDispatcher rs = request.getRequestDispatcher("Welcome");
            rs.forward(request, response);
        }
        else
        {
            out.println("Username or Password incorrect");
            RequestDispatcher rs = request.getRequestDispatcher("index.html");
            rs.include(request, response);
        }
    }
}