// Programm 3-7: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/ResultsetAus.java
import java.sql.*;
public class ResultsetAus {
  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 Kurse");

    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 (csv)
      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());
  }
}