Hi!
Here is a simple example of query in JSP.
(using oracle database and need BONUS table--anything can do)
<%@ page language="java" import="java.sql.*" contentType="text/html" %>
<%
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection Conn =
DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:sky0704","SCOTT","TIGER");
Statement stmt = Conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from BONUS");
if (rs==null)
{
out.println("Nothing here");
}
else {
out.println("Something here");
}
stmt.close();
Conn.close();
%>
Good Luck!!
------------------
[This message has been edited by sky0704 (edited July 17, 2001).]
[This message has been edited by sky0704 (edited July 17, 2001).]