<%@page contentType="text/html"%>
Andreas JSP-MS ACCESS Page version:0.1
<%
String data = "jdbc:odbc:db1";
String query = "Select * FROM cds";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
java.sql.Connection con = java.sql.DriverManager.getConnection(data);
java.sql.Statement stmt = con.createStatement() ;
java.sql.ResultSet rs = stmt.executeQuery(query) ;
java.sql.ResultSetMetaData rsmd = rs.getMetaData() ;
for(int i = 1 ; i <= rsmd.getColumnCount() ; i++) {
%>
| <%rsmd.getColumnName(i); %> |
<% } %>
<%
while(rs.next()) { %>
| a:<%= rs.getInt(1)%> |
b:<%= rs.getString(2) %> |
c:<%= rs.getString(3) %> |
<% }
con.close();
%>