<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%
int courseID = Integer.parseInt(request.getParameter("courseID"));
int course = Integer.parseInt(request.getParameter("course"));
int section = Integer.parseInt(request.getParameter("section"));
int numStudents = Integer.parseInt(request.getParameter("numStudents"));
String department = request.getParameter("department");
String title = request.getParameter("title");
String instructor = request.getParameter("instructor");
int PID = 0;
String firstName = "", lastName = "", email = "";
int id = 0;
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;
for (int i = 0; i < numStudents; i++) {
PID = Integer.parseInt(request.getParameter("PID" + i));
firstName = request.getParameter("firstName" + i);
lastName = request.getParameter("lastName" + i);
email = request.getParameter("email" + i);
// is student in DB already?
rs = stmt.executeQuery("SELECT PID FROM participants WHERE PID =" + PID);
if (rs.next()) // found student...
stmt.executeUpdate("INSERT INTO courses_participants_link (id, PID, courseID) VALUES (cplink_id_seq.nextval," + PID + "," + courseID + ")");
else { // new student, so add info to DB...
stmt.executeUpdate("INSERT INTO participants (PID, firstName, lastName, email) VALUES ("
+ PID + "," + "'" + firstName + "','" + lastName + "','" + email + "')"
);
stmt.executeUpdate("INSERT INTO courses_participants_link (id, PID, courseID) VALUES (cplink_id_seq.nextval," + PID + "," + courseID + ")");
}
}
%>
StudyManager: students added
<% con.close(); %>
