pagebean.java

用struts框架做的jsp通讯录

package com.csthit.phonebook.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.csthit.phonebook.db.ConnClass;



public class PageBean {
	
	//每页显示多少行：
	private int pageSize=4;
	//总页数
	private int pageNum;
	//当前页数
	private int pageID=1;
	
	//获得数据库中总共有多少条数据：
	private int size;
	private int uid;
	
	// set && get
	public int getPageID() {
		return pageID;
	}
	public int getPageNum() {
		return pageNum;
	}
	public int getSize() {
		return size;
	}
	//分页方法的封装
	private static ConnClass cc= ConnClass.getInstance(); 
	private static Connection conn =cc.getConn(); //获取单例中的Conncetion
	private static PreparedStatement pstmt = null;
	private static ResultSet rs = null;
	
	public List pageSplit(int pageID,int uid) throws Exception {
		this.pageID = pageID;
		this.uid = uid;
		
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		
		String sql="select * from address";
		pstmt=conn.prepareStatement(sql);
		
		rs = pstmt.executeQuery();
		
		//游标移动到最后面
		rs.last();
		
		//获取总记录数
		size = rs.getRow();
		
		if(size%pageSize==0) {
			this.pageNum = size/pageSize;
		} else {
			this.pageNum = size/pageSize+1;
		}
		
		//是游标回到第一行之前
		rs.beforeFirst();
		
		//将游标定位到当前页面的顶上
		for(int i=0;i<(pageID-1)*pageSize;i++) {
			rs.next();
		}
		
		List listall = new ArrayList();
		for (int i = 0; i < pageSize; i++) {
			
			List listrow = new ArrayList();
			if(!rs.next()) {
				break;
			}
			
	
			int id = rs.getInt(1);
			String pname = rs.getString(3);
			String phone =rs.getString(4);
			int age = rs.getInt(5);
			String email = rs.getString(6);
			String address = rs.getString(7);
			listrow.add(new Integer(id));
			listrow.add(pname);
			listrow.add(phone);
			listrow.add(new Integer(age));
			listrow.add(email);
			listrow.add(address);
			listall.add(listrow);
		}
		
		return listall;
		
		
	
	}
	
	
	
	
	

}