Introduction to Java Database Connectivity (JDBC) PATH 2
Meta Data - Meta data is the information about the database: - e.g. the number of columns, the types of the columns - meta data is the schema information Accessing Meta Data - The getMetaData() method can be used on a ResultSet object to create its meta data object. - e.g. ResultSetMetaData md = rs.getMetaData(); Using Meta Data int numCols = md.getColumnCount(); for (int i = 0; i <= numCols; i++) { if (md.getColumnType(i) == Types.CHAR) System.out.println( md.getColumnName(i) ) } More Meta Data Methods _ getTableName() - getPrecision() number of decimal digits in the column - isSigned() returns true if column has signed numbers - isCurrency() - etc. Using MS Access MS Access changed its file formats when Access 2007 was released: - for Access 20...