<%@ page language="java" import="java.sql.*"%>

<%
    try {
        Class.forName("com.mysql.jdbc.Driver");
           Connection myConnection = DriverManager.getConnection(
             "jdbc:mysql://devsrv.cs.csbsju.edu:3306/???","???", "???");

        Statement stmt=myConnection.createStatement();
        String queryString = "Select * from employee where lname='"+request.getParameter("lname")+"' and ssn='"+request.getParameter("ssn")+"'";
        //out.println(queryString);
        ResultSet rs = stmt.executeQuery(queryString);
        if(!rs.next())
            response.sendRedirect("Login.html");
        else{
           out.println(rs.getString(1));
           out.println(rs.getString(2));
           out.println(rs.getString(3));
           out.println(rs.getString(4));
           out.println(rs.getString(5));
           out.println(rs.getString(6));
           out.println(rs.getString(7));
           out.println(rs.getString(8));
           out.println(rs.getString(9));
           out.println(rs.getString(10));}
    } catch (Exception E) {
            E.printStackTrace();
        }
%>