| /*
* 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());
// Connect to the database
// You can put a database name after the @ sign in the connection
URL.
Connection conn =
// DriverManager.getConnection ("jdbc:oracle:oci8:@", "scott",
"tiger");
// Modified by fuju@exzilla.net add connection string fujudb
for getconnection
DriverManager.getConnection ("jdbc:oracle:oci8:@fujudb",
"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();
}
}
|