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

Popular posts from this blog

Sample : String Reverse In Java

import java.io.*; class test {     public static void main(String args[])     {         DataInputStream in=new DataInputStream(System.in);         try         {             String text;             System.out.println("\nEnter The Text");             text=in.readLine();             System.out.println("\nIn Reverse Order::\n");             for(int i=text.length()-1;i>=0;i--)             {                 System.out.print(text.charAt(i));             }          ...

Getting Browser Information in javaScript

<html> <head> <script> function getBrowserName() { tag_link.innerHTML="You are surfing internet through  "+'<b>'+navigator.appName+'</b>'+" browser family." } </script> </head> <body onLoad="getBrowserName()"> <center> <p id="tag_link" style="font-size:30"></p> </center> </body> </html>