<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %>

<%! String dbusername; String dbpassword; %>

 <%


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

     out.println(username);
     out.println(password);


    Connection con=null;
    Statement  stmt=null;
    PreparedStatement pstmt=null;
    ResultSet rs=null;


   try
     {


      String driver="oracle.jdbc.driver.OracleDriver";
      Class.forName(driver);


      con= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");





        String dbQuery="select * from Login";
        stmt=con.createStatement();



        rs=stmt.executeQuery(dbQuery);


        dbusername =rs.getString("username");
        dbpassword =rs.getString("password");



    if(rs.next())
    {
    if((username.equals("dbusername") && password.equals("dbpassword")))
    {
         session.setAttribute("username",dbusername);

         response.sendRedirect("Home.jsp");
    }
    else
    {
        response.sendRedirect("Error.jsp");

    }
    }
 }
 catch(Exception e)
 {
 }

    %>