<%@ page import="java.sql.*" %> <% // Step 2 - Define Connection URL / File // String url = "jdbc:odbc:johnDSN"; String filename = "c:/product.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end String username = ""; String password = ""; Connection connection = null; String classPath = "sun.jdbc.odbc.JdbcOdbcDriver"; try { // Step 1 - Load JDBC Driver Class.forName( classPath ); // Step 3 - Establish connection connection = DriverManager.getConnection( database, username, password ); } catch (Exception e) { out.println(e.toString()); } Statement statement = null; ResultSet resultSet = null; String query = "SELECT * FROM product"; // Step 4 - Create the statement object statement = connection.createStatement(); // Step 5 - Execute the query resultSet = statement.executeQuery( query ); %> <% // Step 6 - Process the results while (resultSet.next()) { %> <% } %>

ID	Name	Model	Price	Manufacturer ID
<%= resultSet.getString("id") %>	<%= resultSet.getString("name") %>	<%= resultSet.getString("model") %>	$<%= resultSet.getFloat("price") %>	<%= resultSet.getInt("manufacturerID") %>

<% // Step 7 - Close the connection resultSet.close(); statement.close(); connection.close(); %>