JSP的mysql_jdbc驱动程序

JSP的mysql_jdbc驱动程序(2)
jsp代码：代码中使用了absolute,ResultSet.TYPE_SCROOL_SENSITIVE等的目录是为了测试mm.mysql是否符合jdbc 2.0的规范 
<%@ page import="Java.sql.*" %> 
<% 
out.println("通讯录！"); 

try { 
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 

} 
catch (Exception E) { 
out.println("Unable to load driver."); 

} 

try { 
Connection C = DriverManager.getConnection("jdbc:mysql://localhost/addressbook?user=root&passWord=jjx&useUnicode=true&characterEncoding=8859_1"); 
Statement s=C.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
ResultSet rs=s.executeQuery("select * from addressbook"); 
out.println("<table border=1>"); 
int i=1; 
for (i=10;i<20;i++) 
{ 
if (rs.absolute(i)) 
{ 
out.println("<tr><td>"); 
out.println(rs.getString(1)); 
out.println("</td>"); 
out.println("<td>"); 
out.print(rs.getString(2)); 
out.println("</td>"); 
out.println("<td>"); 
out.print(rs.getString(3)); 
out.println("</td></tr>"); 
} 
else 
{ 
break; 
} 

} 
out.println("</table>"); 
rs.close(); 
s.close(); 
C.close(); 


} 
catch (SQLException E) { 
out.println("SQLException: " + E.getMessage()); 
out.println("SQLState: " + E.getSQLState()); 
out.println("VendorError: " + E.getErrorCode());