2051026836af001d1dbfdb48d43e4f38

mysql+stuts jdbc连接数据库 BBS论坛

package j2eebbs;

import java.sql.ResultSet;
import java.util.Vector;

public class ResponseDisp extends Response {

	private int reCount;

	private String lastTalk;

	public ResponseDisp() {
	}

	public int getReCount() {

		return reCount;

	}

	public void setReCount(int reCount) {

		this.reCount = reCount;
	}

	public String getLastTalk() {

		return lastTalk;
	}

	public void setLastTalk(String lastTalk) {

		this.lastTalk = lastTalk;
	}

	public int getTopicCount(DB db, int forumid) throws Exception {
		ResultSet rs;
		String strSql = null;
		int iRecordCount = 0;

		strSql = "select count(*) from topic where forumid=" + forumid;
		rs = db.OpenSql(strSql);
		if (rs.next()) {
			iRecordCount = rs.getInt(1);
		}
		return iRecordCount;
	}

	
	}
}