<%=genus + " "+ species%>

<%try { Connection connection = DriverManager.getConnection( "jdbc:mysql://mysql.positive-internet.com/fred", "fred", "735tuner"); Statement statement = connection.createStatement(); ResultSet rs = statement.executeQuery("SELECT FlowerPart, BColour, HColour, MainColour, Data.ID FROM Data, Taxonomy WHERE Taxonomy.Genus='"+genus+"' AND Taxonomy.Species like '" + species + "%' AND Taxonomy.ID=Data.TaxonomyID ORDER BY FlowerPart;"); while(rs.next()){ String section = rs.getString(1); String BColour = rs.getString(2); String HColour = rs.getString(3); String MainColour = rs.getString(4); String id = rs.getString(5); out.println(""); } else{out.println("Login for files");} */ } statement.close(); connection.close(); } catch (SQLException msg){ out.println("SQL Error : " + msg.getMessage());} %> <%try { Connection connection = DriverManager.getConnection( "jdbc:mysql://mysql.positive-internet.com/fred", "fred", "735tuner"); Statement statement = connection.createStatement(); ResultSet rs = statement.executeQuery("SELECT DISTINCT Country, Town, E_deg , S_deg FROM Data, Taxonomy, Location WHERE Data.LocationID=Location.ID AND Taxonomy.Genus='"+genus+"' AND Taxonomy.Species like '" + species + "%' AND Taxonomy.ID=Data.TaxonomyID ORDER BY FlowerPart;"); while(rs.next()){ String Country = rs.getString(1); String Town = rs.getString(2); String E_deg = rs.getString(3); String S_deg = rs.getString(4); out.println(""); } statement.close(); connection.close(); } catch (SQLException msg){ out.println("SQL Error : " + msg.getMessage());} %> <%try { Connection connection = DriverManager.getConnection( "jdbc:mysql://mysql.positive-internet.com/fred", "fred", "735tuner"); Statement statement = connection.createStatement(); ResultSet rs = statement.executeQuery("SELECT DISTINCT Collector.Collector, Published, accession FROM Data, Collector, Taxonomy WHERE Data.TaxonomyId=Taxonomy.Id AND Taxonomy.Genus='"+genus+"' AND Taxonomy.Species like '" + species + "%' AND CollectorId=Collector.Id;"); Vector heightV = new Vector(); Vector tubeV = new Vector(); Vector corollaV = new Vector(); while(rs.next()){ String published = rs.getString(2); String accession = rs.getString(3); String collector = rs.getString(1); out.println(""); } statement.close(); connection.close(); } catch (SQLException msg){ out.println("SQL Error : " + msg.getMessage());} %>

Plant Colours
ID	Plant Section	Bee Colour	Human Colour	Main Colour
"+id+"	" +section+ "	"+ BColour+ "	" +HColour+ "	" +MainColour+"	"); /* if(session.getAttribute("username")=="authUser") { out.println("Wavelength
Origin of Samples
	Country	Town/Area	GPS East	GPS South
	" +Country+ "	"+ Town+ "	" +E_deg+ "	"+S_deg+"
Collection Information
	Collector	Publication	Accession
	" +collector+ "	"+ published+ "	" +accession+ "