How to read an Access database with a JSP

access|js| Data | database

<% @page import= "java.sql.*"
import = "Java.util.*"
import = "Java.io.*"
Import= "Java.text.*"
Contenttype= "text/html; charset=gb2312 "
Buffer= "20KB"
%><%! int all,i,m_count;
String Odbcquery;
Connection Odbcconn;
Statement odbcstmt;
ResultSet Odbcrs;
String username,title,content,work,email,url,time,date;
String datetime;
%>
<%
try{
Class.forName ("Sun.jdbc.odbc.JdbcOdbcDriver");
}catch (ClassNotFoundException e)
{Out.print ("driver does not exist");
}

try{
Odbcconn = Drivermanager.getconnection ("jdbc:odbc:db1");
odbcstmt = Odbcconn.createstatement ();

odbcquery= "SELECT * from book where datetime>2001-4-26 Order by datetime DESC";
Odbcrs=odbcstmt.executequery (Odbcquery);
int i=0;
while (i<130) Odbcrs.next ();
while (Odbcrs.next ())
{
*/////////////////////////Display the contents of the database for debugging programs is used//
int II;
try{
try{
for (Ii=1;; ii++)
Out.print ("
Cloumn "+ii+" is: "+odbcrs.getstring (ii));
}catch (NullPointerException e) {
Out.print ("with empty pointers");
}
}catch (SQLException e) {
}
}
Odbcrs.close ();
Odbcstmt.close ();
Odbcconn.close ();
}catch (SQLException e)
{Out.print (e);
}
%>