<%@ page import="java.sql.*" %>
<%
if ( null == session.getAttribute("username") )
response.sendRedirect("admin.jsp");
String locationName = request.getParameter("locationName");
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;
rs = stmt.executeQuery("SELECT * FROM studies WHERE active = 1 ORDER BY name");
int studyID;
String studyName;
String contact;
String queryString;
%>
StudyManager: Choose study to view session signups
Study sign-in
Choose study:
<%
while (rs.next()) {
studyID = rs.getInt("id");
studyName = rs.getString("name");
contact = rs.getString("contactName");
queryString = "processViewSessionsReport.jsp?studyID=" + studyID + "&studyName=" + studyName;
%>
-
<%= studyName %> (<%= contact %>)
<%
}
%>