olusermanager.java

BBS论坛设计JSP＋MYSQL

package com.bcxy.bbs.forum;

/**
 * Title:
 * Description:
 * Copyright:
 * Company: www.liyunet.com
 * 
 * @author lishujiang	
 * @version 1.0
 */
import java.util.Vector;

import com.bcxy.db.SqlQuery;
import com.bcxy.util.SysUtil;

public class OLUserManager {
	int OLUserNum = 0;

	public OLUserManager() {
	}

	public int getOLUserNum() {
		return OLUserNum;

	}

	public Vector getOLUsers(String forumType, int start, int perPage) {
		Vector OLUsers = new Vector();
		forumType = SysUtil.encodeInDB(forumType);
		SqlQuery rs = new SqlQuery();
		try {
			String sql = "select * from online ";
			if (!"".equals(forumType)) {

				sql += " where stats like '%" + forumType + "%'";
			}
			rs.doQuery(sql);

			OLUserNum = rs.rowCount();
			int i = 0;

			rs.absolute(start);

			do {

				OLUser tempOLUser = new OLUser();
				tempOLUser.setUserID(rs.getString(1));
				tempOLUser.setUserName(rs.getString(2));
				tempOLUser.setUserClass(rs.getString(3));
				tempOLUser.setStats(rs.getString(4));
				tempOLUser.setUserIP(rs.getString(5));
				tempOLUser.setStartTime(rs.getString(6));
				tempOLUser.setLastTimeBK(rs.getString(7));
				tempOLUser.setLastTime(rs.getString(8));
				tempOLUser.setBrowser(rs.getString(9));
				tempOLUser.setActForIP(rs.getString(10));
				tempOLUser.setComeFrom(rs.getString(11));
				tempOLUser.setActCome(rs.getString(12));
				OLUsers.add(tempOLUser);

			} while (rs.next() && ++i < perPage);


		} catch (Exception e) {
			e.printStackTrace();

		}
		return OLUsers;

	}

}