<%@ page import="java.sql.*" %>
<%
int studyID = Integer.parseInt(request.getParameter("studyID"));
String dateString = "", timeString = "", padding = "";
int year = 0, month = 0, day = 0, hour = 0, minute = 0;
int sessionID = 0;
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.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = null;
rs = stmt.executeQuery("SELECT * FROM sessions WHERE studyID = " + studyID);
%>
StudyManager: Delete sessions from a study
Delete sessions
<%
if (!rs.next()) {
out.println("
No sessions available for this study
\n" +
"Return to the main menu\n" +
"
");
}
else {
rs.beforeFirst();
%>
Check the box next to a session to mark it for deletion