// Lookup players in a simple database

import java.sql.*;

public class Lookup
{
    public static void main( String [] args )
    {
        String dbUrl = "jdbc:odbc:hockey99";
        String user = "";
        String password = "";
    
        try
        {
             // Load the driver
            Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
        
            Connection c = DriverManager.getConnection( dbUrl, user, password);
            Statement s = c.createStatement( );
          
            ResultSet r = s.executeQuery(
                "SELECT LASTNAME, FIRSTNAME, GOALS " +
                "FROM hockey.csv " +
                "WHERE " +
                "(LASTNAME='" + args[ 0 ] + "') " +
                "ORDER BY GOALS" );
      
            while( r.next( ) )
            {
                System.out.println(
                    r.getString("LASTNAME") + ", " 
                  + r.getString("FIRSTNAME") + ": "
                  + r.getInt("GOALS") );
            }
            
            s.close( );
        }
          // Lazy catch
        catch( Exception e )
        {
            e.printStackTrace( );
        }
    }
}