snavely

PrintWriter output=res.getWriter();
    res.setContentType("text/html");
    output.println("<HTML>\n<BODY>");
    String lastname = req.getParameter("lastname");
    try {
        Class.forName("org.gjt.mm.mysql.Driver");
        String dbconn = "jdbc:mysql://198.252.11.102:3306/cm335u23";
        Connection conn =
                DriverManager.getConnection(dbconn,"cm335u23","kansas");
        Statement stmt = conn.createStatement();
        //String query1 = "select * from student where lastname like '%"+lastname+"%'";
        String query1 = "select * from student";
        ResultSet rset = stmt.executeQuery(query1);

        output.println("<table border=1>");
        output.println("<tr>");
        output.println("<th>Last Name</th>");
        output.println("<th>First Name</th>");
        output.println("<th>Major</th>");
        output.println("<th>Degree</th>");
        output.println("<th>Year</th>");
        output.println("<th>On Financial Aid</th>");
        output.println("<th>Full Time</th>");
        output.println("<th>Out of State</th>");
        output.println("</tr>");
while(rset.next()){
                String lastName = rset.getString("lastName");
                output.println("<tr><td>");
                output.println(lastName + "</td>");

                String firstName = rset.getString("firstName");
                output.println("<td>");
                output.println(firstName + "</td>");

String major = rset.getString("major");
                output.println("<td>");
                output.println(major + "</td>");

                String year = rset.getString("year");
                output.println("<td>");
                output.println(year + "</td>");

                String degree = rset.getString("degree");
                output.println("<td>");
                output.println(degree + "</td>");

                String onFinAid = rset.getString("onFinAid");
                output.println("<td>");
                output.println(onFinAid + "</td>");

                String fullTime = rset.getString("fullTime");
                output.println("<td>");
                output.println(fullTime + "</td>");

                String outOfSt = rset.getString("outOfSt");
                output.println("<td>");
                output.println(outOfSt + "</td></tr>");
}
        }catch (SQLException sqle) {
                System.out.println(sqle);
        }catch (ClassNotFoundException cnfe){
                System.out.println(cnfe);
        }


        output.println("</table>");


    output.println("</BODY>\n</HTML>");
    output.close();
  }