<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" errorPage=""%>
<%
double t1=new java.util.Date().getTime();
request.setCharacterEncoding("gb2312");
String dbstr=getServletContext().getRealPath("db1.jsp");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbstr);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("select * from userinfo");
rs.absolute(3);
out.println("<table border=1 style='border-collapse: collapse'>");
while(rs.next())
{
out.println("<tr><td width=20><font size=2>");
out.println(rs.getInt(1));
out.println("</font></td><td width=100><font size=2>");
out.println(rs.getString(2));
out.println("</font></td><td width=100><font size=2>");
out.println(rs.getString(3));
out.println("</font></td></tr>");
}
out.println("</table>");
double t2=new java.util.Date().getTime();
out.print("<br>消耗时间"+(t2-t1)+"毫秒!");
%>