// Programm 4-4:  ./JDBCelementar/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]);
  }
}                              // Ende class ExecuteStatement 
