<%@ page language="java" import="java.sql.*" %>

Week 11 Assignment CET 756 - Cliff De Long

<%! java.sql.Connection conn; java.sql.Statement stmt; java.sql.ResultSet results; java.sql.ResultSetMetaData metaData; int numCols; %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn = java.sql.DriverManager.getConnection("jdbc:odbc:USstates"); stmt = conn.createStatement(); results = stmt.executeQuery("select * from states"); metaData = results.getMetaData(); numCols = metaData.getColumnCount(); //out.println("Connection is: " + conn.toString() + "
"); //out.println("Statement is: " + stmt.toString() + "
"); out.println("
"); while(results.next()) { out.println(""); for(int i = 1; i <= numCols; i++) { out.println(""); } out.println(""); } out.println("

" + results.getString(i) + "

"); %>