userslist.java

J2EE架构的权限系统

/*
 * 创建日期 2005-8-26
 *
 * 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.PGroup;
import com.infosys.Hibernate.PUserBase;
import com.infosys.Hibernate.PUserExt;
import com.infosys.Hibernate.SessionFactory;

/**
 * @author Administrator
 * 用户列表显示
 */
public class UsersList {
	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 PUserExt a,PUserBase b,PGroup c where a.userid=b.userid and a.groupid=c.groupid order by a.regtime desc");
			query.setFirstResult(startSerial);
			query.setMaxResults(maxLen);
			List querylist=query.list();
			if(querylist!=null && querylist.size()>0){
				List list=new ArrayList();
				Object[] tmpObj;
				PUserExt userExt;
				PUserBase userBase;
				PGroup userGroup;
				
				String bgcolor="#ffffff";
				for(int i=0;i<querylist.size();i++){
					bgcolor=((i % 2)==0)?"#ffffff":"#eaeaea";
					tmpObj=(Object[])querylist.get(i);
					userExt=(PUserExt)tmpObj[0];
					userBase=(PUserBase)tmpObj[1];
					userGroup=(PGroup)tmpObj[2];
					para=new ComParam();
					para.setParam0(bgcolor);
					para.setParam1(userExt.getUserid());
					para.setParam2(userExt.getAccount());
					para.setParam3(userBase.getName());
					para.setParam4(userGroup.getName());
					para.setParam5(ParamUtil.getDate(userExt.getRegtime(),"yyyy-MM-dd HH:mm:ss"));
					para.setParam6((userExt.getStatus().intValue()==1)?"启用":"停用");
					list.add(para);
				}
				itera.setParamlist(list);
				userGroup=null;
				userExt=null;
				userBase=null;
				tmpObj=null;
			}
			querylist=null;
		} catch (HibernateException e) {
			e.printStackTrace();
		} finally {
			try {
				SessionFactory.closeSession();
			} catch (HibernateException e1) {
				e1.printStackTrace();
			}
		}
		return itera;
	}
	
	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 PUserExt a,PUserBase b,PGroup c where a.userid=b.userid and a.groupid=c.groupid "+sqlFilter+" order by a.regtime desc");
			query.setFirstResult(startSerial);
			query.setMaxResults(maxLen);
			List querylist=query.list();
			if(querylist!=null && querylist.size()>0){
				List list=new ArrayList();
				Object[] tmpObj;
				PUserExt userExt;
				PUserBase userBase;
				PGroup userGroup;
				String bgcolor="#ffffff";
				for(int i=0;i<querylist.size();i++){
					bgcolor=((i % 2)==0)?"#ffffff":"#eaeaea";
					tmpObj=(Object[])querylist.get(i);
					userExt=(PUserExt)tmpObj[0];
					userBase=(PUserBase)tmpObj[1];
					userGroup=(PGroup)tmpObj[2];
					para=new ComParam();
					para.setParam0(bgcolor);
					para.setParam1(userExt.getUserid());
					para.setParam2(userExt.getAccount());
					para.setParam3(userBase.getName());
					para.setParam4(userGroup.getName());
					para.setParam5(ParamUtil.getDate(userExt.getRegtime(),"yyyy-MM-dd HH:mm:ss"));
					para.setParam6((userExt.getStatus().intValue()==1)?"启用":"停用");
					list.add(para);
				}
				itera.setParamlist(list);
				userGroup=null;
				userExt=null;
				userBase=null;
				tmpObj=null;
			}
			querylist=null;
		} catch (HibernateException e) {
			e.printStackTrace();
		} finally {
			try {
				SessionFactory.closeSession();
			} catch (HibernateException e1) {
				e1.printStackTrace();
			}
		}
		return itera;
	}

}