<%@ page import="java.sql.*" %> <% int PID = Integer.parseInt(request.getParameter("PID")); int sessionID = Integer.parseInt(request.getParameter("sessionID")); int studyID = Integer.parseInt(request.getParameter("studyID")); String studyName = request.getParameter("studyName"); 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; rs = stmt.executeQuery("SELECT PID FROM participants WHERE PID = " + PID); if (rs.next()) { stmt.executeUpdate("INSERT INTO attendance (id, PID, sessionID) VALUES (attendance_id_seq.nextval," + PID + "," + sessionID + ")"); %> StudyManager: Sign-in participant

Study sign-in

You have signed in.

Sign in another participant

Return to the main sign-in page.

<% } else { %> StudyManager: No participant found

Unknown participant

We have no record of a participant with a PID of <%= PID %>.

Please go back and check the PID.

<% } %> <% con.close(); %>