<%
    Connection connection = DriverManager.getConnection("jdbc:mysql://localhost/lportal", "root", "root");
    Statement statement = connection.createStatement();

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

    ResultSet resultset =
        statement.executeQuery("select lastmodified from ams1 where username = '" + username + "'") ;
    System.out.println(username);

%>

<% while(resultset.next()){ %>
    <p> last punchin: <%= resultset.getString(1) %> </p>
<% } %>