src/bean/NewsBean.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package bean;

import java.util.ArrayList;

import util.Pagination;

public class NewsBean {
Pagination p = new Pagination();
	
	private String sql = "";
	private int count = 0;
	private int sumPage = 0;
	private ArrayList info = null;
	
	/**
	 * 获取总页数和总条数
	 */
	public void getInfo(String status){
		sql = "select count(*) as count from news where status='"+status+"'";
		count = p.getCount(sql);
		sumPage = p.getSumPage(count,10);
	}
	/**
	 * 获取当前页的信息
	 * @param page
	 * @return
	 */
	public ArrayList getInfo(int page,String status){
		sql = " and status='"+status+"'  order by id desc";
		String args[] = {"id","title","takeclass","fee","remarks","times","userid","status"};
		info = p.getPage(10,page,"news", sql, args);
		return info;
	}
	/**
	 * 返回总条数
	 * @return
	 */
	public int getCount(){
		return count;
	}
	/**
	 * 返回总页数
	 * @return
	 */
	public int getSumPage(){
		return sumPage;
	}
}