pagebean.java.svn-base

学习dwr+struts2+spring进行开发的好例子

package com.szhelper.lotteryWeb.util;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import org.apache.commons.lang.builder.ToStringBuilder;

public class PageBean {
	private int count = 0; // 记录总数
	private int pageSize = 10; // 每页显示记录数
	private int pageCount = 0; // 总页数
	private int page = 1; // 当前页数
	private String paginateSqlWhere; // 高级查找参数
	private List<String> parameterList = new ArrayList<String>();

	public int getCount() {
		return count;
	}

	public void setCount(int count) {
		if (pageSize != 0) {
			pageCount = count / pageSize;
			if (count % pageSize != 0) {
				pageCount++;
			}
		}
		this.count = count;
	}

	public int getPage() {
		return page;
	}

	public void setPage(int page) {
		this.page = page;
	}

	public int getPageCount() {
		return pageCount;
	}

	public void setPageCount(int pageCount) {
		this.pageCount = pageCount;
	}

	public int getPageSize() {
		return pageSize;
	}

	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}

	/**
	 * @see java.lang.Object#toString()
	 */
	public String toString() {
		return new ToStringBuilder(this).append("page", this.page).append(
				"pageCount", this.pageCount).append("pageSize", this.pageSize)
				.append("count", this.count).toString();
	}

	public String getPaginateSqlWhere() {
		return paginateSqlWhere;
	}

	public void setPaginateSqlWhere(String paginateSqlWhere) {
		this.paginateSqlWhere = paginateSqlWhere;
	}

	public void generateSqlWhere() {
		StringBuffer bufPaginateSqlWhere = new StringBuffer();
		int i = 0;

		for (String condition : parameterList) {
			if (i++ != 0)
				bufPaginateSqlWhere.append(" AND ");
			bufPaginateSqlWhere.append(condition);
		}
		setPaginateSqlWhere(bufPaginateSqlWhere.toString());
		System.out.println(this.getPaginateSqlWhere());
	}

	public void put(String fieldName, String fieldValue) {
		if (!Util.nullOrBlank(fieldValue))
			parameterList.add(fieldName + " like '%" + fieldValue + "%'");
	}

	public void put(String fieldName, Integer fieldValue) {
		if (fieldValue != null)
			parameterList.add(fieldName + " = " + fieldValue.intValue());
	}

	public void put(String fieldName, Date fromDate, Date toDate) {
		String sFromDate = "";
		String sToDate = "";
		if (fromDate != null)
			sFromDate = Util.formatDate(fromDate);
		if (toDate != null)
			sToDate = Util.formatDate(toDate);
		put(fieldName, sFromDate, sToDate);
	}

	public void put(String fieldName, String fromDate, String toDate) {
		StringBuffer buf = new StringBuffer();
		if (!Util.nullOrBlank(fromDate) && !Util.nullOrBlank(toDate)) {
			buf.append(fieldName);
			buf.append(" BETWEEN CONVERT(datetime,'");
			buf.append(fromDate);
			buf.append("',126)");
			buf.append(" AND CONVERT(datetime,'");
			buf.append(toDate);
			buf.append("',126)");
		} else if (!Util.nullOrBlank(fromDate)) {
			buf.append(fieldName);
			buf.append(" >= CONVERT(datetime,'");
			buf.append(fromDate);
			buf.append("',126)");
		} else if (!Util.nullOrBlank(toDate)) {
			buf.append(fieldName);
			buf.append(" <= CONVERT(datetime,'");
			buf.append(toDate);
			buf.append("',126)");
		}
		if (buf.length() > 0)
			parameterList.add(buf.toString());
	}

	public void put(String fieldName, Integer fromNum, Integer toNum) {
		StringBuffer buf = new StringBuffer();
		if (fromNum != null && toNum != null) {
			buf.append(fieldName);
			buf.append(" BETWEEN ");
			buf.append(fromNum);
			buf.append(" AND ");
			buf.append(toNum);
		} else if (fromNum != null) {
			buf.append(fieldName);
			buf.append(" >= ");
			buf.append(fromNum);
		} else if (toNum != null) {
			buf.append(fieldName);
			buf.append(" <= ");
			buf.append(toNum);
		}
		if (buf.length() > 0)
			parameterList.add(buf.toString());
	}

	public List<String> getParameterList() {
		return parameterList;
	}

	public void setParameterList(List<String> parameterList) {
		this.parameterList = parameterList;
	}
}