调用示例.java

封装的JAVA分页类 可直接调用

public Pagebean selectAllPage(int page)throws Exception
	{
		ArrayList<Userbean> list=new ArrayList<Userbean>();
		java.sql.PreparedStatement state=null;
		java.sql.ResultSet rs=null;
		java.sql.Connection con=null;
		Pagebean pb=new Pagebean();
		try
		{
			con=DBConnection.getConnection();
			Pageservice reg=new Pageservice();
			state=con.prepareStatement("select * from [usertest]",ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=state.executeQuery();
			/***设置分页属性*/
			reg.setRs(rs);
			reg.setPageSize(4);
			reg.gotoPage(page);
			for(int i=0;i<reg.getPageRowsCount();i++)
			{
				Userbean temp=new Userbean();
				temp.setId(new Integer(rs.getInt("id")));
				temp.setUsername(rs.getString("username"));
				temp.setPassword(rs.getString("password"));
				list.add(temp);	
				rs.next();
			}
			/***取得分页属性值*/
			int curPage=reg.getCurPage();
			int pageCount=reg.getPageCount();
			int pageSize=reg.getPageSize();
			int rowsCount=reg.getRowsCount();
			
			/***设置返回信息*/
			pb.setCurPage(curPage);
			pb.setList(list);
			pb.setPageCount(pageCount);
			pb.setPageSize(pageSize);
			pb.setRowsCount(rowsCount);
			
		}catch(Exception ex)
		{
			throw ex;
		}
		finally
		{
			 if (rs != null) {
	                try {
	                    rs.close();
	                } catch (SQLException ex1) {
	                }
	            }
	            if (state != null) {
	                try {
	                    state.close();
	                } catch (SQLException ex2) {
	                }
	            }
	            if (con != null) {
	                try {
	                    con.close();
	                } catch (SQLException ex3) {
	                }
	            }
		}
		return pb;
	}