package book.portal.portlet;

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

import book.portal.table.*;
import book.portal.*;

public class Bookmark extends BasePortletClass{

	public String render(UserEO user, PortletEO portlet) {
		StringBuffer buf=new StringBuffer();
		String sql ="select content_id from ajax_content where content_type='BOOKMARK' and user_id="+user.getId();
		ResultSet rs = DbManager.getResultSet( sql );
		Vector v = new Vector();
		try {
			while (rs.next())
				v.add( new ContentEO( rs.getInt("CONTENT_ID")));
		} catch (SQLException e) {
			e.printStackTrace();
		}
		buf.append("<ul align=left>");
		for ( int i=0;i<v.size();i++)
		{	
			ContentEO c = (ContentEO)v.get(i);
			buf.append( "<li>"+c.getContentMain()+"</li>");
		}
		buf.append("</ul>");	
		return addBorder( user ,portlet ,buf.toString(),false);
	}

}