<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%
int studyID = Integer.parseInt(request.getParameter("studyID"));
String contact = "";
int id = 0;
String 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 = null;
rs = stmt.executeQuery("SELECT name FROM studies WHERE id = " + studyID);
rs.next();
studyName = rs.getString(1);
stmt.executeUpdate("UPDATE studies SET active = 0 WHERE id = " + studyID);
%>
StudyManager: Study deleted
<% con.close(); %>
