8

<html>
    <head>
        <title>JDBC</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <form action="jdbc.jsp" method="post">
            username:<input type="text" name="name">
            password:<input type="password" name="pwd">
            Submit:<input type="submit" value="Submit">
        </form>
    </body>
</html>


<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <%@page import = "java.sql.*"%>
        <%@page import = "javax.sql.*"%>
        <%
            String usr=request.getParameter("name");
            String pwd=request.getParameter("pwd");
            Class.forName("com.mysql.jdbc.Driver");
 java.sql.Connection con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root","root");
 Statement st= con.createStatement();
 ResultSet rs= st.executeQuery("select * from login where username='"+usr+"'");
if(rs.next()){
if(rs.getString(2).equals(pwd)){
session.setAttribute("user",rs.getString(1));
String name = (String)session.getAttribute("user");
out.println("Welocome Boss "+name);
            }
            else{
            System.out.println("Invalid");
            }
            }
    %></body>
</html>