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

<%

        try { 
            Class.forName("org.gjt.mm.mysql.Driver"); 
        } catch (Exception e) { 
            out.println("Can't load JDBC Driver. Make sure classpath is correct."); 
        }

        String url = "jdbc:mysql://silo.cs.indiana.edu:14298/demoOne", 
            username = "dgerman", 
            password = "sp00n"; 
        Connection connection; 

        try {
            connection = DriverManager.getConnection(url, username, password); 

            Statement statement = connection.createStatement(); 
            ResultSet result; 
            out.println("Querying database..."); 

            result = statement.executeQuery(
              " select name, age from dgerman_person    " + 
              "        where lives_in = 'Africa'        "   
            ); 

            while (result.next()) {
                out.println(" " + result.getString(1) + 
                                   ", " + result.getString(2)); 
            }

            statement.close(); 
            connection.close(); 

        } catch (SQLException e) { 
            out.println("An SQLException occurred: " + e.getMessage()); 
        } catch (Exception e) {
            out.println("Exception: " + e); 
        }

 %>