<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%
int course = Integer.parseInt(request.getParameter("course"));
int section = Integer.parseInt(request.getParameter("section"));
int numStudents = Integer.parseInt(request.getParameter("numStudents"));
int credits = Integer.parseInt(request.getParameter("credits"));
String department = request.getParameter("department");
String title = request.getParameter("title");
String instructor = request.getParameter("instructor");
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;
stmt.executeUpdate(
"INSERT INTO courses (id, department, title, instructor, coursenum, section, creditsRequired, active) VALUES (courses_id_seq.nextval,'"
+ department + "', '"
+ title + "', '"
+ instructor + "', "
+ course + ", "
+ section + ","
+ credits + ","
+ "1" +
")"
);
System.out.println("past INSERT");
rs = stmt.executeQuery("SELECT MAX(id) FROM courses");
rs.next();
int courseID = rs.getInt(1);
%>
StudyManager: Input students
Input students
Course: <%= department %> <%= course %> (Section: <%= section %>)
<% con.close(); %>