Connect Java with Oracle Database


Prev Tutorial Next Tutorial

Connect Java with Oracle Database

Oracle corporation has provided two Jdbc driver software for connection java application to a database of oracle server.

  • Oracle oci driver.
  • Oracle thin driver.
connect java with oracle

For connecting java application with the oracle database, we need to follow below steps. In this example we are using Oracle 10g as the database. So we need to know following information for the oracle database.

The following are the connection properties of oracle thin driver.

Driver Class: Oracle.Jdbc.OracleDriver
Connection url: jdbc:oracle:thin:@localhost:1521:xe
Username:The default username for the oracle database is system.
passwordPassword is given by the user at the time of installing the oracle database.

jdbc:oracle:thin:@localhost:1521:x

  • jdbc is the API
  • oracle is the database
  • thin is the driver
  • localhost is the server name on which oracle is running, we may also use IP address
  • 1521 is the port number and
  • XE is the Oracle service name.

Note: You may get all above information from the tnsnames.ora file.

Create a table in oracle database

create table student(roll number(10),name varchar2(40));  

Example to Connect Java Application with Oracle database

import java.sql.*;  
class OracleCon
{  
public static void main(String args[]){  
try
{  
//step1 load the driver class  
Class.forName("oracle.jdbc.driver.OracleDriver");  
  
//step2 create  the connection object  
Connection con=DriverManager.getConnection(  
"jdbc:oracle:thin:@localhost:1521:xe","system","oracle");  
  
//step3 create the statement object  
Statement stmt=con.createStatement();  
  
//step4 execute query  
ResultSet rs=stmt.executeQuery("select * from student");  
while(rs.next())  
System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"  "+rs.getString(3));  
  
//step5 close the connection object  
con.close();  
  
}
catch(Exception e)
{
 System.out.println(e);
}  
}  
}  

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements