00f68a8d74b1001d13c1f4b049de5fa5

来自「mysql+stuts jdbc连接数据库 BBS论坛」· 代码 · 共 52 行

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 getResponseCount(DB db, int topicid) throws Exception {
		ResultSet rs;
		String strSql = null;
		int iRecordCount = 0;

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

	
		
	}
}