Wednesday, June 17, 2009

Database Connection Jdbc with Oracle

import java.sql.*;
import javax.swing.*;

public class databaseConnection

{


public static String url,sql;
public static Connection con=null;
public static Statement stmt;



public void dbconnection()
{


try
{
url= "jdbc:odbc:information"; //database Name

String username = "system"; //Database server name
String password = "a"; //database server password

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

con=DriverManager.getConnection(url,username,password);

stmt=con.createStatement();


// JOptionPane.showMessageDialog(null,"Database is Connected");

}

catch(ClassNotFoundException ex)

{

JOptionPane.showMessageDialog(null, ex.getMessage());
System.out.println("Error connecting : \n "+ex.getMessage());


//exit if driver is not loaded.
System.exit(0);
}


catch(SQLException ce)
{

JOptionPane.showMessageDialog(null, ce.getMessage());

System.out.println(ce);
}


}


public static void main(String[] a) {

databaseConnection db=new databaseConnection();
db.dbconnection() ;


}

}

No comments:

Post a Comment