<%@ page language = "java" import = "java.sql.*,java.io.*,java.util.*" %> <%! public Connection con = null; public String dirPath = "../"; public String mandatory = "*"; public final String SITE_NAME = "Guest Book"; public static int parseInt(String source) { return parseInt(source, defaultInt); } 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, defaultString, 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 static String replace(String s, String s1, String s2) { while(s.indexOf(s1)>=0) { s = s.substring(0, s.indexOf(s1)) + s2 + s.substring(s.indexOf(s1) + s1.length(), s.length()); } return s; } public String getSelected(String lov, String v) { if(lov == null) lov = ""; if(v == null) v = ""; if(lov.equals(v)) return "selected"; return ""; } public String getSelected(int lov, int v) { if(lov == v) return "selected"; return ""; } 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) + " " + DateFormatter.getMonthName(cal.get(Calendar.MONTH)) + ", " + cal.get(Calendar.YEAR) + " " + cal.get(Calendar.HOUR_OF_DAY) + ":" + cal.get(Calendar.MINUTE) + ":" + cal.get(Calendar.SECOND); } 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; } %> <% /*try { //* Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String conStr = "jdbc:odbc:;Driver={Microsoft Access Driver (*.mdb)}; DBQ=" + getServletConfig().getServletContext().getRealPath("db/GuestBookDB.mdb") + ";"; final String GuestBookDBUser = ""; final String GuestBookDBPwd = ""; */ Class.forName("org.hsqldb.jdbcDriver"); //String conStr = "jdbc:hsqldb:/members/V0kIH8fZ9e4iM5SIWVenHOAoMPOTd91/GuestBook/DB/GuestBook"; String conStr = "jdbc:hsqldb:/members/N2kr27Ncx8bBYykewWfXrCeROfa7wAZp/GuestBook/DB/GuestBook"; final String GuestBookDBUser = "sa"; final String GuestBookDBPwd = ""; con = DriverManager.getConnection(conStr,GuestBookDBUser,GuestBookDBPwd); /*} catch(Exception e) { out.println("Exception caught : " + e.toString()); }*/ %>