|
<%
String Search=request.getParameter("Search");
String tSearch=request.getParameter("tSearch");
String dSearch=request.getParameter("dSearch");
String uSearch=request.getParameter("uSearch");
String aSearch=request.getParameter("aSearch");
Vector searchResults=new Vector();
if (Search!=null){
out.println("
Search Results
For a complete view of the entire archive in MS Excel Database Format Click Here.
");
Connection conn= null;
Class.forName ("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@129.128.199.91:1530:KINJI2";
conn = DriverManager.getConnection(url, "imanishi", "m0nk3y");
try {
if (tSearch.length()>0){
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT list, id, catid, catname FROM all_book_list where upper(list) like upper('%"+tSearch+"%')");
//Loop through results of query.
while(rs.next()){
String volumeTitle = rs.getString ("list");
String catid = rs.getString ("catid");
String id = rs.getString ("id").trim();
String catname = rs.getString("catname");
searchResults.add("Volume: "+volumeTitle+"
, , From Category: "+catname+"
");
}
int size=searchResults.size();
if (size>0){
out.println("The following volumes titles contain your search term.
Click on a volume title to view images or Search Again.
");
String results = searchResults.toString();
out.println(results);
}else{
out.println("There are no titles matching your search term - please Search Again.
");
}
}else if(dSearch.length()>0){
Statement stmt = conn.createStatement();
String query=("select distinct all_book_list.id, all_book_list.catid, all_book_list.catname, all_book_list.list from all_book_list, all_info where rtrim(all_book_list.id)=(substr(identifier,1,(instr(identifier,'0')-1))) and all_info.date_created like '%"+dSearch+"%'");
//Loop through results of query.
ResultSet rs = stmt.executeQuery(query);
while(rs.next()){
String volumeTitle = rs.getString ("list");
String catid = rs.getString ("catid");
String id = rs.getString ("id").trim();
String catname = rs.getString("catname");
searchResults.add("Volume: "+volumeTitle+"
, , From Category: "+catname+"
");
}
int size=searchResults.size();
if (size>0){
out.println("The following volumes contain images of documents created on your search date.
Click on a volume title to view imagesor Search Again.
");
String results = searchResults.toString();
out.println(results);
}else{
out.println("There are no titles matching your search term - please Search Again.
");
}
}else if(uSearch.length()>0){
Statement stmt = conn.createStatement();
String query=("select distinct all_info.identifier, all_book_list.id, all_book_list.catid, all_book_list.catname, all_book_list.list from all_book_list, all_info where rtrim(all_book_list.id)=(substr(identifier,1,(instr(identifier,'0')-1))) and all_info.identifier like upper('%"+uSearch+"%')");
//Loop through results of query.
ResultSet rs = stmt.executeQuery(query);
while(rs.next()){
String volumeTitle = rs.getString ("list");
String catid = rs.getString ("catid");
String id = rs.getString ("id").trim();
String catname = rs.getString("catname");
String uID = rs.getString("identifier").trim();
searchResults.add("Image Identifier:"+uID+"
Volume: "+volumeTitle+"
, , From Category: "+catname+"
");
}
int size=searchResults.size();
if (size>0){
out.println("The following images contain your search term.
Click on a volume title to view images or Search Again.
");
String results = searchResults.toString();
out.println(results);
}else{
out.println("There are no titles matching your search term - please Search Again.
");
}
}else if(aSearch.length()>0){
Statement stmt = conn.createStatement();
String query=("select distinct all_book_list.id, all_book_list.catid, all_book_list.catname, all_book_list.list from all_book_list where upper(all_book_list.list) like upper('%"+aSearch+"%') or upper(all_book_list.catname) like upper('%"+aSearch+"%')");
//Loop through results of query.
ResultSet rs = stmt.executeQuery(query);
while(rs.next()){
String volumeTitle = rs.getString ("list");
String catid = rs.getString ("catid");
String id = rs.getString ("id").trim();
String catname = rs.getString("catname");
searchResults.add("Volume: "+volumeTitle+"
, , From Category: "+catname+"
");
}
int size=searchResults.size();
if (size>0){
out.println("The following volumes contain your search term.
Click on a volume title to view images or Search Again.
");
String results = searchResults.toString();
out.println(results);
}else{
out.println("There are no titles matching your search term - please Search Again.
");
}
}
}catch(SQLException e){
out.println("SQLException: " + e.getMessage() + "
");
while((e = e.getNextException()) != null)
out.println(e.getMessage() + "
");
}finally{
//Clean up resources, close the connection.
if(conn != null){
try{
conn.close();
}
catch (Exception ignored) {}
}
}
}else{
out.println("
Search the Archives
");
out.println(" For a complete view of the entire archive in MS Excel Database Format Click Here.
");
out.println("");
}
%>
|
Search the Archive 