<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%
int studyID = Integer.parseInt(request.getParameter("studyID"));
String studyName = request.getParameter("studyName");
java.sql.Date date;
java.sql.Time time;
String padding = "", dateString = "", timeString = "";
SimpleDateFormat dateFormat = new SimpleDateFormat("EEEE, MMMM dd, yyyy");
SimpleDateFormat timeFormat = new SimpleDateFormat("h:mm a");
int id = 0;
int locationID = 0;
int maxParticipants = 0;
int year = 0, month = 0, day = 0, hour = 0, minute = 0;
String queryString = "";
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(), checkLimitStmt = con.createStatement();
ResultSet rs = null, checkLimitRS = null;
%>
StudyManager: Choose session
Study signup: <%= studyName %>
Choose a session to participate in:
<%
rs = stmt.executeQuery("SELECT * FROM sessions WHERE studyID = " + studyID + " ORDER BY day, hour");
while (rs.next()) {
id = rs.getInt("id");
maxParticipants = rs.getInt("maxParticipants");
year = rs.getInt("year");
month = rs.getInt("month");
day = rs.getInt("day");
hour = rs.getInt("hour");
minute = rs.getInt("minute");
if (minute == 0)
padding = "0";
else
padding = "";
if (hour < 12)
timeString = hour + ":" + minute + padding + "AM";
else if (hour == 12)
timeString = "12:" + minute + padding + "pm";
else
timeString = (hour - 12) + ":" + minute + padding + "pm";
dateString = month + "/" + (day < 10 ? "0" : "") + day + "/" + year;
queryString = "enterInfo.jsp?" +
"studyName=" + studyName +
"&studyID=" + studyID +
"&sessionID=" + id +
"&sessionDate=" + dateString +
"&sessionTime=" + timeString;
// check if session is already full...
checkLimitRS = checkLimitStmt.executeQuery("SELECT COUNT(*) FROM sessions_participants_link WHERE sessionID = " + id);
if (checkLimitRS.next())
if (checkLimitRS.getInt(1) < maxParticipants) {
%>
- <%= dateString %> (<%= timeString %>)
<%
}
}
%>
<% con.close(); %>