long dCountRec(java.sql.Statement stat, String table, String sWhere) {
long lNumRecs = 0;
try {
java.sql.ResultSet rs =
stat.executeQuery("select count(*) from " + table + " where " + sWhere);
if (rs != null && rs.next()) {
lNumRecs = rs.getLong(1);
}
rs.close();
} catch (Exception e) {
}
;
return lNumRecs;
}
String dLookUp(java.sql.Statement stat, String table, String fName, String where) {
java.sql.Connection conn1 = null;
java.sql.Statement stat1 = null;
try {
conn1 = cn();
stat1 = conn1.createStatement();
java.sql.ResultSet rsLookUp =
openrs(stat1, "SELECT " + fName + " FROM " + table + " WHERE " + where);
if (!rsLookUp.next()) {
rsLookUp.close();
stat1.close();
conn1.close();
return "";
}
String res = rsLookUp.getString(1);
rsLookUp.close();
stat1.close();
conn1.close();
return (res == null ? "" : res);
} catch (Exception e) {
return "";
}
}
String getOptions(
java.sql.Connection conn,
String sql,
boolean isSearch,
boolean isRequired,
String selectedValue) {
String sOptions = "";
String sSel = "";
if (isSearch) {
sOptions += "<option value=\"\">All</option>";
} else {
if (!isRequired) {
sOptions += "<option value=\"\"></option>";
}
}
try {
java.sql.Statement stat = conn.createStatement();
java.sql.ResultSet rs = null;
rs = openrs(stat, sql);
while (rs.next()) {
String id = toHTML(rs.getString(1));
String val = toHTML(rs.getString(2));
if (id.compareTo(selectedValue) == 0) {
sSel = "SELECTED";
} else {
sSel = "";
}
sOptions += "<option value=\"" + id + "\" " + sSel + ">" + val + "</option>";
}
rs.close();
stat.close();
} catch (Exception e) {
}
return sOptions;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html");
pageContext = _jspxFactory.getPageContext(this, request, response, null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write('\n');
out.write('\n');
out.write('\n');
String cSec = checkSecurity(2, session, response, request);
if ("sendRedirect".equals(cSec)) return;
boolean bDebug = false;
String sAction = getParam(request, "FormAction");
String sForm = getParam(request, "FormName");
String seditorialsErr = "";
java.sql.Connection conn = null;
java.sql.Statement stat = null;
String sErr = loadDriver();
conn = cn();
stat = conn.createStatement();
if (!sErr.equals("")) {
try {
out.println(sErr);
} catch (Exception e) {
}
}
out.write('\n');
out.write(
"\n\n<html>\n<head>\n<title>Book Store</title>\n<meta name=\"GENERATOR\"\n\tcontent=\"YesSoftware CodeCharge v.1.2.0 / JSP.ccp build 05/21/2001\" />\n<meta http-equiv=\"pragma\" content=\"no-cache\" />\n<meta http-equiv=\"expires\" content=\"0\" />\n<meta http-equiv=\"cache-control\" content=\"no-cache\" />\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=ISO-8859-1\">\n</head>\n<body\n\tstyle=\"background-color: #FFFFFF; color: #000000; font-family: Arial, Tahoma, Verdana, Helveticabackground-color: #FFFFFF; color: #000000; font-family: Arial, Tahoma, Verdana, Helvetica\">\n");
org.apache.jasper.runtime.JspRuntimeLibrary.include(
request, response, "Header.jsp", out, true);
out.write("\n<table>\n\t<tr>\n\n\t\t<td valign=\"top\">\n\t\t");
editorials_Show(request, response, session, out, seditorialsErr, sForm, sAction, conn, stat);
out.write("\n\n\t\t</td>\n\t</tr>\n</table>\n\n");
org.apache.jasper.runtime.JspRuntimeLibrary.include(
request, response, "Footer.jsp", out, true);
out.write(
"\n<center><font face=\"Arial\"><small>This dynamic\nsite was generated with <a href=\"http://www.codecharge.com\">CodeCharge</a></small></font></center>\n</body>\n</html>\n");
out.write('\n');
if (stat != null) stat.close();
if (conn != null) conn.close();
out.write('\n');
} catch (Throwable t) {
if (!(t instanceof SkipPageException)) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0) out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
java.sql.ResultSet openrs(java.sql.Statement stat, String sql) throws java.sql.SQLException {
java.sql.ResultSet rs = stat.executeQuery(sql);
return (rs);
}