// Programm 3-4: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/ExecuteStatement.java
import java.sql.*;
public class ExecuteStatement {
  public ExecuteStatement(String sql) {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection c = DriverManager.getConnection("jdbc:odbc:Kurse");
      Statement s = c.createStatement();
      if (s.execute(sql)) {
        ResultSet rs = s.getResultSet();
        int z = rs.getMetaData().getColumnCount();
        while(rs.next())
          for (int i = 1; i <= z; i++) {
            if (i != z) System.out.print(rs.getString(i)+", ");
            else        System.out.print(rs.getString(i)+"\n");
          }
      }
      else  System.out.println(s.getUpdateCount());
    }
    catch (Exception ex) { ex.printStackTrace(); }
  }
  public static void main(String[] args) {
    new ExecuteStatement(args.length==0 ? "SELECT * FROM Personen" : args[0]);
  }
}