queryrecentmmsaction.java

MM7彩信对接网关示例

/*
 * Created on 2005-8-3
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package com.rainbow.mms.queryservice;

import java.util.List;

import org.apache.log4j.Logger;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;

import com.opensymphony.webwork.ServletActionContext;
import com.opensymphony.xwork.ActionContext;
import com.opensymphony.xwork.ActionSupport;
import com.rainbow.mms.common.MmsContent;
import com.rainbow.util.tools.HibernateUtil;

/**
 * 按照pageNum翻页按照彩信内容体创建的时间倒序来查询彩信内容体，
 * 每页30条彩信内容体实体。结果集存储在Session的resultList对象里。
 * @author Rainbow MMS Group Leader —— TrWorks
 */
public class QueryRecentMmsAction extends ActionSupport {
	
	private static final long serialVersionUID = 1L;
	private Logger log = Logger.getLogger(QueryRecentMmsAction.class);

	public String execute() throws Exception {
		
		String number = ServletActionContext.getRequest().getParameter("pageNum");
		
		int pageNum;
		if (number == null){
			log.error("QueryRecentMmsAction function input param pageNum is null.");			
			return ERROR;
		}
		else{
			pageNum = Integer.parseInt(number);
		}
		
		String result = ERROR;
		try{
			Session sess = HibernateUtil.currentSession();
			Criteria c = sess.createCriteria(MmsContent.class);
			c.add(Restrictions.eq("createFrom", new Integer(0)));
			c.addOrder(Order.desc("contentId"));
			c.setFirstResult(pageNum * 30);
			c.setMaxResults(30);
			List resultList = c.list();
			
			ActionContext.getContext().getSession().put("resultList", resultList);
			ActionContext.getContext().getSession().put("queryPageNum", new Integer(pageNum));
			
			result = SUCCESS;
		}
		catch(Exception e){
			e.printStackTrace();
		}
		finally{
			HibernateUtil.closeSession();
		}
		
		return result;
	}
}