<%@ page import="java.sql.*" %> <% // String url = "jdbc:odbc:productDSN"; 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 conn = null; String classPath = "sun.jdbc.odbc.JdbcOdbcDriver"; try { Class.forName( classPath ); conn = DriverManager.getConnection( database, username, password ); } catch (Exception e) { out.println(e.toString()); } Statement stm = null; ResultSet rst = null; String query = "SELECT product.*, manufacturer.name as mname, manufacturer.phone " + "FROM product, manufacturer " + "WHERE product.manufacturerID = manufacturer.manufacturerID"; stm = conn.createStatement(); rst = stm.executeQuery( query ); %> <% while (rst.next()) { %> <% } %>

ID	Name	Model	Price	Manufacturer Name	Manufacturer Phone
<%= rst.getString("id") %>	<%= rst.getString("name") %>	<%= rst.getString("model") %>	$<%= rst.getFloat("price") %>	<%= rst.getString("mname") %>	<%= rst.getString("phone") %>

<% rst.close(); stm.close(); conn.close(); %>