// Programm 4-5:  ./JDBCelementar/StatementUndResultset3.java
import java.sql.*;
public class StatementUndResultset3 {
  public static void main(String[] args) throws Exception {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
    Connection c = 
                DriverManager.getConnection("jdbc:odbc:Kurse");
    Statement s = c.createStatement();
    ResultSet rs = s.executeQuery("SELECT * FROM Personen");
    ResultSetMetaData rsmd = rs.getMetaData();
    int x = rsmd.getColumnCount();
    StringBuffer aus = new StringBuffer("\n");
    for (int i = 1; i <= x; i++) {   // kommagetrennte Spaltennamen
      aus.append(rsmd.getColumnName(i));
      if (i != x) aus.append(", "); else aus.append("\n");
    }
    while(rs.next()) {               // kommagetrennte Spaltenwerte
      for (int i = 1; i <= x; i++) {
        aus.append(rs.getString(i));
        if (i != x) aus.append(", "); else aus.append("\n");
      }
    }
    System.out.println(aus.toString());
  }
}                          // Ende class StatementUndResultset3