Register Oracle Server - Java JDBC

Java examples for JDBC:Oracle

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

Description

Register Oracle Server

Demo Code

/*//from   w  ww .  jav  a2s. co m
The DriverManager class acts as an interface between user and
drivers.
The DriverManager class maintains a list of Driver classes that have registered themselves by
calling the method DriverManager.registerDriver().
*/

import java.util.*;
import java.sql.*;
import oracle.jdbc.*;
class RegisOpen
{
  OracleConnection oconn;
  String HOSTNAME,PORTNUMBER,SID;
  String vusername,vpassword,url;
  Scanner sc = new Scanner(System.in);
  public RegisOpen()
  {
    try
    {
      Class.forName("oracle.jdbc.driver.OracleDriver");
      System.out.println("Oracle Drivers within the current java program has been registered successfully");    
    }
                //catch(SQLException ex)
    catch(ClassNotFoundException ex)
    {
      System.out.println(ex.toString());
    }
    System.out.print("Enter Host Name: ");
    HOSTNAME = sc.next();
    System.out.print("Enter Port Number: ");
    PORTNUMBER = sc.next();
    System.out.print("Enter SID: ");
    SID = sc.next();
    System.out.print("Enter User Name: ");
    vusername = sc.next();
    System.out.print("Enter Password: ");
    vpassword = sc.next();
    url = "jdbc:oracle:thin:@" + HOSTNAME + ":" + PORTNUMBER + ":" + SID;  
    try
    {
      oconn = (OracleConnection)DriverManager.getConnection(url,vusername,vpassword);  
      System.out.println("Connection established successfully");
                        oconn.close();
    }
    catch(SQLException ex)
    {
      System.out.println(ex.toString());
    }
  

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

Related Tutorials