sky0704

Greenhorn
+ Follow
since May 23, 2001
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by sky0704

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).]
22 years ago