<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import="java.sql.*"%> <%//Set databean to use - only used sometimes%> FReD Results <%//include sidebar%> <%@ include file="sidebar.jsp"%>

FReD Results

<% //retrieve Parameter values, set as session attributes int i; String[] display=request.getParameterValues("display"); if(request.getParameterValues("display")!=null) { } else { display=(String[])session.getAttribute("display"); } session.setAttribute("display", display); String idParam; if(request.getParameter("id")!=null) {idParam=request.getParameter("id");} else {idParam="%";} session.setAttribute("id", idParam); String labcodeParam; if(request.getParameter("labcode")!=null) {labcodeParam=request.getParameter("labcode");} else if(session.getAttribute("labcode")!=null) {labcodeParam=(String)session.getAttribute("labcode");} else {labcodeParam="%";} session.setAttribute("labcode", labcodeParam); String collectorParam; if(request.getParameter("Collector")!=null) {collectorParam=request.getParameter("Collector");} else if(session.getAttribute("collector")!=null) {collectorParam=(String)session.getAttribute("collector");} else {collectorParam="%";} session.setAttribute("collector", collectorParam); String BColourParam; if(request.getParameter("BColour")!=null) {BColourParam=request.getParameter("BColour");} else if(session.getAttribute("BColour")!=null) {BColourParam=(String)session.getAttribute("BColour");} else {BColourParam="%";} session.setAttribute("BColour", BColourParam); String HColourParam; if(request.getParameter("HColour")!=null) {HColourParam=request.getParameter("HColour"); } else if(session.getAttribute("HColour")!=null) {HColourParam=(String)session.getAttribute("HColour");} else {HColourParam="%";} session.setAttribute("HColour", HColourParam); String SectionParam = ""; if(request.getParameter("Section")!=""&request.getParameter("Section")!=null) {SectionParam=request.getParameter("Section");} else if(session.getAttribute("Section")!=""&session.getAttribute("Section")!=null) {SectionParam=(String)session.getAttribute("Section");} else {SectionParam="%";} session.setAttribute("Section", SectionParam); String familyParam = ""; if(request.getParameter("Family")!=""&request.getParameter("Family")!=null) {familyParam=request.getParameter("Family");} else if(session.getAttribute("family")!=""&session.getAttribute("family")!=null) {familyParam=(String)session.getAttribute("family");} else {familyParam="%";} session.setAttribute("family", familyParam); String genusParam = ""; if(request.getParameter("Genus")!=""&request.getParameter("Genus")!=null) {genusParam=request.getParameter("Genus");} else if(session.getAttribute("genus")!=""&session.getAttribute("genus")!=null) {genusParam=(String)session.getAttribute("genus");} else {genusParam="%";} session.setAttribute("genus", genusParam); String speciesParam = ""; if(request.getParameter("Species")!=""&request.getParameter("Species")!=null) {speciesParam=request.getParameter("Species");} else if(session.getAttribute("species")!=""&session.getAttribute("species")!=null) {speciesParam=(String)session.getAttribute("species");} else {speciesParam="%";} session.setAttribute("species", speciesParam); String countryParam=""; if(request.getParameter("Country")!=""&request.getParameter("Country")!=null) {countryParam=request.getParameter("Country");} else if(session.getAttribute("country")!=""&session.getAttribute("country")!=null) {countryParam=(String)session.getAttribute("country");} else {countryParam="%";} session.setAttribute("country", countryParam); String townParam = request.getParameter("Town"); if(townParam==""&session.getAttribute("town")==null) {townParam="%";} if(townParam==null) {townParam="%";} session.setAttribute("town", townParam); townParam = (String)session.getAttribute("town"); /* String GPS_EastParam=request.getParameter("GPS_East"); if(request.getParameter("E_deg")!=""&request.getParameter("E_deg")!=null) {GPS_EastParam=request.getParameter("E_deg");} else if(session.getAttribute("GPS_East")!=""&session.getAttribute("GPS_East")!=null) {GPS_EastParam=(String)session.getAttribute("GPS_East");} else {GPS_EastParam="%";} session.setAttribute("GPS_East", GPS_EastParam); String GPS_SouthParam=request.getParameter("GPS_South"); if(request.getParameter("GPS_South")!=""&request.getParameter("GPS_South")!=null) {GPS_SouthParam=request.getParameter("S_deg");} else if(session.getAttribute("GPS_South")!=""&session.getAttribute("GPS_South")!=null) {GPS_SouthParam=(String)session.getAttribute("GPS_South");} else {GPS_SouthParam="%";} session.setAttribute("GPS_South", GPS_SouthParam); */ String pollinatorParam; if(request.getParameter("Pollinator")!=""&request.getParameter("Pollinator")!=null) {pollinatorParam=request.getParameter("Pollinator");} else if(session.getAttribute("pollinator")!=""&session.getAttribute("pollinator")!=null) {pollinatorParam=(String)session.getAttribute("pollinator");} else {pollinatorParam="%";} session.setAttribute("pollinator", pollinatorParam); String orderParam = ""; if(request.getParameter("order")!=""&request.getParameter("order")!=null) {orderParam=request.getParameter("order");} else if(session.getAttribute("order")!=""&session.getAttribute("order")!=null) {orderParam=(String)session.getAttribute("order");} else {orderParam="id";} session.setAttribute("order", orderParam); String altitudeGParam=request.getParameter("altitude_greater"); /*if(request.getParameter("altitude_greater")!=""&request.getParameter("altitude_greater")!=null) {altitudeGParam=request.getParameter("altitude_greater");} if(session.getAttribute("altitudeG")!=""&session.getAttribute("altitudeG")!=null) {altitudeGParam=(String)session.getAttribute("altitudeG");} else {altitudeGParam = DataBean.getLower("altitude");} */ session.setAttribute("altitudeG", altitudeGParam); String altitudeLParam=request.getParameter("altitude_less"); /*if(request.getParameter("altitude_less")!=""&request.getParameter("altitude_less")!=null) {altitudeLParam=request.getParameter("altitude_less");} if(session.getAttribute("altitudeL")!=""&session.getAttribute("altitudeL")!=null) {altitudeLParam=(String)session.getAttribute("altitudeL");} else {altitudeLParam = DataBean.getHigher("altitude");} */ session.setAttribute("altitudeL", altitudeLParam); String heightGParam=request.getParameter("height_greater"); /*if(request.getParameter("height_greater")!=""&request.getParameter("height_greater")!=null) {heightGParam=request.getParameter("height_greater");} if(session.getAttribute("heightG")!=""&request.getParameter("heightG")!=null) {heightGParam=(String)session.getAttribute("heightG");} else {heightGParam = DataBean.getLower("height");}*/ session.setAttribute("heightG", heightGParam); String heightLParam=request.getParameter("height_less"); /*if(request.getParameter("height_less")!=""&request.getParameter("height_less")!=null) {heightLParam=request.getParameter("height_less");} if(session.getAttribute("heightL")!=""&session.getAttribute("heightL")!=null) {heightLParam=(String)session.getAttribute("heightL");} else {heightLParam = DataBean.getHigher("height");} */ session.setAttribute("heightL", heightLParam); String tubeGParam=request.getParameter("tube_greater"); /*if(request.getParameter("tube_greater")!=""&request.getParameter("tube_greater")!=null) {tubeGParam=request.getParameter("tube_greater");} if(session.getAttribute("tubeG")!=""&session.getAttribute("tubeG")!=null) {tubeGParam=(String)session.getAttribute("tubeG");} else {tubeGParam = DataBean.getLower("tube");} */ session.setAttribute("tubeG", tubeGParam); String tubeLParam=request.getParameter("tube_less"); /* if(request.getParameter("tube_less")!=""&request.getParameter("tube_less")!=null) {tubeLParam=request.getParameter("tube_less");} if(session.getAttribute("tubeL")!=""&session.getAttribute("tubeL")!=null) {tubeLParam=(String)session.getAttribute("tubeL");} else {tubeLParam = DataBean.getHigher("tube");}*/ session.setAttribute("tubeL", tubeLParam); String corollaGParam; if(request.getParameter("corolla_greater")!=""&request.getParameter("corolla_greater")!=null) {corollaGParam=request.getParameter("corolla_greater");} if(session.getAttribute("corollaG")!=""&session.getAttribute("corollaG")!=null) {corollaGParam=(String)session.getAttribute("corollaG");} else {corollaGParam = DataBean.getLower("corolla");} session.setAttribute("corollaG", corollaGParam); String corollaLParam; if(request.getParameter("corolla_less")!=""&request.getParameter("corolla_less")!=null) {corollaLParam=request.getParameter("corolla_less");} if(session.getAttribute("corollaL")!=""&session.getAttribute("corollaL")!=null) {corollaLParam=(String)session.getAttribute("corollaL");} else {corollaLParam = DataBean.getHigher("corolla");} session.setAttribute("corollaL", corollaLParam); /* String publishedParam = ""; if(request.getParameter("published")!=""&request.getParameter("published")!=null) {publishedParam=request.getParameter("published");} else if(session.getAttribute("published")!=""&session.getAttribute("published")!=null) {publishedParam=(String)session.getAttribute("published");} else {publishedParam="%";} session.setAttribute("published", publishedParam); */ String maincolourParam = ""; if(request.getParameter("maincol")!="yes") {maincolourParam=request.getParameter("maincol");} else {maincolourParam="%";} session.setAttribute("maincolour", maincolourParam); try {Class.forName("com.mysql.jdbc.Driver").newInstance();} catch(ClassNotFoundException exp) {out.println("Exception" + exp.getMessage());} %>

Click on a column header to order the results by a particular attribute. If you wish to order them by a new attribute,
click the Back button on your browser, then select a new column header.

<% StringBuffer linky = request.getRequestURL(); String qstring = request.getQueryString(); for(i=0;i"+display[i]+""); } try { Connection connection = DriverManager.getConnection("jdbc:mysql://mysql.positive-internet.com/fred", "fred", "735tuner"); String selectString=""; for(i=0;i"+heightGParam+" AND Tube>"+tubeGParam+" AND Height < "+heightLParam+" AND Tube<"+tubeLParam+" AND Corolla>"+corollaGParam+" AND Corolla<"+corollaLParam+" AND Altitude< "+altitudeLParam+" AND Altitude> "+altitudeGParam+" AND Published "+publishedParam+" ORDER BY '"+orderParam+"';"); */ ResultSet rs = statement.executeQuery("SELECT DISTINCT Genus, Species, Data.Id, Wavelength "+selectString+" FROM Pollinator, Location, Data, Collector, Taxonomy WHERE Pollinator.DataID=Data.Id AND Pollinator.pollinator like '%" + pollinatorParam + "%' AND Data.Id like '" + idParam + "' AND Location.ID=Data.LocationID AND Taxonomy.ID=Data.TaxonomyID AND Collector.ID=Data.CollectorID AND Data.labcode like '"+labcodeParam+"' AND Collector.Collector like '" + collectorParam + "' AND BColour like '" + BColourParam +"' AND HColour like '"+HColourParam+"' AND FlowerPart like'" + SectionParam + "' AND Country like '%" + countryParam +"%' AND Town like '%" + townParam + "%' AND Genus like '%" + genusParam + "%' AND Species like '%"+speciesParam+"%' AND Family like '%"+familyParam+"%' AND Height BETWEEN "+heightGParam+" AND "+heightLParam+" AND Tube BETWEEN "+tubeGParam+" AND "+tubeLParam+" AND Corolla BETWEEN "+corollaGParam+" AND "+corollaLParam+" AND Altitude BETWEEN "+altitudeGParam+" AND "+altitudeLParam+" AND MainColour like '" +maincolourParam+ "' ORDER BY "+orderParam+";"); out.println("

"); while(rs.next()){ int j=2; out.println("

"); while (j-3<=display.length) { String item = rs.getString(j+1); if(j==2) { String species= rs.getString(2); String genus = rs.getString(1); out.println(""); } else if (j==3) { String id = rs.getString(3); out.println(""); } else { out.println(""); } j++; } } statement.close(); connection.close(); } catch (SQLException msg){ out.println("SQL Error : " + msg.getMessage());} %>
ID and Info Reflectance Files
"+item+"HTMLfile"+item+"