//// 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();  

  }

}