<%@ page language="java" import="java.sql.*" %> <%! java.sql.Connection conn; java.sql.Statement stmt; %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = java.sql.DriverManager.getConnection("jdbc:odbc:student"); stmt = conn.createStatement(); String cmdText = "CREATE TABLE students (ID integer PRIMARY KEY, firstName varchar(15), lastName varchar(15), email varchar(50), phoneNum varchar(15))"; stmt.executeUpdate(cmdText); out.println("
Table 'student' has been created."); %>