import java.sql.*;

/**
 * This is a sample program for RmiJdbc client/server jdbc Driver
 * RmiJdbc relies on Java RMI for jdbc objects distribution
 */
public class localdemo {

  public static void main(String[] args) {
    try {

      // Register JDBC/ODBC Driver in jdbc DriverManager
      // On some platforms with some java VMs, newInstance() is necessary...
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

      // Test with MS Access database (rjdemo ODBC data source)
      String url = "jdbc:odbc:rjdemo";

      java.sql.Connection c = DriverManager.getConnection(url,
        "admin", "rjdemo");

      java.sql.Statement st = c.createStatement();
      java.sql.ResultSet rs = st.executeQuery("select * from contact");

      java.sql.ResultSetMetaData md = rs.getMetaData();
      while(rs.next()) {
        System.out.print("\nTUPLE: | ");
        for(int i=1; i<= md.getColumnCount(); i++) {
          System.out.print(rs.getString(i) + " | ");
        }
      }

      rs.close();

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