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

CSITQuestions Free Education For Everyone