<%@ page language="java" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.PrintWriter" %>
<%@ page import="com.aha.search.*" %>
<%@ page import="com.aha.util.*" %>
<%@ page import="com.aha.data.db.OracleBean" %>
<%
// use ts=4 for vi
// rewritten by R. A. Kosman, 5/1/03-ish
%>
<%!
// declaratives, including methods
String searchResults = "Nsearch_results.jsp";
javax.servlet.jsp.JspWriter Out = null; // will be set to "out"
OracleBean dbBean = null; // used to talk to the Db
Hashtable topicContext = null;
Hashtable contentContext = null;
Hashtable domainContext = null;
String searchTextParam = "";
String beforeMonth = "";
String beforeDay = "";
String beforeYear = "";
String afterMonth = "";
String afterDay = "";
String afterYear = "";
String warning = "";
boolean debug=false;
boolean ssi = false;
// split a string, s, around position n.
// try find the next blank close to position n.
// if one is not close, just split with hyphen.
// use ");
Out.println("" + header + " ");
for (int i=start;i<=end;i++) {
Out.print("" + i + " ");
}
Out.println(" ");
}
private void genDateSelect(
String monName, String dayName, String yearName,
String selectedMonth, String selectedDay, String selectedYear)
throws java.io.IOException
{
int selMonVal = 0, selDayVal = 0, selYearVal = 0;
try { selMonVal = Integer.parseInt(selectedMonth); } catch (Exception e) { /* ignore */ }
try { selDayVal = Integer.parseInt(selectedDay); } catch (Exception e) { /* ignore */ }
try { selYearVal = Integer.parseInt(selectedYear); } catch (Exception e) { /* ignore */ }
genList(monName,"MM",1,12,selMonVal);
genList(dayName,"DD",1,31,selDayVal);
int cyr = java.util.Calendar.getInstance().get(Calendar.YEAR);
genList(yearName,"YYYY",1996,cyr,selYearVal);
}
private void selectAfterDate() throws java.io.IOException {
genDateSelect("after_month","after_day","after_year",
afterMonth, afterDay, afterYear);
}
private void selectBeforeDate() throws java.io.IOException {
genDateSelect("before_month","before_day","before_year",
beforeMonth, beforeDay, beforeYear);
}
private void selectTopic() throws java.io.IOException, java.sql.SQLException
{
// Get the topics from the database and create select drop down
String currTopic = "";
Iterator it = null;
dbBean.setSQL(OracleBean.SELECT_TOPICS_ALL);
ResultSet rs = dbBean.execute();
ArrayList topics = DataConverter.createStringArrayList(rs, "name");
if(topics != null) {
it = topics.iterator();
Out.println("");
while (it.hasNext()) {
currTopic = (String)it.next();
String selected = null;
selected = "";
if (topicContext.get(currTopic.toLowerCase()) != null) selected = " selected ";
Out.println("" + currTopic + " ");
}
Out.println(" ");
}
else Out.println("All Internal Error in processing content type: " + e.getMessage() +
"
\n");
e.printStackTrace(new PrintWriter(Out));
Out.println("\n ");
}
}// end of selectContentType()
private void selectDomain() throws java.io.IOException
{
// group and display the domains logically
try {
ArrayList catg = new ArrayList();
dbBean.setSQL("SELECT " +
" dc.name category_name, dom.name domain_name, dom.domain domain_abbrev " +
" FROM domain dom, domaincategory dc " +
" WHERE dom.categoryid = dc.categoryid " +
" ORDER BY dc.name, dom.domain");
// eg: dc.name: "Advocacy"; dom.name: "American Hospital Association"; dom.domain: "AHA"
ResultSet rs = dbBean.execute();
String lastCatg = "";
String content = "";
Out.println("\n");
// one category group per table column
while (rs.next()) {
String category_name = rs.getString(1);
String domain_name = rs.getString(2);
String domain_abbrev = rs.getString(3);
if (lastCatg.length() == 0 || !lastCatg.equals(category_name)){
// starting a new category grouping
if (lastCatg.length() > 0) content += "
\n";
content += "" + category_name +
" \n" + "");
}
catch (Exception e) {
Out.println("Internal Error in processing domains: " + e.getMessage() +
"
\n");
e.printStackTrace(new PrintWriter(Out));
Out.println("\n ");
}
} // end of selectDomain()
%>
<%
// make globally known to static methods
Out = out;
try { // the end of the try is at the very bottom of this
dbBean = new OracleBean();
%>
<%
if (request.getParameter("debug") != null) debug = true;
if (request.getParameter("ssi") != null) ssi = true;
// possible contextual form fields
String [] contentParam = request.getParameterValues("content");
String [] domainParam = request.getParameterValues("domain");
String [] topicParam = request.getParameterValues("topic");
searchTextParam = request.getParameter("search"); // free text "keywords"
if (searchTextParam == null) searchTextParam = "";
beforeMonth = request.getParameter("before_month");
beforeDay = request.getParameter("before_day");
beforeYear = request.getParameter("before_year");
afterMonth = request.getParameter("after_month");
afterDay = request.getParameter("after_day");
afterYear = request.getParameter("after_year");
contentContext = new Hashtable();
if (contentParam != null) {
for (int i=0;i list
for (int i=0;iNote: You got to this Advanced Search page from " +
"a previous Search Results page. Your options that were " +
"used in that previous search are set as defaults in this " +
"search form. Please clear them if you wish to change the " +
"context (scope) of your next search" +
"
Advanced Search
<%
// closure of the overall try
}
catch(Exception e) {
out.println("\nInternal error (fault) in advanced_search.jsp " +
"\n
Exception: " + e.getMessage() + "
");
e.printStackTrace(new PrintWriter(out));
}
finally {
if (dbBean != null) dbBean.close();
}
%>
