<%@ page import="java.sql.*" %> <%! // declare variables java.sql.Connection conn; java.sql.Statement stmt; java.sql.ResultSet results; int newID = 0; %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = java.sql.DriverManager.getConnection("jdbc:odbc:student"); stmt = conn.createStatement(); String cmdText = "select MAX(ID) as maxID from students"; results = stmt.executeQuery(cmdText); if (results.next()) { newID = results.getInt("maxID"); newID++; } else { newID++; } cmdText = "INSERT INTO students VALUES(" + newID + ",'Ed','Stover','hammsdrinker@hotmail.com','605-455-6001')"; stmt.executeUpdate(cmdText); out.println("
Student " + newID + " has been added."); %>