怎么使用Resultset的isLast()方法？

Question

我使用后直接报错,我的jdk是1.4.2。
root cause java.sql.SQLException: ????????????: isLast
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
oracle.jdbc.driver.OracleResultSetImpl.isLast(OracleResultSetImpl.java:390)
com.cqgdcc.JsTree.buildTree(JsTree.java:25)
com.cqgdcc.JsTree.init(JsTree.java:16)
org.apache.jsp.JspTree_jsp._jspService(JspTree_jsp.java:74)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

Answer 1

我的代码：
ResultSet rs = conn.executeQuery("select * from tree where parentid="
+ parentid + " order by id");
while (rs.next()) {
out.println("<div>");
if (hasChild(rs.getInt("id"))) {
for (int i = 0; i < level - 1; i++)
out.println("<img src=\"images/T.png\"> ");
if(rs.isLast())
System.out.println("this is  the last place ");

Answer 2

while (rs.next()) {
  out.println("<div>");
  if (hasChild(rs.getInt("id"))) {
     for (int i = 0; i < level - 1; i++)
  out.println("<img src=\"images/T.png\"> ");
  }
}
 System.out.println("this is  the last place ");

Answer 3

楼主的错误是忽略了Statement或者PreparedStatement不是可移动的；如果要使用isLast等移动，需要在conn.createStatement(Statement.senti..,Statement.)增加参数

Answer 4

应该是Statement stmt = con.createStatement(
                                      ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);

Answer 5

需要回滚参数ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE