// Programm 4-16:  ./JDBCelementar/ResultsetMetas.java 
import java.sql.*;

public class ResultsetMetas {
  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();
    s.execute("SELECT * FROM Personen");
    ResultSetMetaData rsmd = s.getResultSet().getMetaData();
    System.out.println("Name " +  rsmd.getColumnName(2));
    System.out.println("Label " + rsmd.getColumnLabel(2));
    System.out.println("Typnummer " + rsmd.getColumnType(2));
    System.out.println("Typname " + rsmd.getColumnTypeName(2));
    System.out.println("Stellen " + rsmd.getPrecision(2));
  }
}