Open Oracle DB in JSP

Dev Shed Forums Sponsor:

March 13th, 2002, 11:03 AM

Web_Ronin

Registered User

Join Date: Mar 2002

Posts: 1

Time spent in forums: 15 m 44 sec
Reputation Power: 0

Open Oracle DB in JSP

I'm trying to locate an example of a simple JSP that opens an Oracle DB and displays the contents of a table. I didn't think it would be this difficult! All the examples and tutorials want me to build large projects and all I want to do is creat one JSP much the way I would take care of it in ColdFusion with a single .CFM.
Can anyone enlighten me? Am I missing something?

Thanks,

Jim

March 14th, 2002, 08:57 AM

pabloj

Modding: Oracle MsSQL Firebird

Dev Shed God 8th Plane (8500 - 8999 posts)

Join Date: Jun 2001

Location: Outside US

Posts: 8,527

Time spent in forums: 3 Months 1 Week 1 Day 3 h 19 m 49 sec
Reputation Power: 537

Take a look at this example:

Quote:

<%@ page import="java.sql.*" %>
<HTML>
<HEAD><TITLE>Simple Oracle Example</TITLE></HEAD>
<BODY BGCOLOR="#FFFFFF">
<CENTER>
<B>Employees</B>
<BR><BR>

<%
Connection conn = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection(
"jdbc

racle:thin:@HOST:PORT:SID",
"scott",
"tiger");

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Example.Emp");

//Print start of table and column headers
out.println("<TABLE CELLSPACING=\"0\" CELLPADDING=\"3\" BORDER=\"1\">");
out.println("<TR><TH>ID</TH><TH>NAME</TH></TR>");

//Loop through results of query.
while(rs.next())
{
out.println("<TR>");
out.println("<TD>" + rs.getString("EmpID") + "</TD>");
out.println("<TD>" + rs.getString("Name") + "</TD>");
out.println("</TR>");
}

out.println("</TABLE>");
}
catch(SQLException e)
{
out.println("SQLException: " + e.getMessage() + "<BR>");
while((e = e.getNextException()) != null)
out.println(e.getMessage() + "<BR>");
}
catch(ClassNotFoundException e)
{
out.println("ClassNotFoundException: " + e.getMessage() + "<BR>");
}
finally
{
//Clean up resources, close the connection.
if(conn != null)
{
try
{
conn.close();
}
catch (Exception ignored) {}
}
}
%>

</CENTER>
</BODY>
</HTML>

taken from http://elab-nt1.bus.umich.edu/howto_oracle_jsp.html http://www.classicity.com/oracle/ht...umID124/10.html

__________________
My blog
Tutorials about OSS databases, DBMonster ...
Contribute to OSS Development, fill bug reports!
Developer Shed eSupport
Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK)
An introduction to database normalization
Natural or Surrogate key
Custom ordering for your results
Correlated and uncorrelated subqueries
Don't turn your outer joins into inner joins
Random data (with a bias)

Viewing: Dev Shed Forums > Programming Languages > Java Help > Open Oracle DB in JSP

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump