public void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
javax.servlet.http.HttpSession session = request.getSession(true);
com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication();
javax.servlet.ServletContext application = _jsp_application;
com.caucho.jsp.PageContextImpl pageContext =
com.caucho.jsp.QJspFactory.allocatePageContext(
this, _jsp_application, request, response, "/error.jsp", session, 8192, true);
javax.servlet.jsp.JspWriter out = pageContext.getOut();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
response.setContentType("text/html");
try {
out.write(_jsp_string0, 0, _jsp_string0.length);
out.print(((String) session.getAttribute("user")));
out.write(_jsp_string1, 0, _jsp_string1.length);
out.print(((String) session.getAttribute("db")));
out.write(_jsp_string2, 0, _jsp_string2.length);
// get all tables in the database
ConDB dbcon = (ConDB) session.getAttribute("dbcon");
Connection conn = dbcon.get();
int total_rec = 0;
int total_table = 0;
String sql = "show tables";
PreparedStatement pstm = null;
ResultSet rs = null;
try {
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
} catch (SQLException e) {
out.println(e);
}
// count the records of each table
while (rs.next()) {
String curr_tb = rs.getString(1);
int curr_rec = 0;
PreparedStatement pstm_rec = null;
ResultSet rs_rec = null;
sql = "select count(*) from " + curr_tb;
try {
pstm_rec = conn.prepareStatement(sql);
rs_rec = pstm_rec.executeQuery();
} catch (SQLException e) {
out.println(e);
}
try {
if (rs_rec.next()) {
curr_rec = rs_rec.getInt(1);
total_rec += curr_rec;
}
} catch (SQLException e) {
out.println(e.getErrorCode() + "---" + e.getSQLState());
}
total_table++;
out.write(_jsp_string3, 0, _jsp_string3.length);
out.print((total_table & 1));
out.write(_jsp_string4, 0, _jsp_string4.length);
out.print((curr_tb));
out.write(_jsp_string5, 0, _jsp_string5.length);
out.print((curr_tb));
out.write(_jsp_string6, 0, _jsp_string6.length);
out.print((curr_tb));
out.write(_jsp_string7, 0, _jsp_string7.length);
out.print((curr_tb));
out.write(_jsp_string8, 0, _jsp_string8.length);
out.print((curr_tb));
out.write(_jsp_string9, 0, _jsp_string9.length);
out.print((curr_rec));
out.write(_jsp_string10, 0, _jsp_string10.length);
}
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((total_table));
out.write(_jsp_string12, 0, _jsp_string12.length);
out.print((total_rec));
out.write(_jsp_string13, 0, _jsp_string13.length);
out.print((session.getAttribute("db")));
out.write(_jsp_string14, 0, _jsp_string14.length);
} catch (java.lang.Throwable _jsp_e) {
pageContext.handlePageException(_jsp_e);
} finally {
com.caucho.jsp.QJspFactory.freePageContext(pageContext);
}
}
public void _jspService(
javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException {
javax.servlet.http.HttpSession session = request.getSession(true);
com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication();
javax.servlet.ServletContext application = _jsp_application;
com.caucho.jsp.PageContextImpl pageContext =
com.caucho.jsp.QJspFactory.allocatePageContext(
this, _jsp_application, request, response, null, session, 8192, true, false);
javax.servlet.jsp.JspWriter out = pageContext.getOut();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
response.setContentType("text/html");
try {
uk.ac.dundee.computing.stewarttaylor.UserBean userBean;
synchronized (session) {
userBean = (uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean");
if (userBean == null) {
userBean = new uk.ac.dundee.computing.stewarttaylor.UserBean();
session.setAttribute("userBean", userBean);
}
}
out.write(_jsp_string0, 0, _jsp_string0.length);
uk.ac.dundee.computing.stewarttaylor.UserBean userBean2;
synchronized (session) {
userBean2 =
(uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean2");
if (userBean2 == null) {
userBean2 = new uk.ac.dundee.computing.stewarttaylor.UserBean();
session.setAttribute("userBean2", userBean2);
}
}
out.write(_jsp_string1, 0, _jsp_string1.length);
uk.ac.dundee.computing.stewarttaylor.UserBean uBean2 =
(uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean");
String sName = uBean2.getUsername();
out.write(_jsp_string2, 0, _jsp_string2.length);
out.print(sName);
out.write(_jsp_string3, 0, _jsp_string3.length);
out.print(sName);
out.write(_jsp_string4, 0, _jsp_string4.length);
uk.ac.dundee.computing.stewarttaylor.MessageBean msgBean;
synchronized (session) {
msgBean =
(uk.ac.dundee.computing.stewarttaylor.MessageBean) session.getAttribute("msgBean");
if (msgBean == null) {
msgBean = new uk.ac.dundee.computing.stewarttaylor.MessageBean();
session.setAttribute("msgBean", msgBean);
}
}
out.write(_jsp_string5, 0, _jsp_string5.length);
try {
String[] names = msgBean.getUsername();
String[] dates = msgBean.getDate();
String[] messages = msgBean.getMessage();
String[] images = msgBean.getImage();
boolean[] canDelete = msgBean.getCanDelete();
int[] id = msgBean.getID();
for (int i = 0; i < names.length; i++) {
out.write(_jsp_string6, 0, _jsp_string6.length);
out.println(names[i]);
out.write(_jsp_string3, 0, _jsp_string3.length);
out.println(names[i]);
out.write(_jsp_string7, 0, _jsp_string7.length);
if (canDelete[i] == true) {
out.write(_jsp_string8, 0, _jsp_string8.length);
out.println(id[i]);
out.write(_jsp_string9, 0, _jsp_string9.length);
}
out.write(_jsp_string10, 0, _jsp_string10.length);
out.println(images[i]);
out.write(_jsp_string11, 0, _jsp_string11.length);
out.println(dates[i]);
out.write(_jsp_string12, 0, _jsp_string12.length);
out.println(messages[i]);
out.write(_jsp_string13, 0, _jsp_string13.length);
}
} catch (Exception E) {
out.println("<h3> No Posts Retrieved</h3>");
}
out.write(_jsp_string14, 0, _jsp_string14.length);
} catch (java.lang.Throwable _jsp_e) {
pageContext.handlePageException(_jsp_e);
} finally {
com.caucho.jsp.QJspFactory.freePageContext(pageContext);
}
}