package book.rssreader;

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

public class RssUtil {
   public static String renderRSSList ()
   {
	   StringBuffer buf = new StringBuffer();
	   String strSQL = "select rss_id from rss where active_status='Y'";//查詢所有的RSS記錄
        Vector v = new Vector ();
		ResultSet rs = DbManager.getResultSet(strSQL);//執行查詢語句，得到記錄集
        try {
			while (rs.next())//循環記錄集，添加到向量v中
			{
				v.add(new RssEO(rs.getInt("RSS_ID")));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	   for (int i=0;i<v.size();i++)//輸出HTML代碼
	   {
		   RssEO rss = (RssEO)v.get(i);
		   buf.append("<a href=\"javascript:readRSS('"+rss.getRssURL()+"', 'rightcolumn');\">"+rss.getRssName()+"</a>");
	   }
	   return buf.toString();
   }
}