//// Example 1
/*
* This sample shows how to list
all the names from the EMP table
*
* It uses the JDBC THIN
driver. See the same program in the
* oci8
samples directory to see how to use the other drivers.
*/
// You
need to import the java.sql package to use JDBC
import java.sql.*;
class Employee
{
public
static void main (String args [])
throws
SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
// Connect
to the database
// You
must put a database name after the @ sign in the connection URL.
// You
can use either the fully specified SQL*net syntax or a short cut
// syntax as <host>:<port>:<sid>. The example uses
the short cut syntax.
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@Verlag:1721:dbms733", "scott",
"tiger");
// Create a Statement
Statement stmt = conn.createStatement
();
// Select the ENAME column from the EMP
table
ResultSet rset = stmt.executeQuery
("select ENAME from EMP");
// Iterate through
the result and print the employee names
while (rset.next ())
System.out.println
(rset.getString (1));
}
}
// Example 2
/*
* This sample shows how to list
all the names from the EMP table
*/
// You need to import the java.sql
package to use JDBC
import java.sql.*;
class Employee
{
public
static void main (String args [])
throws
SQLException
{
// Load the Oracle JDBC driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url
= "jdbc:oracle:oci8:@";
try {
String url1 = System.getProperty("JDBC_URL");
if
(url1 != null)
url = url1;
} catch (Exception e) {
// If there is any security
exception, ignore it
// and use the default
}
// Connect
to the database
Connection conn
=
DriverManager.getConnection
(url, "scott", "tiger");
// Create a Statement
Statement stmt = conn.createStatement ();
// Select the ENAME column
from the EMP table
ResultSet
rset = stmt.executeQuery
("select ENAME from EMP");
// Iterate
through the result and print the employee names
while (rset.next ())
System.out.println
(rset.getString (1));
// Close the RseultSet
rset.close();
// Close the Statement
stmt.close();
// Close the connection
conn.close();
}
}