ResultSet的问题,请各位大侠指教,小生感激涕零
我初学JSP,下面这个问题快使我疯掉了,请各位高手指点。
先说环境:
Tomcat 5.0.30 + Lomboz 3.0.1 + Eclipse 3.0.1 + j2sdk 1.4.2.07
采用JDBC + ODBC连接Access 2003数据库,下面语句中的rs由Statement执行一个查询语句返回(这部分没有问题)。
出差语句是:
while (i < pageSize && rs.next()) {
out.println("<tr>\n<td height=\"20\" valign=\"middle\" bgcolor=\"#FFFFFF\" class=\"style5\">");
out.println(rs.getString("title") + "</td>\n<td height=\"20\" align=\"center\" valign=\"middle\" bgcolor=\"#FFFFFF\" class=\"style5\">");
out.println(rs.getString("doc_id") + "</td>\n<td height=\"20\" align=\"center\" valign=\"middle\" bgcolor=\"#FFFFFF\" class=\"style5\">");
out.println(dateFormat.format(rs.getDate("issue_date")) + "</td>\n</tr>");
}
如果我将while改成if,只输出一个记录没有问题。
系统提示的信息:
javax.servlet.ServletException: [Microsoft][ODBC 驱动程序管理器] 无效的游标状态
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.publicArea_jsp._jspService(publicArea_jsp.java:162)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 无效的游标状态
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
org.apache.jsp.publicArea_jsp._jspService(publicArea_jsp.java:129)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)