<%@ page language = "java" import = "java.sql.*,java.io.*,java.util.*" %> <%! public static String monthNames[] = {"January","February","March","April","May","June","July","August","September","October","November","December"}; public String mandatory = "*"; public final String SITE_NAME = "Guest Book"; private String getStringFromReader (Reader reader) throws SQLException { String temp = ""; try { if(reader != null) { int c = 0; while(c != -1) { c = reader.read(); if(c != -1) { temp += (char)c; System.out.print("\n"+ ((char)c) ); } } reader.close(); } } catch(IOException e) { throw new SQLException("Custom SQLException : Unable to read data from java.io.Reader > " + e.toString()); } return temp; } public String formatDate(Timestamp ts) { if ( ts == null) return ""; Calendar cal = Calendar.getInstance(); cal.setTime(new java.util.Date(ts.getTime())); return "" + cal.get(Calendar.DATE) + " " + monthNames[cal.get(Calendar.MONTH)+1] + ", " + cal.get(Calendar.YEAR) + " " + cal.get(Calendar.HOUR_OF_DAY) + ":" + cal.get(Calendar.MINUTE) + ":" + cal.get(Calendar.SECOND); } public static int parseInt(String source) { return parseInt(source, 0); } public static int parseInt(String source,int dInt) { try { return Integer.parseInt(source); } catch(Exception e) { return dInt; } } public static String parseString(String source) { return parseString(source, "", true); } public static String parseString(String source, String dString) { return parseString(source, dString, true); } public static String parseString(String source, String dString, boolean allowNullString) { try { if(source == null) return dString; if(source.equals("") && !allowNullString) return dString; return source; } catch(Exception e) { return dString; } } public String getFullName (String fn, String mn, String ln) { String name = parseString(fn); String temp = parseString(mn); if(!temp.equals("")) { if(name.equals("")) name = temp; else name += " " + temp; } temp = parseString(ln); if(!temp.equals("")) { if(name.equals("")) name = temp; else name += " " + temp; } if(name.equals("")) name = "Anonymous"; return name; } %> <% Boolean adminLogged = (Boolean)session.getValue("adminLogged"); if (adminLogged==null) adminLogged = new Boolean(false); if(!adminLogged.booleanValue()) response.sendRedirect("admin.jsp?isErr=" + response.encodeURL("You need to login first !")); Class.forName("org.hsqldb.jdbcDriver"); String conStr = "jdbc:hsqldb:" + application.getRealPath("/~smhumayun/GuestBook/GuestBook"); final String GuestBookDBUser = "sa"; final String GuestBookDBPwd = ""; Connection con = DriverManager.getConnection(conStr,GuestBookDBUser,GuestBookDBPwd); %> JavaServerfaces.co.uk Admin Page in JSP
GUEST BOOK ADMIN STAFF LOG OUT

Here you can enable the comments.
Just simply select
comments that you want to edit and select the option from drop down menu.
click Go.
<% String isErr = parseString(request.getParameter("isErr")); if(!isErr.equals("")) out.println("

" + isErr + "
"); %>

Select an operation to perform :
<% int c = 0; int UID = parseInt(request.getParameter("UID"),0); ResultSet rs = con.createStatement().executeQuery("select * from GuestBook order by EntryDate"); while ( rs.next()) { int tempUID = parseInt(rs.getString("UID"),0); String Email = parseString(rs.getString("Email")); if ( UID == tempUID ) { %> <% } else { %> <% } c++; } %>
Name Email Entry Date Status Comments
<%=getFullName(rs.getString("FirstName"), rs.getString("MiddleName"), rs.getString("LastName"))%> <%=Email%> <%=formatDate(rs.getTimestamp("EntryDate"))%> <%=(rs.getBoolean("Status")? "Enable" : "Disable")%> Close
<%=rs.getString("Comments")%>
<%=getFullName(rs.getString("FirstName"), rs.getString("MiddleName"), rs.getString("LastName"))%> <%=Email%> <%=formatDate(rs.getTimestamp("EntryDate"))%> <%=(rs.getBoolean("Status")? "Enable" : "Disable")%> Open