java oracle connectivity

[rupakdutta]

hi
is there anybody to tell hw to connect java with oracle 8 or oracle 9i......
Thanx ...............

[Dillinger4]

You can use the java.sql.DriverManager class to connect to a backend.

[moinkhan]

Here is a rough example

try
{
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     String url = "jdbc:oracle:thin:@" + "rs4" + ":" + "1521" + ":" + "devlop";
     Connection con = DriverManager.getConnection(url,"express","care");
     PreparedStatement pst = con.prepareStatement("Select " + sysdate + " from dual");
     ResultSet rst = pst.executeQuery();
     if(rst.next())
    {
       String num = rst.getString(1);
       setVariable(varname,num);
       msg=" OK";
       return num +"";
    }
 }
 catch(Exception e)
 {
 }