how conncet the oracle database by using JSP. Reteriving the data from database by using JSP.

Hi Madhulatha Laddika,

What type of connection are you planning to use?
e.g. Pool Connecion or Driver Connection.
Pool Connection is via the Web Server while Driver Connection is using calling the database via the respective database JDBC Drivers.

Code:
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection( database ,"","");

Thanks,
Riju.

import java.io.*;
import java.sql.*;

public class OraThin {
public static void main(String[] args) {
try {
Connection con=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(
"jdbcracle:thin:@machine_name:1521:database_name",
"scott",
"tiger");
Statement s=con.createStatement();
s.execute("
INSERT INTO BOOKS VALUES
(
'A Tale of Two Cities',
'William Shakespeare',
4567891231,
'5-JAN-1962'
)
");
s.close();
con.close();
} catch(Exception e){e.printStackTrace();}
}
}

mport java.io.*;
import java.sql.*;

public class ConnectionManager {

public Connection getConnection {
try {
Connection con=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection(
"jdbcracle:thin:@machine_nameort:database_name","username","password");
return con;
} catch(Exception e){e.printStackTrace();}
}
}

This class return the connection with oracle db. so make a onject of this class and call a getConnection method and take connection like...
ConnectionManager cm = new ConnectionManager();
Connection con=cm.getConnection();

Thx
Amit Jain