Hai
this might help u.
<%@ page import="java.sql.*" %>
<%! Connection con;Statement stmt;ResultSet rs,rsMaterial;String state,Fadd;%>
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc
racle:thin:scott/tiger@ipaddresswhere oracle is installed:1521:cle8i");
stmt = con.createStatement();
Bye
Jayanthi