package oa.bean;

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


public class Page extends ParentBean
{
	private long totalnum;//總條數(shù)
	private long totalpage;//總頁數(shù)
	private long currentpage;//當(dāng)前頁
	private long prepage,nextpage;//前一頁，后一頁
	private int  num;         //每頁條數(shù) 
	/**    
	  *
	  *   構(gòu)造函數(shù)
	  */
	public Page() 
	{
	}

	/**    取得當(dāng)前頁
	  *
	  */
	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;
	}
	/**     取得總條數(shù)
	  *
	  */
	public long gettotalnum(int totalnum)
	{
		
		return totalnum;
	}
	/**      取得總頁數(shù)
	  *
	  */
	public long gettotalpage(long totalnum,int num)
	{
		int temp;
		if (num == 0)
		{
			return 1;
		}
		temp = (int)totalnum%num; //取得余數(shù)
		//取得總頁數(shù)
		totalpage = totalnum==0?1:(temp==0?totalnum/num:totalnum/num+1);
		return totalpage;
	}
	/**    對每頁條數(shù)的操作
	  *
	  */
	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='郵件每頁條數(shù)'";
		try
		{
			doc = new DocBean();
			rs = doc.QuerySQL(sql);
			if (rs.next())
			{
				num = Integer.parseInt(rs.getString(1));
			}
		}
		catch(Exception e){System.out.println("Page運(yùn)行時(shí)出錯(cuò)："+e);}
		finally{
			if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("關(guān)閉記錄集rs時(shí)出錯(cuò)"+e);}
			if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("關(guān)閉聲明時(shí)statement出錯(cuò)"+e);}		
			//if(rb!=null)  rb.closeConn();
			if(doc!=null) doc.closeConn();
		}
		return num;
	}
}