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) {}
}
}
}
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