<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%
//String query = request.getParameter("query");
//String queryString = "'%" + query + "%'";
//String bandName, imageName, personName, songName, albumName, audioName;
//String imageDesc;
//int id = 0, personID = 0;
String queryString = "";
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;
%>
StudyManager
Choose a study to participate in:
<%
//rs = stmt.executeQuery("SELECT * from studies WHERE active = TRUE");
rs = stmt.executeQuery("SELECT * from studies WHERE active = 1");
while (rs.next()) {
id = rs.getInt("id");
studyName = rs.getString("name");
queryString = "chooseSession.jsp?" + "studyName=" + studyName + "&studyID=" + id;
%>
- <%= studyName %>
<%
}
%>
<% con.close(); %>