//생성자
    public ConnectionTest()
    {
    }

    //Tibero 접속
    public void connect()
    {
        try
        {
            System.out.println("=====================================");
            System.out.println("DB_DRV : " + DB_DRV);
            System.out.println("DB_DRV : " + DB_URL);
            System.out.println("DB_ID  : " + DB_ID);
            System.out.println("DB_PWD : " + DB_PWD);
            System.out.println("-------------------------------------");

            Class.forName(DB_DRV);
            conn = DriverManager.getConnection(DB_URL, DB_ID, DB_PWD);

            System.out.println("Tibero Connect Success");
            System.out.println("=====================================");
            System.out.println("");
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
        }
    }

    //SQL 수행
    public void excute()
    {
        try
        {
            strSQL = "SELECT SID, USERNAME, SQL_ID, TO_CHAR(LOGON_TIME, 'YYYY-MM-DD HH24:MI:SS') LOGON_TIME FROM V$SESSION";
            stmt = conn.createStatement();
            rs = stmt.executeQuery(strSQL);
            System.out.println("=====================================");
            System.out.println("SQL : " + strSQL);
            System.out.println("-------------------------------------");
            while ( rs.next() )
            {
                System.out.println("SID        : " + rs.getString(1));
                System.out.println("USERNAME   : " + rs.getString(2));
                System.out.println("SQL_ID     : " + rs.getString(3));
                System.out.println("LOGON_TIME : " + rs.getString(4));
                System.out.println("=====================================");
            }
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
            disconnect();
        }
    }

    //Tibero 접속종료
    public void disconnect()
    {
        try
        {
            if (rs   != null)   rs.close();
            if (stmt != null)   stmt.close();
            if (conn != null)   conn.close();
        }
        catch (Exception ex)
        {
            ex.printStackTrace();
        }
        finally
        {
            if ( rs    != null ) try { rs   .close(); } catch(Exception e) {}
            if ( stmt  != null ) try { stmt .close(); } catch(Exception e) {}
            if ( conn  != null ) try { conn .close(); } catch(Exception e) {}
        }
    }

    //Main 함수
    public static void main (String [] args)
    {
        ConnectionTest test = new ConnectionTest();

        test.connect();
        test.excute();
        test.disconnect();
    }
}