Oracle JDBC: select : SQL Select Query : Database SQL JDBC : Java examples (example source code) Organized by topic




/*



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

  }

}


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