<%@ page import="java.sql.*" %>
<%
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();
stmt.executeUpdate("INSERT INTO locations (id, name) VALUES (location_id_seq.nextval,'" + locationName + "')");
%>
StudyManager: Location added
<% con.close(); %>
