Connect to Oracle thin server - Java JDBC

Java examples for JDBC:Oracle

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

Description

Connect to Oracle thin server

Demo Code


import java.util.*;
import java.sql.*;
import oracle.jdbc.*;
class SingleValDisplay1
{
  OracleConnection oconn;/*w ww.j  a  va2s .c  o m*/
  OracleStatement ost;
  OracleResultSet ors;
  String scomm;
  String vusername,vpassword,url;
  Scanner sc = new Scanner(System.in);
  public SingleValDisplay1()
  {
    try
    {
      DriverManager.registerDriver(new OracleDriver());
    }
    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:@Islam-PC:1521:ORCL";  //change the hostname as per ur PC (ISlam-PC)
    try
    {
      oconn = (OracleConnection)DriverManager.getConnection(url,vusername,vpassword);    
    
      
      //instantiating the oracle statement
      ost = (OracleStatement)oconn.createStatement();  
      
      System.out.print("Please enter a Table Name to view its Single Value: ");
      String tableName = sc.next();
      scomm = "select * from "+tableName;
      ors = (OracleResultSet)ost.executeQuery(scomm);
      if(ors.next())
      {
        System.out.println("The Top - Left value is "+ors.getString(1));
      }
      else
      {
        System.out.println("Either Table does not exists or Records does not exists...");
      }
      ors.close();
      ost.close();
      oconn.close();
    }
    catch(SQLException ex)
    {
      System.out.println(ex.toString());
    }

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

Related Tutorials