<%@ page import="java.sql.*" %> <%@ page import="java.util.ArrayList"%> <% int studyID = Integer.parseInt(request.getParameter("studyID")); String studyName = request.getParameter("studyName"); int i = 0; int PID = 0; String firstName = "test"; String lastName = "test"; String email = "test@test.com"; 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 parStmt = con.createStatement(); ResultSet rs, participantRS; rs = stmt.executeQuery("SELECT PID FROM SESSIONS_PARTICIPANTS_LINK WHERE sessionID IN (SELECT id FROM SESSIONS WHERE studyID = " + studyID + ")"); %> StudyManager: View study sign-ups

View study signups:
<%= studyName %>

<% while (rs.next()) { PID = rs.getInt("PID"); System.err.println(i + ": " + PID); participantRS = parStmt.executeQuery("SELECT * FROM participants WHERE PID = " + PID); if (participantRS.next()) { firstName = participantRS.getString("firstName"); lastName = participantRS.getString("lastName"); email = participantRS.getString("email"); } else { firstName = "Unknown PID"; lastName = ""; email = ""; } i++; %> <% } %>
Students who have signed up for this study
# PID First name Last name Email
<%= i %> <%= PID %> <%= firstName %> <%= lastName %> <%= email %>
<% con.close(); %>