| Using the JDBC MetaData Interface
• ResultSet: ResultSetMetaData getMetaData() |
| • ResultSetMetaData provides information about the types and properties of the DDL properties of a ResultSet object |
| • ResultSetMetaData provides various methods for finding out information about the structure of a ResultSet: |
| • getColumnClassName(int col): gets fully-qualified Java class name to which a column value will be mapped; eg. Java.lang.Integer, etc. |
| • getColumnCount(): gets the number of columns in the ResultSet |
| • getColumnDisplaySize(int col): gets the normal maximum width in characters for column |
| • getColumnName(int col): gets the name of column |
| • int getColumnType(int col): gets the JDBC type (java.sql.Types) for the value stored in col; eg. Value 12 = JDBC VARCHAR, etc. |
| • getPrecision(int col): for numbers, gets the mantissa length, for others, gets the number of bytes for column |