4639l1

Listing 1: showblog.jsp

<%@ page language="java" contentType="text/html" %>
<%@ page import="java.sql.*" %>

<HTML>
  <Head>
     <Title>Weblog</Title>
  </Head>
  <Body>

  <H1>Weblog</H1>

<%
  // Some private variables for logging into the
  // database
  String loginJdbc = "org.postgresql.Driver";
  String loginUser = "reuven";
  String loginPasswd = "";
  String loginUrl = "jdbc:postgresql://localhost/atf";

  // Load the PostgreSQL driver
  Class.forName(loginJdbc);
  Connection con = DriverManager.getConnection
            (loginUrl, loginUser, loginPasswd);

  // Declare our statement
  Statement statement = con.createStatement();

  // Make sure that only one thread handles this
  // statement at a time

	String query = "SELECT entry_date,
          entry_headline, ";
	query +=       "       entry_text ";
	query +=       "FROM   BlogEntries ";
	query +=       "ORDER BY entry_date DESC ";

	// Perform the query
	ResultSet rs = statement.executeQuery(query);
%>

<table>

<% while (rs.next()) { %>

  <tr>
     <td> <%= rs.getString("entry_date") %> </td>
     <td> <%= rs.getString("entry_headline") %> </td>
     <td> <%= rs.getString("entry_text") %></td>
  </tr>

<% } %>

</table>

  </Body>
</HTML>

