JDBC高级编程——处理元数据

元数据可以提供一些关亍数据库结果的一些信息：
• 数据库本身的信息
– DatabaseMetaData dbmd =connection.getMetaData();
• 单表的信息
– ResultSet tableRS = connection.getMetaData().getTables(null,null,”TableName”,null);
• 结果集的信息

– ResultSetMetaData rsmd = resultSet.getMetaData();

使用MetaData的例子：
Connection connection = null;
Class.forName("COM.cloudscape.core.JDBCDriver");
connection =DriverManager.getConnection(
"jdbc:cloudscape:c:/PhoneBook");
DatabaseMetaData dbmd = connection.getMetaData();
String version = dbmd.getDriverVersion();
System.out.println(“The driver version is:” + version);
ResultSet aTable = dbmd.getTables(null,null,”b%”,null));
String tablename = aTable.getString(“TABLE_NAME”);
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery(“SELECT * from ” + tablename);
ResultSetMetaData rsmd = resultSet.getMetaData();
String firstColumn = rsmd.getColumnName(1);
System.out.println(“The first column is:” + firstColumn)