import java.sql.*;
import java.io.*;

public class jdbc {
  public static void main(String args[]) {
    try {
      // register odbc bridge
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException e) {
      System.err.println("ClassNotFoundException: "+e.getMessage());
    }

    try {
      // open connection to "cs202" odbc data source
      Connection con=DriverManager.getConnection("jdbc:obdc:cs202");
      
      // create a statement object ...
      Statement stmt=con.createStatement();

      // ... to execute a selection.
      ResultSet rs=stmt.executeQuery("select * from profs");
      
      // get result meta information
      ResultSetMetaData rsmd=rs.getMetaData();

      int ncol=rsmd.getColumnCount();

      // print out the column headings
      for(int i=1; i<=ncol; i++) {
        if(i>1) System.out.print(",\t");
        System.out.print(rsmd.getColumnName(i));
      }
      System.out.println();
      
      // print out the data
      while(rs.next()) {
        for(int i=1; i<=ncol; i++) {
          if(i>1) System.out.print(",\t");
          System.out.println(rs.getString(i));
        }
        System.out.println();
      }

      // close statement and connection
      stmt.close();
      con.close();
    }
    catch (SQLException e) {
      System.err.println("SQLException: "+e.getMessage());
    }
  }
}