<%@ page import="java.sql.*" %> <% int PID = Integer.parseInt(request.getParameter("PID")); Class.forName ("oracle.jdbc.driver.OracleDriver"); Connection con = DriverManager.getConnection("jdbc:oracle:thin:@dbprod03.isis.unc.edu:1521:ord1p", "acrystal", "&GJ8$mRQ"); Statement stmt = con.createStatement(); Statement locationStmt = con.createStatement(); ResultSet rs = stmt.executeQuery("SELECT * FROM sessions WHERE id IN (SELECT sessionID FROM sessions_participants_link WHERE PID = " + PID + ") ORDER BY id"); ResultSet locationRS; /* locationStmt.executeQuery("SELECT * FROM locations WHERE id IN ( SELECT locationID FROM sessions WHERE id IN ( SELECT sessionID FROM sessions_participants_link WHERE PID = " + PID + ")) ORDER BY id"); */ String sessionDesc = ""; int sessionID; int year = 0, month = 0, day = 0, hour = 0, minute = 0; String sessionDate = ""; String sessionTime = ""; String padding = ""; String location = ""; %> StudyManager: Which session am I in?

Your sessions:

<% while (rs.next()) { sessionID = rs.getInt("id"); year = rs.getInt("year"); month = rs.getInt("month"); day = rs.getInt("day"); hour = rs.getInt("hour"); minute = rs.getInt("minute"); if (minute == 0) padding = "0"; else padding = ""; if (hour < 12) sessionTime = hour + ":" + minute + padding + "AM"; else if (hour == 12) sessionTime = "12:" + minute + padding + "pm"; else sessionTime = (hour - 12) + ":" + minute + padding + "pm"; sessionDate = month + "/" + (day < 10 ? "0" : "") + day + "/" + year; sessionDesc = sessionDate + " (" + sessionTime + ")"; locationRS = locationStmt.executeQuery("SELECT name FROM locations WHERE id = " + rs.getInt("locationID")); locationRS.next(); location = locationRS.getString("name"); %>

<%= sessionDesc %>
<%= location %>

<% } %> ›› Sign up for a new session, or change to a different session