Wednesday, 27 September 2017

JDBC ORACLE Connection

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
//SQL> select name from v$database;

//NAME
//---------
//XE

//SQL> SELECT sys_context('USERENV', 'SID') FROM DUAL;

//SYS_CONTEXT('USERENV','SID')
//--------------------------------------------------------------------------------
//94
/*
D:\>javac SampleDatabaseConn.java

D:\>java -classpath .;ojdbc6.jar SampleDatabaseConn
100
101 */
//java -cp E:\ojdbc6.jar;E:\ SampleDatabaseConn
//Just goto Command prompt
//tnsping XE
//Set Oracle SID C:>set oracle_sid=ORCL
//Now run Net start command. C:>net start oracleserviceORCL
class SampleDatabaseConn
{
    public static void main (String args []) throws Exception
    {  

  
    
Class.forName ("oracle.jdbc.driver.OracleDriver");
//Driver myDriver = new oracle.jdbc.driver.OracleDriver();
  // DriverManager.registerDriver( myDriver );

//Connection conn = DriverManager.getConnection("jdbc:oracle:oci:@94", "system", "system");

 
     Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@csclap:1521:XE", "system", "system");
                            // @//machineName:port/SID,   userid,  password
        try {
        Statement stmt = conn.createStatement();
        try {
        ResultSet rset = stmt.executeQuery("select * from emp");
        try {
        while (rset.next())
              System.out.println (rset.getString(1));   // Print col 1
        } finally {
            try { rset.close(); } catch (Exception ignore) {}
        }
        } finally {
            try { stmt.close(); } catch (Exception ignore) {}
        }
        } finally {
            try { conn.close(); } catch (Exception ignore) {}
        }
    }
}

No comments:

Post a Comment