<%@ page import="java.sql.*" %> <% String cmdString; boolean doUpdate = (request.getParameter("doUpdate") != null); boolean doDelete = (request.getParameter("doDelete") != null); String mCustomerID = request.getParameter("customerID"); DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection connection = DriverManager.getConnection ("jdbc:oracle:thin:@arclight.glos.ac.uk:1521:cgdb01", "ocle019", "ocle019"); Statement statement = connection.createStatement (); // cmdString = "drop table customers"; // statement.execute(cmdString); // cmdString = "create table customers (customerID varchar2(10))"; // statement.execute(cmdString); if (mCustomerID != null) { if (mCustomerID.length() != 0) { if(doUpdate) { cmdString = "insert into customers values ( '" + mCustomerID + "' )"; statement.execute(cmdString); statement.execute("commit"); } if(doDelete) { cmdString="delete from customers where customerID = '" + mCustomerID + "'"; statement.execute(cmdString); statement.execute("commit"); } } } cmdString = "select * from customers"; ResultSet rs = statement.executeQuery(cmdString); %>

Customer ID:

<% while (rs.next()) { String customerID = rs.getString("customerID"); out.write("\r\n"); } statement.close(); connection.close(); %> " + customerID + "