<%@ page import="javax.servlet.*" %>
<%@ page import="javax.servlet.http.*" %>
<%@ page import="java.io.IOException" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.DateFormat" %>
<%@ page import="java.util.Properties" %>
<%@ page import="java.util.Random" %>
<%!
// GuestBook2Servlet, based on example from http://www.oreilly.com/catalog/msql/servlet.txt
// Very loosely based, as it turns out. I couldn't find adequate documentation to make that work.
/* Here's how to build the database:
mysqladmin create GUESTBOOK
mysql <");
results.last();
count = 0;
// print up to 5 rows going backwards
while (count < 5) {
String name, cmt, date;
name = results.getString(1);
if( results.wasNull() ) name = "Unknown User";
date = results.getString(2);
if( results.wasNull() ) date = curDateString();
cmt = results.getString(3);
if( results.wasNull() ) cmt= "No comment";
out.println("" + name + " on " + date);
cmt = noHTML(cmt);
out.println(" " + cmt + "
");
if (!results.previous()) break; // no more.
count++;
}
out.println("");
}
catch( Exception e ) {
out.println("Error: " + e.getMessage());
//println("EXC printComments(): " + e.getMessage());
e.printStackTrace();
}
finally {
if( conn != null ) {
try { conn.close(); }
catch( SQLException e ) { }
}
}
}
private String noHTML(String cmt) {
int ilt= cmt.indexOf('<');
int igt= cmt.indexOf('>');
if (ilt< 0 && igt< 0)
return cmt;
String tmp = "";
for (int i=0; i' ) tmp = tmp + ">";
else tmp = tmp + c;
}
return tmp;
}
private String fixComment(String comment) {
if( comment.indexOf('\'') != -1 ) {
String tmp = "";
for(int i=0; i
<%
// here's the void _jspService(request, response) code
try { ourInit(); } // bogus to have it here, but...
catch (Exception E) {
%>
<%= E.toString() %>
<%
}
String method= request.getMethod();
if (method.equals("GET")) doGetBody(out, request, response);
else doPostBody(out, request, response);
%>