苦恼的absolute
package online_consultation.manager;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import online_consultationdb.db.ViewQueryBean;
import online_consultationdb.db.DbConnection;
import java.sql.Date;
public class pagination {
ViewQueryBean bb;
String sql = ("select * from studty ");
ResultSet rset = null;
public pagination() {
bb = new ViewQueryBean();
}
public String getfiled() {
if (bb.openConnection()) {
try {
rset = bb.executeQuery1(sql);
}
catch (SQLException ex) {
}
}
String name = "";
// try {
//while (rset.next()) {
try {
// rset.next(); //如果用rset.next不会出现错误。
rset.absolute(2);
}
catch (SQLException e) {
}
for (int i = 1; i <= 3; i++) {
try {
name += "<tr>";
name += "<td>" + rset.getString("name").trim() + "</td>";
name += "</tr>";
}
catch (SQLException ex) {
}
try {
if (!rset.next()) {
break;
}
}
catch (SQLException ex1) {
}
}
return name;
}
public static void main(String[] args) {
pagination cc = new pagination();
System.out.println(cc.getfiled());
}
}
这是我程序,我本来想做个分页页面,本人也找了相关代码,现在的问题就是rset.absolute(2),我的数据库有8行纪录,就是跳不到指定的位子!直接跳出。如果用rset.next()方法没有问题。我找了很多资料多没详细讲absolute方法的约束条件,有没有什么约束?请大家帮忙,谢谢!