contactbean.java

自己写的一个网络日志(BLOG)系统

package blog;
import java.util.*;
import java.sql.*;
/**
 * 
 * <p>Title: ContactBean
 * <p>Description: 分页类</p>
 * <p>Copyright: copyright (c) 2005-2005</p>
 * <p>Company: </p>
 * @author Administrator
 * @version 1.0.00_01
 */

public class ContactBean
{
	ArrayList artList = null;
	List v;
	public ContactBean(){
		
	}
	public ContactBean(String page,String strType,String value)throws Exception
	{
		String[] strTemp = null;
		CArtDAO artDao = CArtDAO.newInstance();
		if(strType.equals("day")){
			strTemp = value.split("-");
			int year = Integer.parseInt(strTemp[0]);
			int month = Integer.parseInt(strTemp[1]);
			int day = Integer.parseInt(strTemp[2]);
			String sql = "select * from Tarticles where postYear="+year+
						"and postMonth="+month+
						"and postDay="+day+" order by artID desc";
			artList = artDao.executeBySql(sql);
			
		}else if(strType.equals("cata")){
			int cataID = Integer.parseInt(value);
			String sql ="select * from Tarticles where cataID="+cataID+" order by artID desc";
			artList = artDao.executeBySql(sql);
		}else if(strType.equals("data")){
			strTemp = value.split("-");
			int year = Integer.parseInt(strTemp[0]);
			int month = Integer.parseInt(strTemp[1]);
			String sql = "select * from Tarticles where postYear="+year+
						"and postMonth="+month+" order by artID desc";
			artList = artDao.executeBySql(sql);
		}else{
			artList = artDao.executeQuery();
		}
		v=new Vector();
	}
	public int getAvailableCount()throws Exception
	{
		int ret=0;
		if(artList != null)
			ret = artList.size();
		return ret;		
		
	}
	public PageBean listData(String page,String strType,String value)throws Exception
	{
		try
		{
			
			PageBean pageBean=new PageBean(this);
			int pageNum=Integer.parseInt(page);
			
			String[] strTemp = null;
				int rowNum = 0;
				if(pageNum*pageBean.rowsPerPage>artList.size()){
						rowNum = artList.size();
				}else{
					rowNum = pageNum*pageBean.rowsPerPage;
				}
				for(int j =(pageNum-1)*pageBean.rowsPerPage ;j<rowNum;j++){
					CArticle article = (CArticle)artList.get(j);
					if(strType.equals("data")){
						strTemp= value.split("-");
						if( article.getPostYear() == Integer.parseInt(strTemp[0]) &&
							article.getPostMonth() == Integer.parseInt(strTemp[1])	
						)
						v.add(article);
					}else if(strType.equals("cata")){
						if(article.getCataID() == Integer.parseInt(value)){
							v.add(article);
						}
					}else if(strType.equals("day")){
						strTemp= value.split("-");
						if( article.getPostYear() == Integer.parseInt(strTemp[0]) &&
							article.getPostMonth() == Integer.parseInt(strTemp[1])	&&
							article.getPostDay() ==Integer.parseInt(strTemp[2])
						){
						v.add(article);
						}
						
					}else{
						v.add(article);
					}

				}
				
			
			

			pageBean.curPage=pageNum;
			pageBean.data=v;
			return pageBean;
		}
		catch(Exception e)
		{
		   	e.printStackTrace();
			throw e;
			
		}
	}
	public List getResult()throws Exception
	{
		return v;
	}
}