Oracle JDBC: select : SQL Select Query « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. SQL Select Query

Oracle JDBC: select

/*

Java Programming with Oracle JDBC
by Donald Bales 
ISBN: 059600088X
Publisher: O'Reilly

*/

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class TestOCIApp {

  public static void main(String args[]) throws ClassNotFoundException,
      SQLException {

    Class.forName("oracle.jdbc.driver.OracleDriver");
    // or you can use:
    //  DriverManager.registerDriver(
    //   new oracle.jdbc.driver.OracleDriver());
    Connection conn = DriverManager.getConnection(
        "jdbc:oracle:oci8:@dssnt01", "scott", "tiger");

    Statement stmt = conn.createStatement();
    ResultSet rset = stmt
        .executeQuery("select 'Hello OCI driver tester '||USER||'!' result from dual");
    while (rset.next())
      System.out.println(rset.getString(1));
    rset.close();
    stmt.close();
    conn.close();
  }
}


           
       

Related examples in the same category