Java Oracle Connection

Step1 : First download the classes12.jar file.

Step2:  Add the jar file to java library path

For eclipse –  

goto Projectmenu--->properties--->Click Java Build Path ---> Libraries Tab—> Add External JARs

Example Program for JavaWithOracleConnection

Replace the bold values with your settings.

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class TestOracleConnection {

public static void main(String[] args) {

try {

Connection con = null;

Class.forName("oracle.jdbc.driver.OracleDriver");

con = DriverManager.getConnection(

"jdbc:oracle:thin:@ipaddressoforacleinstalledmachine:1521:databasename", "username",

"password");

Statement s = con.createStatement();

ResultSet rs = s.executeQuery("SELECT * from tablename");

while (rs.next()) {

System.out.println("Values------>" + rs.getString("columnname"));

}

s.close();

con.close();

} catch (Exception e) {

e.printStackTrace();

}

}

}