<%@ page language="java" import="java.sql.*" %>
<%!
// declare variables (class instances from the java.sql package)
java.sql.Connection conn;
java.sql.Statement stmt;
java.sql.ResultSet results;
%>
<%
// comments omitted to save space
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = java.sql.DriverManager.getConnection("jdbc:odbc:USstates");
stmt = conn.createStatement();
String query = "select name, population from states where population > 10000000 or " +
" population < 1000000 order by population asc";
results = stmt.executeQuery(query);
out.println("