Total Pageviews

Search This Blog

Sunday, March 27, 2011

How to connect your java program with Oracle Database

package com.safiuz;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Manager4 {

public static void main(String[] args) {
//1. register driver
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ex){
ex.printStackTrace();
}
Connection con = null;
Statement stmt = null;
try
{
//2. Establish Database connection
con = DriverManager.getConnection("jdbc:odbc:oracle-datasource","system","great123");

//3. Get the Statement
stmt = con.createStatement();

//4. Compose Sql Query
String sql = "insert into tab1 values(4,'Safiuz')";

//5. trigger Sql query
int i = stmt.executeUpdate(sql);
System.out.println(i);
}
catch(SQLException ex){
ex.printStackTrace();
}
finally{
try{
//6. Close Database resources
if(stmt!= null){
stmt.close();
stmt= null;
}
}
catch(SQLException ex){
ex.printStackTrace();
}
try{
if(con!= null){
con.close();
con = null;
}
}
catch(SQLException ex){
ex.printStackTrace();
}
}
}
};

No comments:

Post a Comment