package gr.aegean.syros.jetspeed.portal.portlets;

/**
 * <p>Title: Portles</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: University of the Aegean</p>
 * @author Evangelos Vlachogiannis
 * @version 1.0
 */
import org.apache.jetspeed.portal.portlets.AbstractPortlet;
import org.apache.turbine.util.RunData;
import org.apache.turbine.om.security.User;
import org.apache.ecs.ConcreteElement;
import org.apache.ecs.StringElement;
import javax.servlet.*;
import javax.servlet.http.*;
import org.apache.jetspeed.portal.service.*;
import gr.aegean.syros.jetspeed.utils.*;
import java.util.Enumeration;
import java.util.Hashtable;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;


public class ForumViewer extends AbstractPortlet
{
  public ConcreteElement getContent (RunData runData)
  {
    StringBuffer out = new StringBuffer();
    String button = null;
    String username = runData.getUser().getFirstName();
    String useremail = runData.getUser().getEmail();

    HttpServletRequest request = runData.getRequest();
    button = request.getParameter("button");

      out.append("<h2>Forum Viewer</h2>");
      out.append("<form action=\"http://"+request.getServerName()+"/jetspeed/portal\" method=\"post\">");
      String  q = "SELECT * FROM forum"; //get columns

      try
      {
        ResultSet r = Db.QMySQL(q);

        while(r.next())
        {
          out.append("<br><table width=\"80%\" border=\"2\" cellspacing=\"2\" cellpadding=\"2\">");
          out.append("<tr>");
          out.append(" <td>ID: "+r.getString("id")+"</td>");
          out.append("</tr>");
          out.append("<tr>");
          out.append("  <td>From: "+r.getString("fromEmail")+"</td>");
          out.append("</tr>");
          out.append("<tr>");
          out.append(" <td>To: "+r.getString("toEmail")+"</td>");
          out.append("</tr>");
          out.append("<tr>");
          out.append(" <td>Date: "+r.getString("dateEmail")+"</td>");
          out.append("</tr>");
          out.append("<tr>");
          out.append("<td valign=\"top\"><p>");
          out.append(r.getString("bodyEmail")+"</p></td>");
          out.append("</tr>");
          out.append("</table>");
        }
      out.append("<input type=\"submit\" name=\"button\" value=\"Retrieve\">");
      out.append("</form>");
      }
      catch(java.sql.SQLException e)
      {
      }
      return (new StringElement(out.toString()));


  }
}