<%@ page contentType="text/html"%> <%@ page info="database handler"%> <%@ page import="java.io.*"%> <%@ page import="java.util.*"%> <%@ page import="java.sql.*"%> <%@ page import="javax.servlet.*"%> <%@ page import="javax.servlet.http.*"%> <%@ page import="java.lang.Integer.*"%> <%@ page import="kitedb.KiteDB"%> <% KiteDB dbcon = new KiteDB(); dbcon.connectDB(); Connection conn = dbcon.getCon(); Statement stmt = dbcon.getStatement(); ResultSet rs; String[] test; test=dbcon.getArrayDB("SELECT * FROM Category order by categoryorder"); if(test==null) { out.println("To see this page, please go back to category management tool to add at least a category."); dbcon.disconnectDB(); }else{ %>

	Home CSPS		Search Bibliography		Search Engineering Inventory		Help

	Select one or more of the following options to begin your search.
	<% String tt; String link; String makeStr; String tt1; String tt2,kk1; String menuname1="dropdown"; String menuname2="popup"; String color; String[] ppp,aaa,bbb; aaa=dbcon.getArrayDB("SELECT * FROM category order by categoryorder"); if(aaa==null) dbcon.disconnectDB(); bbb=dbcon.getArrayDB("SELECT categoryname FROM category order by categoryorder"); if(bbb==null) dbcon.disconnectDB(); for(int coption=0;coption <% String menutypename; xxx=dbcon.getArrayDB("SELECT a.indexname FROM indexingterm a, categoryindex b " +" where a.indexingterm =b.tablename and b.category='"+tt2+"'" +" order by b.menuorder"); if(xxx!=null) { // yyy=dbcon.getArrayDB("SELECT indexingterm FROM indexingterm where indexingterm in (select tablename from categoryindex where Category='"+tt2+"')"+""); yyy=dbcon.getArrayDB("SELECT a.indexingterm FROM indexingterm a, categoryindex b " +" where a.indexingterm =b.tablename and b.category='"+tt2+"'" +" order by b.menuorder"); zzz=dbcon.getArrayDB("SELECT a.indextype FROM indexingterm a, categoryindex b " +" where a.indexingterm =b.tablename and b.category='"+tt2+"'" +" order by b.menuorder"); // zzz=dbcon.getArrayDB("SELECT indextype FROM indexingterm where indexingterm in (select tablename from categoryindex where Category='"+tt2+"')"+""); for(i=0;i > "> <% tt1 = zzz[i].trim(); if(tt1.compareTo(menuname1)==0) { %> <% } } } %> <% } } } %> <%= xxx[i]%> > "> select an option <% kkk=dbcon.getArrayDB("SELECT optionid FROM indexingtermoption where indexingterm ='"+ yyy[i].trim() +"' order by optionorder"); ppp=dbcon.getArrayDB("SELECT optionname FROM indexingtermoption where indexingterm ='"+ yyy[i].trim() +"' order by optionorder"); if(kkk!=null) { for(j=0;j <%= ppp[j] %> <% } } %> <% } else { if(tt1.compareTo(menuname2)==0) { %> <% //String tt; String nn,nn_text; String [] qqqq,pppp; qqqq=null; pppp=null; String ckbox=yyy[i]; //------------------- qqqq=dbcon.getArrayDB("SELECT optionname FROM indexingtermoption where indexingterm='"+ yyy[i].trim() +"' order by optionorder"); pppp=dbcon.getArrayDB("SELECT optionid FROM indexingtermoption where indexingterm='"+ yyy[i].trim() +"' order by optionorder"); int jj; if(qqqq!=null) { jj=qqqq.length; int jj1 = jj / 2; int jj2 = jj - jj1; for(int f=0;f"); out.println(""); out.println(f+1); out.println("."); out.println(tt); out.println(" "); }//end for %> <% for(int f=jj1;f"); out.println(""); out.println(f+1); out.println("."); out.println(tt); out.println(" "); }//end for }//end if %>

Number of retrieval results per page: 10 20 40

---

This case library is optimized for viewing in Microsoft Internet Explorer 5.5 or higher,Netscape Navigator 6 or higher. CSPS Group, School of Information Science & Learning Technology, University of Missouri at Columbia.

<% } stmt.close(); conn.close(); dbcon.disconnectDB(); %>