Hi, trying to get simple sample database working.
Using NetBeans with GlassFish.
The browser fires, only get the database class??
No data, can anyone assist??
JSP output:
oracle.jdbc.driver.OracleDriver
NO error message
<%@ page import="java.sql.*" %>
<%_at_page contentType="text/html" pageEncoding="UTF-8"%>
<html>
<body>
<%
Connection con = null;
Statement st;
ResultSet rs;
String sql = "";
String ProjectID = "";
sql = "SELECT * FROM Project";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin_at_localhost:1521:test","test","test");
st = con.createStatement();
rs = st.executeQuery(sql);
%>
<table border=2>
<%
while(rs.next())
{
%> <tr>
<td><%=rs.getString("ProjectID")%></td>
<td><%=rs.getString("SubID")%></td>
<td><%=rs.getString("AsID")%></td>
<td><%=rs.getString("Name")%></td>
</tr>
<% } %>
</table>
<%
rs.close();
con.close();
}
catch(Exception ex)
{
out.print(ex.getMessage());
}
%>
</body>
</html>
[Message sent by forum member 'cliveswan' (clive.swan_at_ntlworld.com)]
http://forums.java.net/jive/thread.jspa?messageID=391076