Connect Oracle Table using JDBC

Connect Oracle Table using JDBC

We can connect oracle database using JDBC (JAVA). There are four steps to connect oracle database using JDBC :

1) Register the JDBC driver
    eg : Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
2) Open a connection
    eg : con=DriverManager.getConnection("jdbc:odbc:data","scott","tiger");
3) Create statement
    eg : stmt=con.createStatement();
4) Execute a Query and Extract data from table
    eg : rs=stmt.executeQuery("select * from table");
   
Following is the code to connect oracle database table.

    import java.sql.*;
    public class DataBase
    {
    Statement stmt;
    Connection con;
    ResultSet rs;
    public DataBase()

    {

        try{

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con=DriverManager.getConnection("jdbc:odbc:data","scott","tiger");
        stmt=con.createStatement();
        rs=stmt.executeQuery("select * from table");
        while(rs.next())
        {
            System.out.print(rs.getInt(1));
            System.out.print(rs.getString(2));
            System.out.print(rs.getString(3));

        }

        }

        catch(Exception e){}

    }
    public static void main(String arg[])
    {
        DataBase db=new DataBase();
    }
}