Java编程琐事（7）——封装JDBC分页

最新推荐文章于 2022-01-11 18:26:45 发布

Creating

最新推荐文章于 2022-01-11 18:26:45 发布

阅读量1.9k

点赞数

分类专栏： Java语言文章标签： jdbc 编程 java string cms null

本文链接：https://blog.csdn.net/Solidwang/article/details/5416339

版权

Java语言专栏收录该内容

14 篇文章 0 订阅

订阅专栏

一、编写一个接口从ResultSet继承：

package com.solid.test;

import java.sql.ResultSet;

import java.sql.SQLException;

public interface Pageable extends ResultSet {

//返回总页数

int getPageCount();

//返回当前页的记录条数

int getPageRowsCount();

//返回分页大小

int getPageSize();

//转到指定页

void gotoPage(int page);

//设置分页大小

void setPageSize(int pageSize);

//返回总记录行数

int getRowsCount();

//转到当前页的第一条记录

void pageFirst() throws SQLException;

//转到当前页的最后一条记录

void pageLast() throws SQLException;

//返回当前页号

int getCurrentPageNo();

}

二、编写实现接口的方法：

public class PageableResultSet implements Pageable {

protected ResultSet rs=null;

//每页行数

protected int rowsCount;

//分页大小

protected int pageSize;

//当前页号

protected int currentPageNo;

protected String command = "";

//构造方法

public PageableResultSet(ResultSet rs) throws java.sql.SQLException {

if(rs==null) throw new SQLException("given ResultSet is NULL","user");

rs.last();

rowsCount=rs.getRow();

rs.beforeFirst();

this.rs=rs;

}

//返回当前页号

public int getCurrentPageNo() {

return currentPageNo;

}

//返回总页数

public int getPageCount() {

// TODO Auto-generated method stub

if(rowsCount == 0) return 0;

if(pageSize == 0) return 1;

double tmpD = (double)rowsCount/pageSize;

int tmpI = (int)tmpD;

if(tmpD > tmpI) tmpI++;

return tmpI;

}

//返回当前页的记录条数

public int getPageRowsCount() {

if(pageSize == 0) return rowsCount;

if(getRowsCount() == 0) return 0;

if(currentPageNo != getPageCount()) return pageSize;

return rowsCount-(getPageCount()-1)*pageSize;

}

//返回分页大小

public int getPageSize() {

return pageSize;

}

//返回每页行数

public int getRowsCount() {

return rowsCount;

}

//跳转到第几页

public void gotoPage(int page) {

if(rs == null) return;

if(page < 1) page = 1;

if(page > getPageCount()) page = getPageCount();

int row = (page - 1) * pageSize + 1;

try {

rs.absolute(row);

currentPageNo = page;

} catch (SQLException e) {

e.printStackTrace();

}

//跳转到首页

public void pageFirst() throws SQLException {

int row=(currentPageNo - 1) * pageSize + 1;

rs.absolute(row);

}

//跳转到最后一页

public void pageLast() throws SQLException {

int row=(currentPageNo - 1) * pageSize + getPageRowsCount();

rs.absolute(row);

}

//设置分页大小

public void setPageSize(int pageSize) {

if(pageSize >= 0){

this.pageSize = pageSize;

currentPageNo = 1;

}

三、JSP页面中分页操作：

<tr>

</tr>

Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

ResultSet.CONCUR_READ_ONLY);

Pageable rs=null;

String loginuserid = usersdao.getUser_id();

String sql = "select a.paper_id,a1.name as classname,a.class_id,a.paper_name,a.public_flag,a.flow_defineid,"

+ "a.inputman," + com.approval.lib.CmUtil.getFormatDateTime("a.inputtime","yyyy-mm-dd hh24:mm:ss") + " as inputtime,b.flow_id,b.create_userid,b.create_time,b.isfinish, "

+ "c.flow_logid,c.sender,c.receiver," + com.approval.lib.CmUtil.getFormatDateTime("c.receivetime","yyyy-mm-dd hh24:mm:ss") + " as receivetime,d.user_name "

+ "from t_cms_d_paper a "

+ "join t_cms_d_channel a1 on a.class_id=a1.id "

+ "join t_cms_flow b on a.paper_id=b.paper_id "

+ "join t_cms_flowlog c on b.flow_id=c.flow_id "

+" join t_cms_d_user d on c.sender=d.user_id "

+ "where a.del_flag=0 and b.isfinish!=1 and (a.public_flag=9 or a.public_flag=-1) and c.isfinish=0 and c.receiver='"

+ loginuserid + "' order by c.receivetime desc ";

rs=new PageableResultSet(stm.executeQuery(sql));

rs.setPageSize(10);

String checkpage=request.getParameter("page");

if(null!=checkpage && !("".equals(checkpage)))

{

rs.gotoPage(Integer.parseInt(checkpage));

}

else

{

rs.gotoPage(1);

}

for(int i=0;i<rs.getPageRowsCount();i++)

{

<tr>

</tr>

rs.next();

}

rs.close();

stm.close();

con.close();

String strurl=com.approval.lib.LoadProperties.getProperty("context")+"/flow/flowPaper/waitcheck.jsp?page=";

String nextpageurl=strurl+(rs.getCurPage()+1);

String prepageurl=strurl+(rs.getCurPage()-1);

String lastpageurl=strurl+rs.getPageCount();

<tr>

<a href="<%=com.approval.lib.LoadProperties.getProperty("context") %>/flow/flowPaper/waitcheck.jsp?page=1">首页</a>

</td>

</tr>

</table>

</td>

</tr>

</table>

Creating

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
Java编程琐事（7）——封装JDBC分页

一、编写一个接口从ResultSet继承：package com.solid.test;import java.sql.ResultSet;import java.sql.SQLException;public interface Pageable extends ResultSet { //返回总页数 int getPageCount();
复制链接

扫一扫

专栏目录