
import java.sql.*;

public class localdemo {

  public static void main(String[] args) {
    try {

      // Register JDBC Driver in jdbc DriverManager
      // On some platforms with some java VMs, newInstance() is necessary...
      // reference: the README file of MySQL Connector/J
      Class.forName("com.mysql.jdbc.Driver").newInstance();

      // Test with MS Access database (rjdemo ODBC data source)
      String url = "jdbc:mysql://DCCM831X/jguru";

      java.sql.Connection c = DriverManager.getConnection(url,
        "blah", "blah");

      java.sql.Statement st = c.createStatement();
      java.sql.ResultSet rs = st.executeQuery("select * from JJJJData");

      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();
    }
  }
};


