import java.sql.*;

public class JoltMetaData {
    public static void main (String args[]) {
        String URL = "jdbc:odbc:CafeJolt";
        String username = "";
        String password = "";

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        } catch (Exception e) {
            System.out.println("Failed to load JDBC/ODBC driver.");
            return;
        }

        Statement stmt = null;
        Connection con=null;
        try {
            con = DriverManager.getConnection (
                URL,
                username,
                password);
            stmt = con.createStatement();
        } catch (Exception e) {
            System.err.println("problems connecting to "+URL);
        }

        try {
            ResultSet result = stmt.executeQuery(
                "SELECT programmer, cups FROM JoltData ORDER BY cups DESC;");
            ResultSetMetaData meta = result.getMetaData();

            int numbers = 0;
            int columns = meta.getColumnCount();
            for (int i=1;i<=columns;i++) {
                System.out.println (meta.getColumnLabel(i) + "\t"
                              + meta.getColumnTypeName(i));
                if (meta.isSigned(i)) { // is it a signed number?
                    numbers++;
                }
            }
            System.out.println ("Columns: " + columns + " Numeric: " + numbers);

            con.close();
        }
        catch (Exception e) {
          e.printStackTrace();
        }
    }
}