<%@ page import="java.sql.*" %> <% String connStr=request.getParameter("connStr"); if (connStr==null) { connStr=(String)session.getValue("connStr"); } else { session.putValue("connStr",connStr); } if (connStr==null) { %> <% } %> SimpleQuery JSP

Hello <%= (request.getRemoteUser() != null? ", " + request.getRemoteUser() : "") %> ! I am SimpleQuery JSP.

I will do a basic JDBC query to get employee data from EMP table in schema SCOTT..

<% try { // Use the following 2 files whening running inside Oracle 8i // Connection conn = new oracle.jdbc.driver.OracleDriver(). // defaultConnection (); Connection conn = DriverManager.getConnection(connStr, "scott", "tiger"); Statement stmt = conn.createStatement (); ResultSet rset = stmt.executeQuery ("SELECT ename, sal " + "FROM scott.emp ORDER BY ename"); if (rset.next()) { %> <% while (rset.next()) { %> <% } %>
Employee Name Salary
<%= rset.getString(1) %> $<%= rset.getDouble(2) %>
<%= rset.getString(1) %> $<%= rset.getDouble(2) %>
<% } else { %>

Sorry, the query returned no rows!

<% } rset.close(); stmt.close(); } catch (SQLException e) { out.println("

" + "There was an error doing the query:"); out.println ("

" + e + "
\n

"); } %>