package book.chat;

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

import book.chat.table.ChatEO;

public class ChatUtil {
	public static String renderChatroom() {
		Vector vResult = new Vector();//定義一個向量
		//構(gòu)造查詢數(shù)據(jù)庫的SQL語句
		String sql = "select chat_id from chat";
		//返回記錄集結(jié)果
		ResultSet rs = DbManager.getResultSet(sql);
		
		ChatEO chat;
		try {
			while (rs.next()) {//循環(huán)記錄集，將結(jié)果保存到向量中
				chat = new ChatEO(rs.getInt("CHAT_ID"));
				vResult.add(chat);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		//將數(shù)據(jù)顯示成HTML的格式
		StringBuffer buf = new StringBuffer();
		buf.append("<SELECT name=\"roomlist\" size=\"5\" class=\"textInput\">");
		for (int i = 0; i < vResult.size(); i++) {
			ChatEO c = (ChatEO) vResult.get(i);
			buf.append("<OPTION value=\"" + c.getChatID() + "\">"
					+ c.getChatName() + "</OPTION>");
		}
		buf.append("</SELECT>");
		//最后釋放數(shù)據(jù)庫連接
		DbManager.releaseConnection();
		return buf.toString();
	}
}