글쓴이 :park363 2000년 4월 17일 16:54:33
import java.sql.*;
class MetaDataTest{
public static void main(String[] argv) throws Exception{
System.out.println("Registry Driver!");
Class.forName ("oracle.jdbc.driver.OracleDriver");
// DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
System.out.println("GetConnection!");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@medic:1521:ORA8","webcom","webcom");
System.out.println("Get MetaData!");
DatabaseMetaData md = conn.getMetaData();
String catalog = null;
String schemaPattern = null;;
String tableNamePattern = "%";
String columnNamePattern = "%";
String[] types = {"TABLE"};//,"VIEW",/* "SYSTEM TABLE", "GLOBAL TEMPORARY","LOCAL TEMPORARY", "ALIAS",*/ "SYNONYM"};
ResultSet rs = //md.getTableTypes();
//md.getCatalogs();
//md.getSchemas();
//md.getTables(catalog, schemaPattern, tableNamePattern, types);
md.getColumns(catalog, schemaPattern, tableNamePattern, columnNamePattern);
System.out.println("Get Tables!");
ResultSetMetaData rsmd = rs.getMetaData();
int columns = rsmd.getColumnCount();
System.out.println("Column Count : " + columns);
for(int i = 1 ; i <= columns ; i++){
System.out.print(rsmd.getColumnName(i)+ "\t");
}
System.out.println("\n-----------------------------------------------------------------");
int count = 1;
while (rs.next ())
{
System.out.println(count++ + " 번째 로우...............");
for(int i = 1 ; i <= columns ; i++){
System.out.print (rs.getString (i) + "\t");
}
System.out.println();
}
System.out.println("Successful!");
}
}