使用javabean实现分页

 

1分页的javabean

package com.shortmessage.common;


import java.util.Date;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import javax.servlet.jsp.jstl.sql.Result;

import com.shortmessage.common.db.SQLHelper;

public class SpilitPager {

	/*
	 * 操作分页的javabean组件
	 * 1.pageSize   用于确定每页的大小
	 * 2.currentPage  用于确定当前页
	 * 3.Object[][] pageList   要分页的记录
	 * 
	 * */
	
	private  int pageSize = 2;          //每页的记录数
	private  int currentPage = 1;       //当前页
	private  Object[][] pageList;       //二维数组
	
	//设置要分页的集合
	public void setPageList(Object[][] pageList){
	   this.pageList = 	pageList;
	}
	
	public Object[][] getPageList(){
	   return pageList;
	}
	public Object[][] getAll(int userId){
		
		Object[][] pageList = null;
		
		String sql = "select * from tb_message where receiveUser = ?";
		Integer[] params = {userId};
		Result result = SQLHelper.runExecuteQuery(sql,params);
		
		if(result.getRowCount()>0){
			Map[] rows = result.getRows();
			pageList = new Object[rows.length][7];
			for(int i=0;i<rows.length;i++){

				pageList[i][0] = Integer.parseInt(rows[i].get("Id").toString());
				pageList[i][1] = (rows[i].get("title").toString());
				pageList[i][2]