Skip to main content

Connection over ORACLE 9i and JAVA with JDBC Provider

//Connection over ORACLE 9i and JAVA with JDBC Provider



import java.sql.*;
public class OCL
{
public static void main(String args[])
{
Driver d;
Connection con;
Statement stmt;
ResultSet rs;
try
{
    d=(Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
  con =DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:oramax","scott","tiger");
    stmt = con.createStatement();
    rs= stmt.executeQuery("select * from EMP");


    while(rs.next())
{
  System.out.println(rs.getString(1));
        System.out.print("\t"+rs.getString(2));
System.out.print("\t"+rs.getString(1)+"  "+rs.getString(2));
}
}
catch(Exception e)
{
System.out.println("in IllegalAccess exception");

}
}
}

Comments