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

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 {

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


Related examples in the same category

1.JDBC select
2.A trivial example of a database query performed with JDBC
3.Load MYSQL JDBC Driver and run the query
4.JDBC Reverse Select
5.Join two tables