<%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@page import="java.sql.*"%> <% String id = request.getParameter("id"); if(id!=null) { session.setAttribute("id", id); } id = (String)session.getAttribute("id"); try { Connection connection = DriverManager.getConnection( "jdbc:mysql://mysql.positive-internet.com/fred", "fred", "735tuner"); Statement statement = connection.createStatement(); ResultSet rs = statement.executeQuery("SELECT Genus, Species FROM Taxonomy, Data WHERE Taxonomy.ID=Data.TaxonomyID AND Data.ID="+id+" ORDER BY Wavelength;"); rs.next(); String genus = rs.getString(1); String species = rs.getString(2); statement.close(); connection.close(); out.println(""+genus+" "+species+" Reflectance Data");%> <%@ include file="sidebar.jsp"%>
<%out.println("

Reflectance Data
"+genus+" "+species+"

"); } catch (SQLException msg){ out.println("SQL Error : " + msg.getMessage());} %>

To save these measurements as a .txt file:

Mozilla Firefox users:     1. Right click   2. Select Save Page As...   3. Select to save as text file
IE 7 users:     1. Go to Page -> Save As   2. Select to save as text file

<% //string detemines whether user is allowed access String access=""; //connect to database access="yes"; %> <% if(access=="yes") { out.println(""); try { Connection connection = DriverManager.getConnection( "jdbc:mysql://mysql.positive-internet.com/fred", "fred", "735tuner"); Statement statement = connection.createStatement(); ResultSet rs = statement.executeQuery("SELECT Data.ID, Wavelength.Wavelength, Reflectance FROM Wavelength, Data WHERE Wavelength.DataId=Data.ID AND Data.ID='"+id+"' ORDER BY Wavelength;"); while(rs.next()){ int Wavelength = rs.getInt(2); String Reflectance = rs.getString(3); out.println(""); out.println(""); } statement.close(); connection.close(); } catch (SQLException msg){ out.println("SQL Error : " + msg.getMessage());} } %>
WavelengthReflectance
" + Wavelength + ""+ Reflectance +"