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();//定義一個向量
		//構造查詢數據庫的SQL語句
		String sql = "select chat_id from chat";
		//返回記錄集結果
		ResultSet rs = DbManager.getResultSet(sql);
		
		ChatEO chat;
		try {
			while (rs.next()) {//循環記錄集，將結果保存到向量中
				chat = new ChatEO(rs.getInt("CHAT_ID"));
				vResult.add(chat);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		//將數據顯示成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>");
		//最后釋放數據庫連接
		DbManager.releaseConnection();
		return buf.toString();
	}
}