oracle,怎么改了,还是不行呀!提示: java.lang.NullPointerException oracle.jdbc.driver.ScrollableResultSet.cacheRowAt(ScrollableResultSet.java:1094) oracle.jdbc.driver.ScrollableResultSet.isValidRow(ScrollableResultSet.java:1079) oracle.jdbc.driver.ScrollableResultSet.isEmptyResultSet(ScrollableResultSet.java:1059) oracle.jdbc.driver.ScrollableResultSet.beforeFirst(ScrollableResultSet.java:284) org.apache.commons.dbcp.DelegatingResultSet.beforeFirst(DelegatingResultSet.java:249) tt.tt.queryAffi(tt.java:29) org.apache.jsp.aa_jsp._jspService(aa_jsp.java:53) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:810) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298) 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:810) note The full stack trace of the root cause is available in the Apache Tomcat/5.0 呜。
ResultSet.TYPE_FORWORD_ONLY 只支持向前滚动
ResultSet.TYPE_SCROLL_INSENSITIVE 支持前后滚动
ResultSet.TYPE_SCROLL_SENSITIVE 敏感更新,,支持前后滚动第二个参数:指定结果集是否为只读,可选:
ResultSet.CONCUR_READ_ONLY 只读
ResultSet.CONCUR_UPDATABLE 可修改
System.out.println( rs.next());
System.out.println("www");第一个WWW能打印出来,第二个就打印不出来啦,好像RS的功能全失效了
System.out.println(rs.getType());
打印出来的值都是
1003这代表什么??改怎样改??呀
boolean supports=md.supportsResultSetType(ResultSet.TYPE_FORWORD_ONLY);supports值返回是否支持TYPE_FORWORD_ONLY类型,支持true,不支持false
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery(query);
....
rs.beforeFirst();
????
java.lang.NullPointerException
oracle.jdbc.driver.ScrollableResultSet.cacheRowAt(ScrollableResultSet.java:1094)
oracle.jdbc.driver.ScrollableResultSet.isValidRow(ScrollableResultSet.java:1079)
oracle.jdbc.driver.ScrollableResultSet.isEmptyResultSet(ScrollableResultSet.java:1059)
oracle.jdbc.driver.ScrollableResultSet.beforeFirst(ScrollableResultSet.java:284)
org.apache.commons.dbcp.DelegatingResultSet.beforeFirst(DelegatingResultSet.java:249)
tt.tt.queryAffi(tt.java:29)
org.apache.jsp.aa_jsp._jspService(aa_jsp.java:53)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
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:810)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0
呜。
System.out.println(rs.next());