this jsp page presents headings, it does not pull back results, why?

johnpele · Mar 4, 2003

<HTML>
<HEAD>

<title>Employee List</title>

</head>
<BODY>
<%@ page language="java" contentType="text/html" import="java.sql.*" %>
<TABLE BORDER=1 width="75%">
<TR><TH>Last Name</TH><TH>First Name</TH></TR>
<%

Connection conn = null;
Statement st = null;
ResultSet rs = null;
try{

// Load Oracle driver
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

// Connect to the database
String dbaddress = ("jdbc

racle:thin

macha.wit.ie:1521:MACH&quot

;
conn = DriverManager.getConnection ("jdbc

racle:thin

macha.wit.ie:1521:MACH", "W99418665","QEGXZA&quot

;

st = conn.createStatement();
rs = st.executeQuery("SELECT * FROM employees&quot

;
while (rs.next()) {

%>

<TR><TD><%= rs.getString("lname_txt&quot

%></TD>
<TD><%= rs.getString("fname_txt&quot

%></TD></TR>
<%
}
%>
</TABLE>
<%
} catch (Exception ex){
ex.printStackTrace();
%>
</table>
Oooops, something bad happened:
<%
} finally {
if (rs != null) rs.close();
if (st != null) st.close();
if (conn != null) conn.close();
}
%>
</BODY>

palbano · Mar 4, 2003

do you get an error message? Make sure you "View/Source" from the browser.

-pete

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

this jsp page presents headings, it does not pull back results, why?

johnpele

Technical User

palbano

Programmer

Similar threads

Part and Inventory Search

Sponsor