page.java

这是一个很好用的软件

package oa.bean;

import oa.main.*;
import javax.servlet.http.*;
import java.sql.*;

public class Page extends ParentBean {
	private long totalnum;//总条数

	private long totalpage;//总页数

	private long currentpage;//当前页

	private long prepage, nextpage;//前一页，后一页

	private int num; //每页条数

	/**
	 * 
	 * 构造函数
	 */
	public Page() {
	}

	/**
	 * 取得当前页
	 *  
	 */
	public long curpage(String page, HttpServletRequest request) {
		String strpage = request.getParameter(page);
		if (strpage == null || strpage.equals("")) {
			currentpage = 1;
		} else {
			currentpage = Integer.parseInt(strpage);
			if (currentpage < 1) {
				currentpage = 1;
			}
		}
		return currentpage;
	}

	/**
	 * 取得总条数
	 *  
	 */
	public long gettotalnum(int totalnum) {

		return totalnum;
	}

	/**
	 * 取得总页数
	 *  
	 */
	public long gettotalpage(long totalnum, int num) {
		int temp;
		if (num == 0) {
			return 1;
		}
		temp = (int) totalnum % num; //取得余数
		//取得总页数
		totalpage = totalnum == 0 ? 1 : (temp == 0 ? totalnum / num : totalnum
				/ num + 1);
		return totalpage;
	}

	/**
	 * 对每页条数的操作
	 *  
	 */
	public void setNum(int per_num) {
		num = per_num;
	}

	public int getNum() {
		//return num;
		DocBean doc = null;
		int num = 0;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "select XMMC from news.CODE_ZDB where ZDMC='邮件每页条数'";
		try {
			doc = new DocBean();
			rs = doc.QuerySQL(sql);
			if (rs.next()) {
				num = Integer.parseInt(rs.getString(1));
			}
		} catch (Exception e) {
			System.out.println("Page运行时出错：" + e);
		} finally {
			if (rs != null)
				try {
					stmt = rs.getStatement();
					rs.close();
				} catch (Exception e) {
					System.out.println("关闭记录集rs时出错" + e);
				}
			if (stmt != null)
				try {
					stmt.close();
				} catch (Exception e) {
					System.out.println("关闭声明时statement出错" + e);
				}
			//if(rb!=null) rb.closeConn();
			if (doc != null)
				doc.closeConn();
		}
		return num;
	}
}