<%@ page import="java.util.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.text.*" %> <% int studyID = Integer.parseInt(request.getParameter("studyID")); int numSessions = Integer.parseInt(request.getParameter("numSessions")); 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 = null; rs = stmt.executeQuery("SELECT * FROM locations"); ArrayList locationNamesList = new ArrayList(); ArrayList locationIDsList = new ArrayList(); while (rs.next()) { locationIDsList.add(new Integer(rs.getInt("ID"))); locationNamesList.add(new String(rs.getString("name"))); } %> StudyManager: Add sessions to study

Add sessions to study

<% for (int i = 0; i < numSessions; i++) { %> <% } %>

#	Location	Max participants	Year	Month	Day	Hour	Minute
0	Example	10	2005	Nov	27	6 pm	30
<%= i + 1 %>

<% con.close(); %>