<%@ 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();
ResultSet rs = stmt.executeQuery("SELECT * FROM sessions WHERE studyID=" + studyID + " ORDER BY month, day, hour");
int sessionID;
int year = 0, month = 0, day = 0, hour = 0, minute = 0;
String sessionDate = "";
String sessionTime = "";
String padding = "";
%>
StudyManager: Sign-in participant
Study sign-in
<%= studyName %>