<%@ page import="java.sql.*" %>
<%
if ( null == session.getAttribute("username") )
response.sendRedirect("admin.jsp");
String studyName = request.getParameter("studyName");
int studyID = Integer.parseInt(request.getParameter("studyID"));
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 sessionStmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM sessions WHERE studyID=" + studyID + " ORDER BY month, day, hour");
ResultSet sessionRS;
int sessionID;
int year = 0, month = 0, day = 0, hour = 0, minute = 0;
int max = 0, current = 0;
String sessionDate = "";
String sessionTime = "";
String padding = "";
%>
StudyManager: Session sign-ups
Study session sign-up report
<%= studyName %>
| ID
| Date
| Time
| Current Participants |
Max Participants |
<%
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");
max = rs.getInt("maxParticipants");
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;
sessionRS = sessionStmt.executeQuery("SELECT COUNT(*) FROM sessions_participants_link WHERE sessionID = " + sessionID);
sessionRS.next();
current = sessionRS.getInt(1);
%>
| <%= sessionID %> |
<%= sessionDate%> |
<%= sessionTime %> |
<%= current %> |
<%= max %> |
<%
}
%>