<%@page import="java.sql.*"%>
<%@page import="java.math.*"%>
<%@page import="jls.*"%>
<%@ include file="includes/dbfunctions.jsp"%>
<%@ include file="includes/common.jsp"%>
<%
if (request.getParameter("pageType") != null && request.getParameter("pageType").equals("menu")) {
Statement sqlQry = myConn.createStatement();
String theSQL = "SELECT menuTitle FROM menu WHERE menuid=" + pageID + ";";
ResultSet rsReturned = sqlQry.executeQuery(theSQL);
if (rsReturned.next()) {
pageTitle = rsReturned.getString("menuTitle");
} else {
pageTitle = "Not Found";
}
}
%>
<%@ include file="includes/standardheader.jsp"%>
<%
//Begin page content
Statement sqlQry = myConn.createStatement();
if (request.getParameter("pageType") != null && request.getParameter("pageType").equals("menu")) {
String theSQL = "SELECT * FROM menu WHERE menuParent=" + pageID + ";";
ResultSet rsReturned = sqlQry.executeQuery(theSQL);
while (rsReturned.next()) {
menuLink = rsReturned.getString("menuLink");
if (rsReturned.getInt("linkType") == 2) {
menuLink = "index.jsp?pageID=" + menuLink + "&pageType=content";
} else if (rsReturned.getInt("linkType") == 1) {
menuLink = "index.jsp?pageID=" + rsReturned.getString("menuID") + "&pageType=menu";
}
%>
<%=rsReturned.getString("menuTitle")%>
![[line]](images/line.gif)
<%=rsReturned.getString("menuDescription")%>
<%
}
rsReturned.close();
} else {
String theSQL = "SELECT * FROM pageContent WHERE pageid=" + pageID + ";";
ResultSet rsReturned = sqlQry.executeQuery(theSQL);
while (rsReturned.next()) {
%>
<%=rsReturned.getString("itemTitle")%>
<%=rsReturned.getString("itemContent")%>
<%
}
rsReturned.close();
}
//End page content
%>
<%@ include file="includes/footer.jsp"%>