Java DatabaseMetaData Example

package com.fc.databaseInfo;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
public class DBMD {
public DBMD() {
Connection Db2Conn = null;
PreparedStatement Db2Stmt = null;
ResultSet Db2Rs = null;
String sql = null;
String Table ="YTRT860_RET ";
String fileWriter="";
try { // Database connection string String DRIVER = "com.ibm.as400.access.AS400JDBCDriver";
String URL = "jdbc:db2://localhosturl/DSN8";
// Connect to Database Class.forName("com.ibm.db2.jcc.DB2Driver");
Db2Conn = DriverManager.getConnection(URL,"USERID","PASSWORD");
DatabaseMetaData databaseMetaData = Db2Conn.getMetaData();
String catalog = null;
String schemaPattern = null;
String tableNamePattern = null; String[] types = null;
ResultSet result = databaseMetaData.getTables( catalog, schemaPattern, tableNamePattern, types );
 while(result.next()) {
String tableName = result.getString(3);
System.out.println("tableName "+tableName);
}
}
// Handle any errors that may have occurred. catch (Exception e) { e.printStackTrace(); }
finally { if (Db2Rs != null) try { Db2Rs.close();
} catch(Exception e) {}
if (Db2Stmt != null) try {
Db2Stmt.close(); } catch(Exception e) {}
if (Db2Conn != null) try { Db2Conn.close(); }
catch(Exception e) {}
System.out.println("====================SUCCESS============================="); } }
public static void main(String args[])
{
DBMD d = new DBMD();
}
}