Load data from Oracle via OracleResultSet - Java JDBC

Java examples for JDBC:Oracle

  1. HOME
  2. Java
  3. JDBC
  4. Oracle

Description

Load data from Oracle via OracleResultSet

Demo Code


import java.util.*;
import java.sql.*;
import oracle.jdbc.*;
class Tabler/*from  w w w. j a  va  2 s . co m*/
{
  OracleConnection oconn;
  OracleStatement ostm;
  OracleResultSet ors;
  String scomm;
  String vusername,vpassword,url;
  Scanner sc = new Scanner(System.in);
  public Tabler()
  {
    try
    {
      DriverManager.registerDriver(new OracleDriver());
    }
                //catch(ClassNotFoundException ex)
    catch(SQLException ex)
    {
      System.out.println(ex.toString());
    }
    System.out.print("Enter User Name: ");
    vusername = sc.next();
    System.out.print("Enter Password: ");
    vpassword = sc.next();
    url = "jdbc:oracle:thin:@localhost:1521:ORCL";  
    try
    {
      oconn = (OracleConnection)DriverManager.getConnection(url,vusername,vpassword);  
    
      scomm = "select * from DEPT";
      //instantiating the oracle statement
      ostm = (OracleStatement)oconn.createStatement();  //The object of statement is responsible to execute queries with the database.  
      //instantiating the oracle resultset
                        
                        
                        /*
                            4) Execute the query
                            The executeQuery() method of Statement interface is used to execute queries to the
                            database. This method returns the object of ResultSet that can be used to get all the
                            records of a table.
                         */
      ors = (OracleResultSet)ostm.executeQuery(scomm);
      while(ors.next())
      {
        System.out.println(ors.getString(1));
      }  
      ors.close();
      ostm.close();
      oconn.close();
    }
    catch(SQLException ex)
    {
      System.out.println(ex.toString());
    }

  }
}
public class TableDisplayer
{
  public static void main(String [] args)
  {
    Tabler ro = new Tabler();
  }
}

Related Tutorials