<%@ 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;
String tempID = "";
String deleteQueryString = "";
String[] SessionstoDelete = request.getParameterValues("toDelete");
for (int i = 0; i < SessionstoDelete.length; i++) {
deleteQueryString += SessionstoDelete[i];
deleteQueryString += ",";
}
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;
deleteQueryString = deleteQueryString.substring(0,deleteQueryString.length() - 1); // kill trailing comma
System.out.println(deleteQueryString);
stmt.executeUpdate("DELETE FROM sessions WHERE id IN (" + deleteQueryString + ")");
%>
StudyManager: Delete sessions from a study
<% con.close(); %>
