Preview:
<%@ page language="java" %>
<html>
<head>
    <title>Login</title>
</head>
<body>
    <h2>User Login</h2>
    <form action="validateLogin.jsp" method="post">
        <label>Username:</label>
        <input type="text" name="username" required><br>
        <label>Password:</label>
        <input type="password" name="password" required><br>
        <input type="submit" value="Login">
    </form>
</body>
</html>



<%@ page import="java.sql.*" %>
<html>
<body>
<%
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    boolean isValid = false;

    String url = "jdbc:oracle:thin:@//localhost:1521/XE";
    String duser = "system";
    String dpassword = "abhi";
    Connection conn = null;
    try {
    	Class.forName("oracle.jdbc.driver.OracleDriver");
        conn = DriverManager.getConnection(url, duser, dpassword);
        PreparedStatement ps = conn.prepareStatement("SELECT * FROM users1 WHERE username=? AND password=?");
        ps.setString(1, username);
        ps.setString(2, password);
        ResultSet rs = ps.executeQuery();
        isValid = rs.next();
    } catch (Exception e) {
        out.println("Error: " + e.getMessage());
    } finally {
        if (conn != null) conn.close();
    }
    if (isValid) {
        out.println("Login Successful");
        out.println("<h1> hi "+ username+"! </h1>");
    } else {
        out.println("Invalid Credentials");
    }
%>
</body>
</html>
downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter