<html>
 <body>
<%@ page import="java.sql.*"%>  <%
  String  url= "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.67)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=hydb)))";
    String user = "scott";
    String password = "tiger";    Statement     stmt=null;
    Connection    conn=null;
    ResultSet     rs=null;
      try{
        Class.forName("oracle.jdbc.driver.OracleDriver");
     conn = DriverManager.getConnection(url,user,password);
         stmt = conn.createStatement();
   
           rs=stmt.executeQuery("select * from dept");         while(rs.next()){
          out.print(rs.getString(1)+"<br>");
         }
          
        }catch(Exception e){
        out.print("Exception:"+e.getMessage());
       }
     rs.close();
    out.print("OK");
   %>
 </body>
 </html>