package com.jspdev.business;

import java.util.*;
import com.jspdev.util.*;
import java.sql.*;
/**
 *實現了PageBusiness類，用于分頁顯示
 */
public class ForumBean extends PageBusiness
{
	private Connection conn;

	/**
	 *構造方法，獲得數據庫的連接
	 */
	public ForumBean()throws Exception
	{
		super();
		conn=DatabaseConn.getConnection();
		v=new Vector();
	}
	/**
	 *獲得所有記錄數
	 */
	public int getAvailableCount()throws Exception
	{
		return this.getAvailableCountHelper(conn,"topic");
	}

    /**
     *查詢數據庫，獲得要顯示的信息，然后通過pageBean返回
     */
	public PageBean listData(String page)throws Exception
	{
		try
		{
			PageBean pageBean=new PageBean(this);
			int pageNum=Integer.parseInt(page);
			Statement stmt=conn.createStatement();
			String strSql="select top "+pageNum*pageBean.rowsPerPage+" * from topic order by pubtime";
			ResultSet rset=stmt.executeQuery(strSql);
			int i=0;
			while(rset.next())
			{
				if(i>(pageNum-1)*pageBean.rowsPerPage-1)
				{
					
					Object[] obj=new Object[4];
					obj[0]=rset.getString("title");
					obj[1]=rset.getString("author");
					obj[2]=rset.getDate("pubtime");	
					obj[3]=rset.getString("id");			
					v.add(obj);
				}
				i++;
			}
			
			rset.close();
			stmt.close();
            conn.close();
			pageBean.curPage=pageNum;
			pageBean.data=v;
			return pageBean;
		}
		catch(Exception e)
		{
		   	e.printStackTrace();
			throw e;
			
		}
	}
	public Vector getResult()throws Exception
	{
		return v;
	}
}