4639l5 Listing 5: showblog.jsp <%@ page language="java" contentType="text/html" %> <%@ page import="java.sql.*" %> Weblog

Weblog

<% // 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); %> <% while (rs.next()) { %> <% } %>

<%= rs.getString("entry_date") %>

<%= rs.getString("entry_headline") %>

<%= rs.getString("entry_text") %>