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 |