<%@ page import="java.sql.*" %>
<%
if ( null == session.getAttribute("username") )
response.sendRedirect("admin.jsp");
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 courses WHERE active = 1 ORDER BY coursenum");
int id;
String department;
int number;
int section;
String title;
String instructor;
String queryString;
%>
StudyManager: Choose study to report on
Course research study attendance report
Choose course:
<%
while (rs.next()) {
id = rs.getInt("id");
department = rs.getString("department");
title = rs.getString("title");
instructor = rs.getString("instructor");
number = rs.getInt("coursenum");
section = rs.getInt("section");
queryString = "viewAttendance.jsp?courseID=" + id;
%>
