Listing 1: Catalog.sql

CREATE TABLE Catalog(CatalogId INTEGER
PRIMARY KEY, Journal VARCHAR(25), Publisher VARCHAR(25),
 Edition VARCHAR(25), Title Varchar(45), Author Varchar(25));

INSERT INTO Catalog VALUES('1', 'Oracle Magazine', 'Oracle Publishing', 'Nov-Dec 2004',
'Database Resource Manager', 'Kimberly Floss');

INSERT INTO Catalog VALUES('2', 'Oracle Magazine', 'Oracle Publishing', 'Nov-Dec 2004', 
'From ADF UIX to JSF', 'Jonas Jacobi');

INSERT INTO Catalog VALUES('3', 'Oracle Magazine', 'Oracle Publishing', 'March-April 2005',
'Starting with Oracle ADF ', 'Steve Muench');
Listing 2: Catalog.jsp

<%@ page contentType="text/html"%>
<%@ page

import="java.sql.*,javax.sql.*,java.util.*,javax.naming.*"

%>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html">
    <title>JDBC JSP Application</title>
  </head>
<body>
 <%
    InitialContext ctx=new InitialContext();
    DataSource ds=(DataSource)ctx.lookup("jdbc/MySQLDS");
    Connection connection=ds.getConnection();
    Statement stmt=connection.createStatement();
    ResultSet resultSet=stmt.executeQuery("Select * from

Catalog");%>

    <table border="1" cellspacing="0">
        <tr>
          <th>CatalogId</th>
      <th>Journal</th>
      <th>Publisher</th>
         <th>Edition</th>

         <th>Title</th>
         <th>Author</th>
        </tr>
      <%
   while (resultSet.next())
        { %>
         <tr>


<td><%out.println(resultSet.getString(1));%></td>


<td><%out.println(resultSet.getString(2));%></td>


<td><%out.println(resultSet.getString(3));%></td>


<td><%out.println(resultSet.getString(4));%></td>


<td><%out.println(resultSet.getString(5));%></td>


<td><%out.println(resultSet.getString(6));%></td>
        </tr>
    <% } %>
    </table>
  </body