<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import="java.sql.*"%> <%-- The taglib directive below imports the JSTL library. If you uncomment it, you must also add the JSTL library to the project. The Add Library... action on Libraries node in Projects view can be used to add the JSTL 1.1 library. --%> <%-- <%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> --%> FReD Results <%//Include sidebar%> <%@ include file="sidebar.jsp"%>

Search Results

<%//connect to Driver try {Class.forName("com.mysql.jdbc.Driver").newInstance();} catch (ClassNotFoundException exp) {out.println("Exception" + exp.getMessage());}%> <%//Retrieve keyword Parameter String keywordParam = request.getParameter("keyword"); //Set the keyword Parameter as a session variable and retrieve session variable if(keywordParam!=null) {session.setAttribute("keyword", keywordParam);} String keyword = (String)session.getAttribute("keyword"); //Set the order Parameter as a session variable and retrieve session variable String order = request.getParameter("order"); if (order==null) {order="Id";} session.setAttribute("order", order); %> <%//Connect to database try { Connection connection = DriverManager.getConnection("jdbc:mysql://mysql.positive-internet.com/fred", "fred", "735tuner"); Statement statement = connection.createStatement(); //Retrieve data as resultset ResultSet rs = statement.executeQuery("SELECT DISTINCT Data.Id, Taxonomy.Genus, Taxonomy.Species, Location.Country, Location.Town, Data.FlowerPart, Data.BColour, Data.HColour, Collector.Collector, Pollinator.Pollinator, Data.Wavelength, Data.MainColour FROM Pollinator, Location, Data, Collector, Taxonomy WHERE Pollinator.DataId=Data.ID AND Taxonomy.ID=Data.TaxonomyID AND Collector.ID=Data.CollectorID AND Location.ID=Data.LocationID AND (Data.Id like '%" + keyword + "%' OR Data.labcode like '%"+ keyword +"%' OR Collector.Collector like '%" + keyword + "%' OR Pollinator like '%"+ keyword +"%' OR BColour like '%" + keyword +"%' OR HColour like '%" + keyword +"%' OR Country like '%" + keyword +"%' OR E_deg like '%" + keyword + "%' OR S_deg like '%" + keyword + "%' OR Species like '%" + keyword + "%' OR Genus like '%" + keyword + "%' OR Family like '%" + keyword + "%' OR Town like '%" + keyword + "%' OR FlowerPart like '%"+ keyword+"%' OR Published like '%" +keyword+"%' ) ORDER BY "+order+";"); // out.println("SELECT DISTINCT Data.Id, Taxonomy.Genus, Taxonomy.Species, Location.Country, Location.Town, Data.FlowerPart, Data.BColour, Data.HColour, Collector.Collector, Pollinator.Pollinator, Data.Wavelength, Data.MainColour FROM Pollinator, Location, Data, Collector, Taxonomy WHERE Pollinator.DataId=Data.ID AND Taxonomy.ID=Data.TaxonomyID AND Collector.ID=Data.CollectorID AND Location.ID=Data.LocationID AND (Data.Id like '%" + keyword + "%' OR Data.labcode like '%"+ keyword +"%' OR Collector.Collector like '%" + keyword + "%' OR Pollinator like '%"+ keyword +"%' OR BColour like '%" + keyword +"%' OR HColour like '%" + keyword +"%' OR Country like '%" + keyword +"%' OR E_deg like '%" + keyword + "%' OR S_deg like '%" + keyword + "%' OR Species like '%" + keyword + "%' OR Genus like '%" + keyword + "%' OR Family like '%" + keyword + "%' OR Town like '%" + keyword + "%' OR FlowerPart like '%"+ keyword+"%' OR Published like '%" +keyword+"%' ) ORDER BY "+order+";"); //convert data to String while(rs.next()){ String thisid = rs.getString(1); String genus = rs.getString(2); String species = rs.getString(3); String country = rs.getString(4); String town = rs.getString(5); String flowerpart = rs.getString(6); String bColour = rs.getString(7); String hColour = rs.getString(8); String collector = rs.getString(9); String pollinator = rs.getString(10); String wavelength = rs.getString(11); String mainColour = rs.getString(12); //Print data out.print(""); out.print(""); out.println(""); out.print(""); } statement.close(); connection.close(); } catch (SQLException msg){ out.println("SQL Error : " + msg.getMessage());} %>
ID and InfoReflectance Files <%out.println("");%> Genus <%out.println("");%> Species <%out.println("");%> Country <%out.println("");%> Nearest Town <%out.println("");%> Flower Section <%out.println("");%> Bee Colour <%out.println("");%> Human Colour <%out.println("");%> Pollinator <%out.println("");%> Collector <%out.println("");%> Main Colour?
" + thisid + "HTMLfile"+genus+" "+species+" "+country+" "+town+""+flowerpart+""+bColour+""+hColour+""+pollinator+""+collector+""+mainColour+"