<%@ page import="java.util.*" %> <%@ page import="java.sql.*" %>

<% // // Get Tracking-Number from HTTP-POST Data: // String trackingNo = request.getParameter("trackingNumber"); // // Make JDBC Connection. Perform Query // Class.forName("org.gjt.mm.mysql.Driver").newInstance(); java.sql.Connection conn; String connurl = "jdbc:mysql://localhost.localdomain/shipping_events"; String user = "DBUSRNAME"; String pw = "DBPASSWORD"; conn = DriverManager.getConnection(connurl,user,pw); Statement stmt = conn.createStatement(); ResultSet res; res = stmt.executeQuery("SELECT * FROM event_log " + "where package_id='" + trackingNo + "'"); res.last(); int nrows = res.getRow(); %> <% if(nrows > 0){ %> The following events were reported for package number <%=res.getString("package_id") %> <% for(res.first();!res.isAfterLast();res.next()){ %> <%=res.getString("descr") %> on <%=res.getString("time_stamp") %> <% } }else{ %> I couldn't find any information for that package. <% } %> Would you like to track another package? Thank you for using the telephone package tracker. Goodbye.