olusermanager.java

一个用jsp写的完整的论坛源代码

package com.bcxy.bbs.forum;

/**
 * Title:
 * Description:
 * Copyright:
 * Company: www.liyunet.com
 * 
 * @author lishujiang	
 * @version 1.0
 */

import java.util.Vector;

import com.bcxy.bbs.util.BBSConst;
import com.bcxy.db.JdbcWrapper;

public class OLUserManager {
	int OLUserNum = 0;

	public OLUserManager() {
	}

	public int getOLUserNum() {
		return OLUserNum;
	}

	public Vector getOLUsers(String forumType, int offset, int rowcount) {
		Vector OLUsers = new Vector();
		JdbcWrapper jw = new JdbcWrapper();
		try {
			String sql = "select * from " + BBSConst.TABLE_ONLINE + " ";
			if (!"".equals(forumType)) {
				sql += " where stats like '%" + forumType + "%'";
			}
			jw.executeLimitQuery(sql, offset-1, rowcount);
			OLUserNum = jw.getAllRows();
			while (jw.next()) {
				OLUser tempOLUser = new OLUser();
				tempOLUser.setUserID(jw.getString(1));
				tempOLUser.setUserName(jw.getString(2));
				tempOLUser.setUserClass(jw.getString(3));
				tempOLUser.setStats(jw.getString(4));
				tempOLUser.setUserIP(jw.getString(5));
				tempOLUser.setStartTime(jw.getString(6));
				tempOLUser.setLastTimeBK(jw.getString(7));
				tempOLUser.setLastTime(jw.getString(8));
				tempOLUser.setBrowser(jw.getString(9));
				tempOLUser.setActForIP(jw.getString(10));
				tempOLUser.setComeFrom(jw.getString(11));
				tempOLUser.setActCome(jw.getString(12));
				OLUsers.add(tempOLUser);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			jw.close();
		}
		return OLUsers;
	}
}