시소당

getMetaData를 이용해서 DB정보 얻기

import  java.sql.*;

  

//  1.  DatabaseMetaData는  Connection의  getMetaData()를  이용,  instance를  얻는다.
//  2.  DatabaseMetaData를  이용하여  DBMS에  관련된  사항을  출력하는  예제이다.
//  3.  상세한  사항은  API의  Method를  참조해  보면  많은  내용을  알  수  있다.
public  class  DbMetaData  {
        Connection  con;                //  Connection  object
        Statement  stmt;                //  Statement    object    
        ResultSet  rs;                    //  ResultSet    object
  
      //  Connection  object를  이용하여  DB의  Meta정보를  얻고  출력한다.
      public  void  test()  {        
          //  DB연결  정보
              String  url    =  "jdbc:oracle:thin:@localhost:1521:sid";  //  URL
              String  user  =  "scott";                                                                  //  사용자  ID
              String  pwd    =  "*****";                                                                  //  비밀번호
        
              try  {
            //  1.  Driver를  Load한다.
            Class.forName("oracle.jdbc.driver.OracleDriver");
          
          //  2.  DB연결  객체  생성
            con  =  DriverManager.getConnection(url,  user,  pwd);                  
          
            //  3.  DatabaseMetaData  얻기  ::  DB에  대한  Meta정보를  얻는다.
            //      Connection의  getMetaData()를  이용해서  instance를  얻는다.
            DatabaseMetaData  dmd  =  con.getMetaData();                          
              
            //  4.  DB에  대한  Meta정보를  출력한다.    getStringFunctions()          
          System.out.println("DBMS  이름  :  "  +  dmd.getDatabaseProductName());
          System.out.println("DBMS  제품버전  :  "  +  dmd.getDatabaseProductVersion());
            System.out.println("Driver명    :  "  +  dmd.getDriverName());
            System.out.println("DBMS  Driver버전  :  "  +  dmd.getDriverVersion());
            System.out.println("DBMS  URL  :  "  +  dmd.getURL());
            System.out.println("DBMS  USER  :  "  +  dmd.getUserName());
            System.out.println();
            System.out.println("String  함수  :  "  +  dmd.getStringFunctions());
            System.out.println("Date  함수  :  "  +  dmd.getTimeDateFunctions());
            System.out.println("math  함수  :  "  +  dmd.getNumericFunctions());
            System.out.println("SQLKeywords  :  "  +  dmd.getSQLKeywords());    
          
            //  5.  object를  close한다.
              con.close();      //  Connection  Object                                      
              }  catch  (ClassNotFoundException  c)  {
                  c.printStackTrace();
              }  catch  (SQLException  s)  {
                  s.printStackTrace();
              }    
      }  
    
      //  객체를  생성하고  실행한다.
      public  static  void  main(String  args[])  {              
            DbMetaData  t  =  new  DbMetaData();//  객체  생성
                      
            t.test();//  실행한다.
      }      
}  

[출처]  getMetaData를  이용해서  DB정보  얻기|작성자  자유인
http://blog.naver.com/shinks1642?Redirect=Log&logNo=90016009424