分页部分程序代码:
<%
int countRecord, countPageRecord = 10, currentRecord, p = 0;
String pages = request.getParameter("dipage");
//设定Bean的属性
rs.last();
countRecord = rs.getRow(); //得到记录的条数
datapagebean.setAll(countRecord, countPageRecord);
if (pages != null) {
try {
datapagebean.setCurrentPage(Integer.parseInt(pages));
}
catch (Exception e) {
out.println("参数不正确!");
}
}
//当前记录号
currentRecord = (datapagebean.getCurrentPage() - 1)*datapagebean.getSizePage();
if (currentRecord == 0)
rs.beforeFirst();
else {
rs.absolute(currentRecord);
}public ResultSet executeQuery1(String sql) { //查询记录
try {
conn = DriverManager.getConnection(sConnStr,user,password);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println("DBConnBean.executeQuery:" + ex.getMessage());
}
return rs;
}
从三个表中取出数据,得到数据集,分页代码如上,
错误提示:
严重: Servlet.service() for servlet debugjsp threw exception
java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY
<%
int countRecord, countPageRecord = 10, currentRecord, p = 0;
String pages = request.getParameter("dipage");
//设定Bean的属性
rs.last();
countRecord = rs.getRow(); //得到记录的条数
datapagebean.setAll(countRecord, countPageRecord);
if (pages != null) {
try {
datapagebean.setCurrentPage(Integer.parseInt(pages));
}
catch (Exception e) {
out.println("参数不正确!");
}
}
//当前记录号
currentRecord = (datapagebean.getCurrentPage() - 1)*datapagebean.getSizePage();
if (currentRecord == 0)
rs.beforeFirst();
else {
rs.absolute(currentRecord);
}public ResultSet executeQuery1(String sql) { //查询记录
try {
conn = DriverManager.getConnection(sConnStr,user,password);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch (SQLException ex) {
System.err.println("DBConnBean.executeQuery:" + ex.getMessage());
}
return rs;
}
从三个表中取出数据,得到数据集,分页代码如上,
错误提示:
严重: Servlet.service() for servlet debugjsp threw exception
java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货