package ber.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class SelectCsillag {

  public static void main(String[] args) {
    try {
    Class.forName("com.mysql.jdbc.Driver"); // Load the driver

    // connect to the database.  
    Connection conn = DriverManager.getConnection("jdbc:mysql://home.cab.u-szeged.hu/test", "", "");
    Statement stmt;

    // ------------------------------------------------ query the test table
    stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("select * from autok"); // run the query
    ResultSetMetaData md = rs.getMetaData();
    while ( rs.next() ) {
      for ( int i = 1; i <= md.getColumnCount(); i++ ) {
        System.out.print( rs.getObject(i) + "   ");
      }
      System.out.println();
    }
    stmt.close();

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