infolist.java

J2EE架构的权限系统

/*
 * 创建日期 2005-8-27
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package org.infosys.logic;

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

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;

import org.infosys.util.ParamUtil;

import com.infosys.Hibernate.SessionFactory;
import com.infosys.Hibernate.TblNews;

/**
 * @author Administrator
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class InfoList {
	/**
	 * 信息列表
	 * @param startSerial 开始序列号
	 * @param maxLen 长度
	 * @return
	 */
	public ComList get(int startSerial,int maxLen){
		int pageSize=org.infosys.common.Constants.PAGE_SIZE;
		ComList itera=new ComList();
		ComParam para;
		String PagesStr="";
		Session session;
		
		try {
			session = SessionFactory.currentSession();
			Query query=session.createQuery("from TblNews a where a.status in (0,1) order by a.vieworder asc");
			query.setFirstResult(startSerial);
			query.setMaxResults(maxLen);
			List querylist=query.list();
			if(querylist!=null && querylist.size()>0){
				List list=new ArrayList();
				TblNews tblNews;
				String bgcolor="#ffffff";
				for(int i=0;i<querylist.size();i++){
					bgcolor=((i % 2)==0)?"#ffffff":"#eaeaea";
					tblNews=(TblNews)querylist.get(i);
					para=new ComParam();
					para.setParam0(bgcolor);
					para.setParam1(""+tblNews.getId());
					para.setParam2(tblNews.getTitle());
					para.setParam3(ParamUtil.getDate(tblNews.getPubdate(),"yyyy-MM-dd HH:mm:ss"));
					para.setParam4((tblNews.getStatus().intValue()==1)?"启用":"停用");
					list.add(para);
				}
				itera.setParamlist(list);
				tblNews=null;
			}
			querylist=null;
		} catch (HibernateException e) {
			e.printStackTrace();
		} finally {
			try {
				SessionFactory.closeSession();
			} catch (HibernateException e1) {
				e1.printStackTrace();
			}
		}
		return itera;
	}
	
	/**
	 * 信息列表
	 * @param startSerial 开始序列号
	 * @param maxLen 长度
	 * @param sqlFilter 过滤sql
	 * @return
	 */
	public ComList get(int startSerial,int maxLen,String sqlFilter){
		int pageSize=org.infosys.common.Constants.PAGE_SIZE;
		ComList itera=new ComList();
		ComParam para;
		String PagesStr="";
		Session session;
		
		try {
			session = SessionFactory.currentSession();
			Query query=session.createQuery("from TblNews a where a.status in (0,1) "+sqlFilter+" order by a.vieworder asc");
			query.setFirstResult(startSerial);
			query.setMaxResults(maxLen);
			List querylist=query.list();
			if(querylist!=null && querylist.size()>0){
				List list=new ArrayList();
				TblNews tblNews;
				String bgcolor="#ffffff";
				for(int i=0;i<querylist.size();i++){
					bgcolor=((i % 2)==0)?"#ffffff":"#eaeaea";
					tblNews=(TblNews)querylist.get(i);
					para=new ComParam();
					para.setParam0(bgcolor);
					para.setParam1(""+tblNews.getId());
					para.setParam2(tblNews.getTitle());
					para.setParam3(ParamUtil.getDate(tblNews.getPubdate(),"yyyy-MM-dd HH:mm:ss"));
					para.setParam4((tblNews.getStatus().intValue()==1)?"启用":"停用");
					list.add(para);
				}
				itera.setParamlist(list);
				tblNews=null;
			}
			querylist=null;
		} catch (HibernateException e) {
			e.printStackTrace();
		} finally {
			try {
				SessionFactory.closeSession();
			} catch (HibernateException e1) {
				e1.printStackTrace();
			}
		}
		return itera;
	}
}