mmsmobeanlist.java

彩信发送源代码,实现mm7接口

/**
 * <pre>
 *     这里说明修改记录,包括修改人,修改时间和修改目的和内容
 *     ---修改时间---修改人---修改目的和内容----------------------
 *     
 * </pre>
 */
package com.sxit.mms;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Hashtable;
import java.util.List;

/**
 * 
 * @author HuaFeng
 * @version 1.0 (2006-3-2 11:19:28)
 * 
 */
public class MMSMOBeanList {
	/** 存储查询的信息 */
	private List recList;

	public void setRecList(List recList) {
		this.recList = recList;
	}

	public List getRecList() {
		return recList;
	}

	/** 当前页面 */
	private int pageNo;

	public void setPageNo(int pageNo) {
		this.pageNo = pageNo;
	}

	public int getPageNo() {
		return pageNo;
	}

	/** 当页显示的条数 */
	private int pageSize;

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

	public int getPageSize() {
		return pageSize;
	}

	/** 传递到JSP页面的各相关信息 */
	private Hashtable recSearch;

	public void setRecSearch(Hashtable recSearch) {
		this.recSearch = recSearch;
	}

	public Hashtable getRecSearch() {
		return recSearch;
	}

	/** 查询的总记录数 */
	private int recCount;

	public void setRecCount(int recCount) {
		this.recCount = recCount;
	}

	public int getRecCount() {
		return recCount;
	}

	/**
	 * <br>
	 * 名 称: createList <br>
	 * 功 能: 得到相应表或视图中的所有记录信息 <br>
	 * 参 数: 数据库联接 <br>
	 * 返 回: 无
	 */
	public void createList(Connection con) throws SQLException {
		createList(con, 0, 0, "");
	}

	/**
	 * <br>
	 * 名 称: createList <br>
	 * 功 能: 根据条件strSearch得到表或视图中的相应记录信息 <br>
	 * 参 数: 数据库联接、查询条件 <br>
	 * 返 回: 无
	 */
	public void createList(Connection con, String strSearch) throws SQLException {
		createList(con, 0, 0, strSearch);
	}

	/**
	 * <br>
	 * 名 称: createList <br>
	 * 功 能: 根据pageNo,pageSize得到表或视图中的相应记录信息 <br>
	 * 参 数: 数据库联接、页码、每页记录数 <br>
	 * 返 回: 无
	 */
	public void createList(Connection con, int pageNo, int pageSize) throws SQLException {
		createList(con, pageNo, pageSize, "");
	}

	/**
	 * 利用可滚动的游标实现分页结果的处理
	 * 
	 * @param con
	 * @param pageNo
	 * @param pageSize
	 * @param strSearch
	 * @throws SQLException
	 */
	public void createList(Connection con, int pageNo, int pageSize, String strSearch) throws SQLException {

		PreparedStatement stmt = null;
		ResultSet rs = null;
		String sql = "select moid,messgeid,mmscid,LinkedID,sender,destination,sendtype,TimeStamp,ReplyChargingID,Priority,subject,transactionid,accepdate,mmdir from mmsmo where 1=1";
		int i = 0;
		recList = new ArrayList();
		try {
			if (pageNo == 0 && pageSize == 0) {
				stmt = con.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
				stmt.setFetchSize(50);
				rs = stmt.executeQuery();
				rs.last();// 跑到最后一行
				recCount = rs.getRow();// 得到总数
				if (pageNo == 1 || pageNo == 0)
					rs.beforeFirst();
				else
					rs.absolute(pageSize * (pageNo - 1));
				while (rs.next() && (pageSize == 0 ? true : i < pageSize)) {
					i++;

					MMSMOBean mmsmo = new MMSMOBean();
					mmsmo.setMOID(rs.getLong("moid"));
					mmsmo.setMessgeID(rs.getString("messgeid"));
					mmsmo.setMMSCID(rs.getString("mmscid"));
					mmsmo.setLinkedID(rs.getString("linkedid"));
					mmsmo.setSender(rs.getString("sender"));
					mmsmo.setDestination(rs.getString("destination"));
					mmsmo.setSendType(rs.getInt("sendtype"));
					mmsmo.setSendDate(rs.getTimestamp("timestamp"));
					mmsmo.setReplyChargingID(rs.getString("ReplyChargingID"));
					mmsmo.setPriority(rs.getInt("priority"));
					mmsmo.setSubject(rs.getString("subject"));
					mmsmo.setTransactionID(rs.getString("transactionid"));
					mmsmo.setAcceptDate(rs.getTimestamp("acceptdate"));
					mmsmo.setMMDir(rs.getString("mmdir"));

					recList.add(mmsmo);

				}

			}
		}
		finally {
			if (rs != null)
				rs.close();
			if (stmt != null)
				stmt.close();

		}
	}
}