// Programm 3-19: BSP_ROOT/meinewebapp/WEB-INF/classes/jdbcbasis/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));
  }
}