|
|
|
|
|
|
|
|
|
 |
|
|
 |
|
|
 |
|
|
 |
|
|
|
6만원 이상 무료배송
|
|
|
주문하시는
총상품금액의 합계가
6만원 이상일 경우
택배비가 무료입니다.
|
|
|
|
 |
|
|
|
|
|
|
[JAVA] DatabaseMetaDataExample
|
|
|
|
작성자:
어라
작성일: 2009-07-07 09:36
조회: 14361
댓글: 0
|
|
|
// -----------------------------------------------------------------------------
// DatabaseMetaDataExample.java
// -----------------------------------------------------------------------------
/*
* =============================================================================
* Copyright (c) 1998-2005 Jeffrey M. Hunter. All rights reserved.
*
* All source code and material located at the Internet address of
* http://www.idevelopment.info is the copyright of Jeffrey M. Hunter, 2005 and
* is protected under copyright laws of the United States. This source code may
* not be hosted on any other site without my express, prior, written
* permission. Application to host any of the material elsewhere can be made by
* contacting me at jhunter@idevelopment.info.
*
* I have made every effort and taken great care in making sure that the source
* code and other content included on my web site is technically accurate, but I
* disclaim any and all responsibility for any loss, damage or destruction of
* data or any other property which may arise from relying on it. I will in no
* case be liable for any monetary damages arising from such loss, damage or
* destruction.
*
* As with any code, ensure to test this code in a development environment
* before attempting to run it in production.
* =============================================================================
*/
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLWarning;
/**
* -----------------------------------------------------------------------------
* The following class provides an example of using the DatabaseMetaData
* class.
*
* The DatabaseMetaData class is used to determine the capabilities of a JDBC
* driver and it database during runtime. If a given method of this interface
* is not supported by the JDBC driver, the method will either throw an
* SQLException, or in the case of a method that returns a result set, it
* may return null.
*
* Some of the methods take search patterns as its arguments. The pattern
* values used can be the SQL wildcard characters % and _. Other search
* arguments accept an empty set ("") when the argument is not applicable, or
* null to drop the argument from the search criteria.
*
* All methods can throw an SQLException.
* -----------------------------------------------------------------------------
* @version 1.0
* @author Jeffrey M. Hunter (jhunter@idevelopment.info)
* @author http://www.idevelopment.info
* -----------------------------------------------------------------------------
*/
public class DatabaseMetaDataExample {
final static String driverClass = "oracle.jdbc.driver.OracleDriver";
final static String connectionURL = "jdbc:oracle:thin:@localhost:1521:CUSTDB";
final static String userID = "scott";
final static String userPassword = "tiger";
Connection con = null;
/**
* Construct a DatabaseMetaDataExample object. This constructor will create
* an Oracle database connection.
*/
public DatabaseMetaDataExample() {
try {
System.out.print(" Loading JDBC Driver -> " + driverClass + "\n");
Class.forName(driverClass).newInstance();
System.out.print(" Connecting to -> " + connectionURL + "\n");
this.con = DriverManager.getConnection(connectionURL, userID, userPassword);
System.out.print(" Connected as -> " + userID + "\n");
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
private static void prt(Object s) {
System.out.print(s);
}
private static void prt(int i) {
System.out.print(i);
}
private static void prtln(Object s) {
prt(s + "\n");
}
private static void prtln(int i) {
prt(i + "\n");
}
private static void prtln() {
prtln("");
}
/**
* Run the DatabaseMetaData Example. This method will use a DatabaseMetaData
* object to obtain the capabilities of the JDBC driver and the database
* during runtime.
*/
public void runExample() {
DatabaseMetaData md = null;
try {
// Obtain a DatabaseMetaData object from our current connection
md = con.getMetaData();
prtln();
prtln(" DatabaseMetaData Information");
prtln(" ============================");
prt(" - Product Name : ");
try {
prtln(md.getDatabaseProductName());
} catch (SQLException e) {
prtln("java.sql.SQLException: Unsupported feature");
}
prt(" - Product Version Number : ");
try {
prtln(md.getDatabaseProductVersion());
} catch (SQLException e) {
prtln("java.sql.SQLException: Unsupported feature");
}
prt(" - Database Major Version : ");
try {
prtln(md.getDatabaseMajorVersion());
} catch (SQLException e) {
prtln("java.sql.SQLException: Unsupported feature");
}
prt(" - Database Minor Version : ");
try {
prtln(md.getDatabaseMinorVersion());
} catch (SQLException e) {
prtln("java.sql.SQLException: Unsupported feature");
}
prt(" - Driver Name : ");
try {
prtln(md.getDriverName());
} catch (SQLException e) {
prtln("java.sql.SQLException: Unsupported feature");
}
prtln(" - Driver Major Version : " + md.getDriverMajorVersion());
prtln(" - Driver Minor Version : " + md.getDriverMinorVersion());
prt(" - Username : ");
try {
prtln(md.getUserName());
} catch (SQLException e) {
prtln("java.sql.SQLException: Unsupported feature");
}
prt(" - Catalogs : ");
try {
ResultSet catalogs = md.getCatalogs();
while (catalogs.next()) {
prtln(" - " + catalogs.getString(1) );
}
catalogs.close();
} catch (SQLException e) {
prtln("java.sql.SQLException: Unsupported feature");
}
prtln();
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* Close down Oracle connection.
*/
public void closeConnection() {
try {
System.out.print(" Closing Connection...\n");
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* Sole entry point to the class and application.
* @param args Array of String arguments.
* @exception java.lang.InterruptedException
* Thrown from the Thread class.
*/
public static void main(String[] args)
throws java.lang.InterruptedException {
DatabaseMetaDataExample dmde = new DatabaseMetaDataExample();
dmde.runExample();
dmde.closeConnection();
}
}
|
|
|
|
|
|
|
|
|
* 관련 댓글 한말씀 부탁합니다.
|
|
|
|
