package isip.java.bullyse.bullydb;

import java.io.*;
import java.util.*;
import java.text.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class nonMember extends HttpServlet {

    // Initialize BullyDB Object
    static BullyDB sessionbase = new BullyDB();

    // System parameters are stored in the database, retrieve the values
    // through the BullyDB object.
    static String SystemURL = sessionbase.getURL();
    static String ServletURL = sessionbase.getServletURL();
    static String SystemEmail = sessionbase.getEmail();
    static String SystemPath = sessionbase.getPath();
    static String SystemName = sessionbase.getName();
    static String SystemShortName = sessionbase.getShortName();
    
    public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws IOException, ServletException
    {
	// Initialize variables
	String task = request.getParameter("task");

	String query = (String)null;
	ResultSet result = null;

	String SessionId = "nonMember";

	sessionbase.putUser();

	// Initialize the output stream.
	response.setContentType("text/html");
	PrintWriter out = response.getWriter();

	if(task == null) {
	    printTop(out, 1);
	    out.println("<TD class=\"lightbody\" width=\"100%\">");
	    out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	    out.println("<tr><td valign=\"_top\">");
	    out.println("<img src=\"" + SystemURL + "/html/images/home_head.gif\" alt=\"Home\" width=\"178\" height=\"26\"><br>");
	    out.println("<center>Welcome to the Bulldog Stock Exchange!<br>");
	    sessionbase.displayGraph(out, "1", "SYS", 0);
	    out.println("</center></td>");
	    printBot(out);
	    out.close();
	} else if (task.equals("logout")) {
	    String AccountId = (String)null;
	    HttpSession session = request.getSession();
	    SessionId = session.getId();
	    
	    // Retrieve AccountId, make sure the user is logged in before we try to log
	    // him out.
	    AccountId = sessionbase.getAccountId(SessionId);
	    
	    if (AccountId == null) {
		// User login must have timed in already, so
		// nothing needs to be done. Simply redirect
		// to Login page.
		
		response.sendRedirect(SystemURL + "/index.html");
	    } else {
		
		// Close the HttpSession
		sessionbase.doLogout(SessionId);
		session.invalidate();
		
		// User is logged out, simply send them back to the
		// Login page
		response.sendRedirect(SystemURL + "/index.html");
	    }
	} else if (task.equals("passChange")) {
	    printTop(out, 2);
	    out.println("<TD class=\"lightbody\" width=\"100%\">");
	    out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	    out.println("<tr><td valign=\"_top\">");
	    out.println("<img src=\"" + SystemURL + "/html/images/account_head.gif\" alt=\"Home\" width=\"178\" height=\"26\"><br>");
	    out.println("<b>Success:</b><br><br>");
	    out.println("A new password has been emailed to your account.");
	    out.println("</td>");
	    printBot(out);
	    out.close();
	} else if (task.equals("news")) {
	    displayNews(request, response, "nonMember");
	} else if (task.equals("showHeadlines")) {
	    displayHeadlines(request, response, "nonMember");
	} else if (task.equals("showArchives")) {
	    displayArchives(request, response, "nonMember");
	} else if (task.equals("showArticle")) {
	    displayArticle(request, response, "nonMember");
	} else if (task.equals("LI")) {
	    String Type = request.getParameter("Type");

	    if (Type.equals("1")) {
		printTop(out, 2);
		out.println("<TD class=\"lightbody\" width=\"100%\">");
		out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
		out.println("<tr><td valign=\"_top\">");
		out.println("<img src=\"" + SystemURL + "/html/images/portfolio_head.gif\" alt=\"Home\" width=\"178\" height=\"26\"><br>");
		out.println("<b>Not Logged In</b><br><br>");
		out.println("You must be logged in to the system to use this page. You don't appear to be logged in to the system, or you have cookies turned off. To use the " + SystemName + ", Cookies must be enabled in your browser properties.");
		out.println("</td>");
		printBot(out);
		out.close();
	    } else if (Type.equals("2")) {
		printTop(out, 3);
		out.println("<TD class=\"lightbody\" width=\"100%\">");
		out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
		out.println("<tr><td valign=\"_top\">");
		out.println("<img src=\"" + SystemURL + "/html/images/account_head.gif\" alt=\"Home\" width=\"178\" height=\"26\"><br>");
		out.println("<b>Not Logged In</b><br><br>");
		out.println("You must be logged in to the system to use this page. You don't appear to be logged in to the system, or you have cookies turned off. To use the " + SystemName + ", Cookies must be enabled in your browser properties.");
		out.println("</td>");
		printBot(out);
		out.close();
	    } else if (Type.equals("3")) {
		printTop(out, 4);
		out.println("<TD class=\"lightbody\" width=\"100%\">");
		out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
		out.println("<tr><td valign=\"_top\">");
		out.println("<img src=\"" + SystemURL + "/html/images/buysell_head.gif\" alt=\"Home\" width=\"178\" height=\"26\"><br>");
		out.println("<b>Not Logged In</b><br><br>");
		out.println("You must be logged in to the system to use this page. You don't appear to be logged in to the system, or you have cookies turned off. To use the " + SystemName + ", Cookies must be enabled in your browser properties.");
		out.println("</td>");
		printBot(out);
		out.close();
	    }
	} else if (task.equals("Quotes")) {
	    displayAll(request, response);
	} else if (task.equals("viewQuote")) {
	    String Symbol = request.getParameter("Symbol");
	    displayQuote(Symbol, request, response);
	} else if (task.equals("password")) {
	    printTop(out, 3);
	    out.println("<TD class=\"lightbody\" width=\"100%\">");
	    out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	    out.println("<tr><td valign=\"_top\">");
	    out.println("<img src=\"" + SystemURL + "/html/images/account_head.gif\" alt=\"BSE Home\" width=\"178\" height=\"26\"><br>");
	    out.println("If you have forgotten your Username or Password(or both) just enter your Email address here. Your Username and a new Password will then be Emailed to you. You must enter the Email address that is registered to your account.<br><br>");
	    out.println("Note: This is not to create a new account, this is only if you have forgotten the Username or Password of an existing account.<br>");
	    out.println("<form action=\"" + ServletURL + ".profile\"  method=POST>");
	    out.println("<input type=\"hidden\" name=\"task\" value=\"password\">");
	    out.println("Email: <input type=\"text\" name=\"email\" size=\"20\">");
	    out.println("<input type=\"submit\" name=\"submit\" value=\"submit\"></form>");
	    out.println("</td>");
	    printBot(out);
	    out.close();
	} else if (task.equals("notloggedin")) {
	    printTop(out, 1);
	    out.println("<TD class=\"lightbody\" width=\"100%\">");
	    out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	    out.println("<tr><td valign=\"_top\">");
	    out.println("<img src=\"" + SystemURL + "/html/images/home_head.gif\" alt=\"BSE Home\" width=\"178\" height=\"26\"><br>");
	    out.println("<b>Not Logged In:</b><br>");
	    out.println("You must be logged in to the system to use this page. You don't appear to be logged in to the system, or you have cookies turned off. To use the Bulldog Stock Exchange, Cookies must be enabled in your browser properties.");
	    out.println("</td>");
	    printBot(out);
	    out.close();
	} else if (task.equals("createAccount")) {
	    printTop(out, 3);
	    out.println("<TD class=\"lightbody\" width=\"100%\">");
	    out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	    out.println("<tr><td valign=\"_top\">");
	    out.println("<img src=\"" + SystemURL + "/html/images/account_head.gif\" alt=\"BSE Home\" width=\"178\" height=\"26\"><br>");
	    out.println("<b>Account Creation</b><br>");
	    out.println("Automatic Account creation is not permitted. Email <a target=\"_top\" href=\"mailto:" + SystemEmail + "\">" + SystemEmail + "</a> to get an account.");
	    out.println("</td>");
	    printBot(out);
	    out.close();
	}
    }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException
    {
	// Extract variable that tells what task we are to perform
	String task = request.getParameter("task");

	String query = (String)null;
	ResultSet result = null;

	sessionbase.putUser();

	// Initialize the output stream.
	response.setContentType("text/html");
	PrintWriter out = response.getWriter();

	// Initialize variables
	boolean Login = false;
	String username = request.getParameter("username");
	String password = request.getParameter("password");

	String Message = "";
	int error = 0;

	if (task.equals("login")) {
	    // Make sure they actually put in a login/password. No need to query the
	    // database if one of these is missing. 
	    
	    if (username.length()<1 || password.length()<1) {
		// Open error file
		Message += "The username or password you entered is invalid.<br>";
		error++;
	    } else {
		
		HttpSession session = request.getSession(true);

		// Check to see if the user is logged in already. If so, close
		// the old session.
		if (!session.isNew()) {
		    session.invalidate();
		    session = request.getSession(true);
		}
		
		String SessionId = session.getId();
		
		// Check for a user lock
		query = "select Locked from Account where Username = '" + username + "'";
		result = sessionbase.doQuery(query);
		
		String LockStatus = (String)null;
		
		try {
		    while (result.next()) {
			LockStatus = result.getString("Locked");
		    }
		} catch (Exception e) {
		    e.printStackTrace();
		}
		
		if (LockStatus.equals("Y")) {
		    // User is locked
		    Message += "Your account has been locked by a " + SystemName + " administrator.<br>";
		    error++;
		}
		
		// Check for a System lock.
		if (sessionbase.checkLock() && !sessionbase.checkRoot(username)) {
		    Message += "Logins are not permitted at this time.<br>";
		    error++;
		}
		
		if (error == 0) {
		    // Attempt to log in the user.
		    Login = sessionbase.doLogon(username, password, SessionId);
		    
		    if (Login != true) {
			// Don't want to leave a session open if the user didn't
			// successfully log in
			
			session.invalidate();
			Message += "The username or password you entered is invalid.<br>";
			error++;
		    }
		}
		
		if (error > 0) {
		    printTop(out, 1);
		    out.println("<TD class=\"lightbody\" width=\"100%\">");
		    out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
		    out.println("<tr><td valign=\"_top\">");
		    out.println("<img src=\"" + SystemURL + "/html/images/home_head.gif\" alt=\"Home\" width=\"178\" height=\"26\"><br><br>");
		    out.println("<b>Login Error:</b>");
		    out.println(Message);
		    out.println("</td>");
		    printBot(out);
		    out.close();
		} else {
		    // Create a new session for the user and set the maximum they
		    // can be inactive
		    session.setAttribute("Exchange.user." + sessionbase.getAccountId(SessionId), sessionbase);
		    session.setMaxInactiveInterval(3600);
		    
		    // Update LastLogin on the Account table
		    query = "update Account set LastLogin = NOW() where AccountId = " + sessionbase.getAccountId(SessionId);
		    sessionbase.doUpdate(query, SessionId);
		    
		    // Check to see what user is logging in. If this is the
		    // Administrative user, send them to a different page
		    
		    if (sessionbase.checkRoot(username)) {		
			// Must be admin, redirect to Admin page
			response.sendRedirect(ServletURL + ".Admin");
		    } else {
			response.sendRedirect(ServletURL + ".Portfolio?task=Members");
		    }
		}
	    }
	}
    }

    public void printTop(PrintWriter out, int On)
	throws IOException {

	// This method prints out the Link bar and Admin tools portion.
	// The On variable is to show which link is the active one.
	//
	// 1 - Home
	// 2 - Portfolio
	// 3 - Account
	// 4 - Buy & Sell
	// 5 - Quotes
	// 6 - News

	out.println("<HTML><HEAD>");
	out.println("<TITLE>" + SystemName + "</TITLE>");
	out.println("<link rel=\"stylesheet\" href=\"" + SystemURL + "/style.css\">");
	out.println("</HEAD>");
	out.println("<BODY link=\"FF6600\" vlink=\"darkblue\" class=\"lightbody\" marginheight=3 topmargin=3 bgColor=#ffffff>");
	out.println("<TABLE cellSpacing=0 cellPadding=0 width=\"610\" border=0><TBODY> <TR> ");
	out.println("<TD class=\"lightbody\" valign=\"_top\"> ");
	out.println("<div align=\"left\">");
	out.println("<A name=top></A>");
	out.println("<a class=\"small\" href=\"" + SystemURL + "/html/errors/construction.html\">Help</a>");
	out.println("</div></TD>");
	out.println("<TD class=\"lightbody\" valign=\"_top\"> ");
	out.println("</TD>");
	out.println("<TD class=\"lightbody\" rowspan=\"2\">");
	out.println("<img src=\"" + SystemURL + "/html/images/banner.gif\" border=\"0\" align=\"right\"");
	out.println("alt=\"" + SystemName + "\">");
	out.println("</TD>");
	out.println("</TR>");
	out.println("<TR> ");
	out.println("<TD class=\"lightbody\" colspan=\"2\">&nbsp;</TD></TR>");
	out.println("<TR align=left> ");
	out.println("<TD class=\"lightbody\" align=\"center\" colspan=\"3\"><nobr>");

	if (On == 1) {
	    out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember\"><img src=\"" + SystemURL + "/html/images/home_on.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Home\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=1\"><img src=\"" + SystemURL + "/html/images/portfolio_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"My Portfolio\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=2\"><img src=\"" + SystemURL + "/html/images/account_off.gif\" vspace=0 hspace=0 border=0 alt=\"My Account\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=3\"><img src=\"" + SystemURL + "/html/images/buysell_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Buy & Sell\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\"><img src=\"" + SystemURL + "/html/images/quotes_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Quotes & Research\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=news\"><img src=\"" + SystemURL + "/html/images/news_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"News Headlines\"></a>");
	} else if (On == 2) {
	    out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember\"><img src=\"" + SystemURL + "/html/images/home_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Home\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=1\"><img src=\"" + SystemURL + "/html/images/portfolio_on.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"My Portfolio\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=2\"><img src=\"" + SystemURL + "/html/images/account_off.gif\" vspace=0 hspace=0 border=0 alt=\"My Account\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=3\"><img src=\"" + SystemURL + "/html/images/buysell_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Buy & Sell\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\"><img src=\"" + SystemURL + "/html/images/quotes_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Quotes & Research\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=news\"><img src=\"" + SystemURL + "/html/images/news_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"News Headlines\"></a>");
	} else if (On == 3) {
	    out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember\"><img src=\"" + SystemURL + "/html/images/home_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Home\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=1\"><img src=\"" + SystemURL + "/html/images/portfolio_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"My Portfolio\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=2\"><img src=\"" + SystemURL + "/html/images/account_on.gif\" vspace=0 hspace=0 border=0 alt=\"My Account\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=3\"><img src=\"" + SystemURL + "/html/images/buysell_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Buy & Sell\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\"><img src=\"" + SystemURL + "/html/images/quotes_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Quotes & Research\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=news\"><img src=\"" + SystemURL + "/html/images/news_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"News Headlines\"></a>");
	} else if (On == 4) {
	    out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember\"><img src=\"" + SystemURL + "/html/images/home_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Home\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=1\"><img src=\"" + SystemURL + "/html/images/portfolio_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"My Portfolio\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=2\"><img src=\"" + SystemURL + "/html/images/account_off.gif\" vspace=0 hspace=0 border=0 alt=\"My Account\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=3\"><img src=\"" + SystemURL + "/html/images/buysell_on.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Buy & Sell\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\"><img src=\"" + SystemURL + "/html/images/quotes_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Quotes & Research\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=news\"><img src=\"" + SystemURL + "/html/images/news_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"News Headlines\"></a>");
	} else if (On == 5) {
	    out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember\"><img src=\"" + SystemURL + "/html/images/home_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Home\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=1\"><img src=\"" + SystemURL + "/html/images/portfolio_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"My Portfolio\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=2\"><img src=\"" + SystemURL + "/html/images/account_off.gif\" vspace=0 hspace=0 border=0 alt=\"My Account\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=3\"><img src=\"" + SystemURL + "/html/images/buysell_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Buy & Sell\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\"><img src=\"" + SystemURL + "/html/images/quotes_on.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Quotes & Research\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=news\"><img src=\"" + SystemURL + "/html/images/news_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"News Headlines\"></a>");
	} else if (On == 6) {
	    out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember\"><img src=\"" + SystemURL + "/html/images/home_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Home\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=1\"><img src=\"" + SystemURL + "/html/images/portfolio_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"My Portfolio\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=2\"><img src=\"" + SystemURL + "/html/images/account_off.gif\" vspace=0 hspace=0 border=0 alt=\"My Account\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=3\"><img src=\"" + SystemURL + "/html/images/buysell_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Buy & Sell\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\"><img src=\"" + SystemURL + "/html/images/quotes_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Quotes & Research\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=news\"><img src=\"" + SystemURL + "/html/images/news_on.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"News Headlines\"></a>");
	} else {
	    out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember\"><img src=\"" + SystemURL + "/html/images/home_on.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Home\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=1\"><img src=\"" + SystemURL + "/html/images/portfolio_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"My Portfolio\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=2\"><img src=\"" + SystemURL + "/html/images/account_off.gif\" vspace=0 hspace=0 border=0 alt=\"My Account\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=LI&Type=3\"><img src=\"" + SystemURL + "/html/images/buysell_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Buy & Sell\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\"><img src=\"" + SystemURL + "/html/images/quotes_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"Quotes & Research\"></a><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=news\"><img src=\"" + SystemURL + "/html/images/news_off.gif\" hspace=\"0\" vspace=\"0\" border=\"0\" alt=\"News Headlines\"></a>");
	}

	out.println("</nobr></TD></TR></TBODY> </TABLE>");
	out.println("<TABLE cellSpacing=3 cellPadding=1 width=\"610\" border=0><TBODY> ");
	out.println("<TR valign=top><TD width=\"110\"> ");
	out.println("<table cellspacing=0 cellpadding=1 width=100% bgcolor=#707070 border=0>");
	out.println("<tbody><tr><td width=\"100%\"> ");
	out.println("<table cellspacing=0 cellpadding=3 width=\"100%\" bgcolor=#707070 border=0>");
	out.println("<tbody> ");
	out.println("<tr bgcolor=\"#d0d0d0\"> ");
	out.println("<td class=\"darkbox\" bgcolor=\"#707070\" valign=center align=left> ");
	out.println("<b>Login<br>");
	out.println("</b>to your account");
	out.println("</td></tr><tr>");
	out.println("<td valign=top width=\"100%\" class=\"lightbox\" bgcolor=\"FFFFFF\"> ");
	out.println("<FORM action=\"" + ServletURL + ".nonMember\" method=POST>");
	out.println("<input type=\"hidden\" name=\"task\" value=\"login\">");
	out.println("<div align=\"left\">");
	out.println("<table border=\"0\" cellspacing=\"0\" cellpadding=\"1\">");
	out.println("<tr align=\"left\" valign=\"middle\"><td> ");
	out.println("<input size=12 name=username maxlength=\"12\"></td><td>&nbsp;</td></tr>");
	out.println("<tr align=\"left\" valign=\"middle\"><td> ");
	out.println("<INPUT size=12 name=password type=\"password\" maxlength=\"12\"></td><td> ");
	out.println("<input type=image src=\"" + SystemURL + "/html/images/go2.gif\" align=absmiddle value=\"set\" border=0 name=\"Go!\" width=\"20\" height=\"20\">");
	out.println("</td></tr></table>");
	out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=password\">Forgot password?</a></div></form>");
	out.println("<p>");

	out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=createAccount\"><img alt=More src=\"" + SystemURL + "/html/images/orange-arrow.gif\" border=0>Create account</a></p></td></tr></tbody></table></td></tr></tbody></table><br>");

	// Output the Quote Flash data
	try {
	    QuoteFlash(out);
	} catch (Exception e) {
	    e.printStackTrace();
	}

	// Fill in the blanks from the template
	out.println("</TD>");
    }

    public void printBot(PrintWriter out)
	throws IOException {

	String SessionId = "nonMember";

	Locale locale = new Locale("en","US");
	DateFormat shortFormat = DateFormat.getDateInstance(DateFormat.SHORT, locale);	String weekTitle = (String)null;
	String weekId = (String)null;
	java.util.Date weekDate = new java.util.Date();
	java.util.Date weekDateO = new java.util.Date();

	out.println("<td class=\"lightbox\" align=\"right\" valign=\"_top\">");
	out.println("<TABLE cellSpacing=0 cellpadding=3 width=\"100%\" border=0>");
	out.println("<TBODY>");
	out.println("<TR>");
	out.println("<TD align=\"right\" class=\"lightbox\" width=\"1\">&nbsp;</TD>");
	out.println("<TD align=\"right\" class=\"lightbox\"> ");
	out.println("<TABLE cellSpacing=0 cellPadding=1 width=120 bgColor=#707070 border=0 align=\"right\">");
	out.println("<TBODY>");
	out.println("<TR>");
	out.println("<TD width=\"100%\">");
	out.println("<TABLE cellSpacing=0 cellpadding=3 width=\"100%\" bgColor=#707070 border=0>");
	out.println("<TBODY>");

	out.println("<TR bgcolor=\"#d0d0d0\"> ");
	out.println("<TD class=\"lightbox\" bgcolor=\"#d0d0d0\" vAlign=center align=left> ");
	out.println("<B><A class=\"darklink\" href=\"" + ServletURL + ".nonMember?task=news\"> Market News</A></B></td></td></tr><tr>");
	out.println("<TD vAlign=top width=\"100%\" class=\"lightbox\" bgcolor=\"FFFFFF\"> ");

	// We only want to get Headlines within 2 weeks of the current
	// date, set up the Date qualifier.

	String query = "select Title, Id, Date from News order by Date desc";
	ResultSet result = sessionbase.doQuery(query, SessionId);

	out.println("<table cellSpacing=0 cellpadding=1 width=\"100%\" border=0>");

	int reps = 0;
	try {
	    while (result.next() && reps < 6) {
		weekDateO = weekDate;
		reps++;
		weekTitle = result.getString("Title");
		weekId = result.getString("Id");
		weekDate = result.getDate("Date");

		if (!weekDate.equals(weekDateO)) {
		    // Just a formatting thing, don't want to push down the links
		    // if it is printing the top one.
		    if (reps > 1) {
			out.println("<br>");
		    }

		    out.println("<tr><td class=\"lightbox\" colspan=2><font color=\"#707070\">" + shortFormat.format(weekDate) + "</font></td></tr>");
		    out.println("<tr><td class=\"lightbox\">&deg;</td><td><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArticle&Id=" + weekId + "\">" + weekTitle + "</a></td></tr>");
		} else {
		    out.println("<tr><td class=\"lightbox\">&deg;</td><td><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArticle&Id=" + weekId + "\">" + weekTitle + "</a></td></tr>");
		}
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	out.println("<tr><td colspan=2 class=\"lightbox\"><br><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showHeadlines\"><img alt=More src=\"" + SystemURL + "/html/images/orange-arrow.gif\" border=0>All Headlines</a></td></tr>");
	out.println("</table>");
	out.println("</TD></TR></TBODY> </TABLE></TD></TR></TBODY> </TABLE></TD></TR></TBODY></TABLE></TD>");
	out.println("</td></tr></table></td>");
	out.println("</TR><tr>");

	out.println("<td colspan=\"2\"> ");
	out.println("<applet codebase=\"" + SystemURL + "/data/applet/\" code=\"jt.class\" name=\"Ticker\" width=600 height=35 hspace=0 vspace=0 align=middle>");
	out.println("</applet>");
	out.println("</td>");
	out.println("</tr>");
	out.println("</TBODY>");
	out.println("</TABLE>");
	out.println("<hr noshade size=1 width=\"610\" align=\"left\">");
	out.println("<table width=\"610\">");
	out.println("<tbody> ");
	out.println("<tr> ");
	out.println("<td class=\"lightbox\" valign=top align=left>");
	out.println("</td>");
	out.println("<td valign=\"_top\" align=center> ");
	out.println("<p class=\"lightbody\">");
	out.println("<a target=\"_top\" href=\"" + SystemURL + "/html/members/errors/construction.html\">Help</a> |");
	out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember\">Home</a> |&nbsp;");
	out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\">Quotes & Research</a> |");
	out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showHeadlines\"> News Headlines</a>");
	out.println("</td>");
	out.println("<td class=\"lightbox\" valign=top align=right> <a target=\"_top\" href=\"#top\">Page-Top</a></td>");
	out.println("</tr>");
	out.println("</tbody> ");
	out.println("</table>");
	out.println("</BODY>");
	out.println("</HTML>");
    }

    public void displayAll(HttpServletRequest request, HttpServletResponse response)
	throws IOException, ServletException {

	String query = (String)null;
	String Name = (String)null;
	int Tshares = 0;
	double Ipo = 0.00;
	double Open = 0.00;
	double Last = 0.00;
	int Volume = 0;
	double Change = 0.00;
	double WkHi = 0.00;
	double WkLo = 0.00;
	double DayHi = 0.00;
	double DayLo = 0.00;
	double Previous = 0.00;
	String fLast = (String)null;
	String fChange = (String)null;
	String fLow = (String)null;
	String fHigh = (String)null;
	String Symbol = (String)null;
	ResultSet result = null;
	double Capitalization = 0.00;
	boolean member = true;
	Vector dumpPlace = new Vector();
	int i = 0;

	String SessionId = "nonMember";

	// Set up decimal formatting for digits. This will force at least 0.00.
	DecimalFormat curFormat = new DecimalFormat("$##,###,###,###,###,##0.00");
	DecimalFormat numFormat = new DecimalFormat("################0.00");
	DecimalFormat intFormat = new DecimalFormat("################0");

	// Initialize output stream

	response.setContentType("text/html");
	PrintWriter out=response.getWriter();

	// Extract Company info from the database. A null ResultSet means the company
	// must not be in the database.
	query = "select * from Companies order by Symbol";
	result = sessionbase.doQuery(query);
	try {
	    while (result.next()) {
		Symbol = result.getString("Symbol");
		Last = result.getDouble("Last");
		DayHi = result.getDouble("DayHi");
		DayLo = result.getDouble("DayLo");
		Volume = result.getInt("Volume");
		dumpPlace.addElement(new Companies(Symbol, DayHi, DayLo, Last, Volume));
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	printTop(out, 5);
	out.println("<TD class=\"lightbody\" width=\"100%\">");
	out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	out.println("<tr><td valign=\"_top\">");
	out.println("<img src=\"" + SystemURL + "/html/images/quotes_head.gif\" alt=\"BSE Home\" width=\"178\" height=\"26\"><br>");
	out.println("<table cellspacing=0 cellpadding=1 bgcolor=#707070 align=\"left\" border=0>");
	out.println("<tbody>");
	out.println("<tr><td width=\"100%\">");
	out.println("<table cellspacing=0 width=100% cellpadding=3 bgcolor=#707070 border=0>");
	out.println("<tbody>");
	out.println("<tr bgcolor=\"#d0d0d0\"><td class=\"darkbox\" bgcolor=\"#d0d0d0\" valign=center align=left>Symbol</td><td class=\"darkbox\" bgcolor=\"#d0d0d0\" valign=center align=left>High</td><td class=\"darkbox\" bgcolor=\"#d0d0d0\" valign=center align=left>Low</td><td class=\"darkbox\" bgcolor=\"#d0d0d0\" valign=center align=left>Current</td><td class=\"darkbox\" bgcolor=\"#d0d0d0\" valign=center align=left>Volume</td>");

	Companies Company = new Companies();

	int vSize = dumpPlace.size();

	for (i = 0 ; i < vSize ; i++) {
	    Company = (Companies)dumpPlace.elementAt(i);
	    Symbol = Company.getSymbol();
	    DayHi = Company.getHigh();
	    DayLo = Company.getLow();
	    Last = Company.getCurrent();
	    Volume = Company.getVolume();

	    out.println("        <tr bgcolor=\"#d0d0d0\"> ");
	    out.println("        <td class=\"lightbox\" bgcolor=\"#d0d0d0\" valign=center align=left><a class=\"darklink\" href=\"" + ServletURL + ".nonMember?task=viewQuote&Symbol=" + Symbol + "\">" + Symbol + "</a></td>");
	    out.println("          <td class=\"lightbox\" bgcolor=\"#d0d0d0\" valign=center align=left><b>" + numFormat.format(DayHi) + "</b></td>");
	    out.println("          <td class=\"lightbox\" bgcolor=\"#d0d0d0\" valign=center align=left><b>" + numFormat.format(DayLo) + "</b></td>");
	    out.println("          <td class=\"lightbox\" bgcolor=\"#d0d0d0\" valign=center align=left><b>" + numFormat.format(Last) + "</b></td>");
	    out.println("          <td class=\"lightbox\" bgcolor=\"#d0d0d0\" valign=center align=left><b>" + Volume + "</b></td>");
	    out.println("        </tr>");
	}

	out.println("</table>");
	out.println("</tr></td></table>");
	out.println("</td>");
	out.println("<td class=\"lightbox\" valign=\"_top\">");
	printBot(out);
	out.close();

    }

    public void displayQuote(String Symbol, HttpServletRequest request, HttpServletResponse response)
	throws IOException, ServletException {

	String query = (String)null;
	String Name = (String)null;
	int Tshares = 0;
	double Ipo = 0.00;
	double Open = 0.00;
	double Last = 0.00;
	int Volume = 0;
	double Change = 0.00;
	double WkHi = 0.00;
	double WkLo = 0.00;
	double DayHi = 0.00;
	double DayLo = 0.00;
	double Previous = 0.00;
	String fLast = (String)null;
	String fChange = (String)null;
	String fLow = (String)null;
	String fHigh = (String)null;
	ResultSet result = null;
	double Capitalization = 0.00;
	boolean member = true;
	String Locked = (String)null;
	String SessionId = "nonMember";

	// Set up decimal formatting for digits. This will force at least 0.00.
	DecimalFormat curFormat = new DecimalFormat("$##,###,###,###,###,##0.00");
	DecimalFormat numFormat = new DecimalFormat("################0.00");
	DecimalFormat intFormat = new DecimalFormat("################0");

	// Initialize output stream

	response.setContentType("text/html");
	PrintWriter out=response.getWriter();

	// Extract Company info from the database. A null ResultSet means the company
	// must not be in the database.
	query = "select * from Companies where Symbol = '" + Symbol + "'";
	result = sessionbase.doQuery(query);

	try {
	    while(result.next()) {
		Name = result.getString("Name");
		Tshares = result.getInt("Tshares");
		Open = result.getDouble("Open");
		Last = result.getDouble("Last");
		Volume = result.getInt("Volume");
		WkHi = result.getDouble("52WkHi");
		WkLo = result.getDouble("52WkLo");
		DayHi = result.getDouble("DayHi");
		DayLo = result.getDouble("DayLo");
		Previous = result.getDouble("Previous");
		Locked = result.getString("Locked");
	    }
	} catch(Exception e) {
	    e.printStackTrace();
	}

	Change = Last - Previous;
	Capitalization = Tshares * Last;

	if (Name == null) {
	    response.sendRedirect(sessionbase.getURL() + "/html/errors/invalid_symbol.html");
	    out.close();
	} else {

	    printTop(out, 5);
	    out.println("<TD class=\"lightbody\" width=\"100%\">");
	    out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	    out.println("<tr><td valign=\"_top\">");
	    out.println("<img src=\"" + sessionbase.getURL() + "/html/members/images/quotes_head.gif\" alt=\"BSE Home\" width=\"178\" height=\"26\"><br>");
	    out.println("<table cellspacing=0 cellpadding=1 bgcolor=#707070 align=\"left\" border=0>");
	    out.println("<tbody>");
	    out.println("<tr><td width=\"100%\">");
	    out.println("<table cellspacing=0 width=100% cellpadding=3 bgcolor=#707070 border=0>");
	    out.println("<tbody>");

	    out.println("<tr bgcolor=\"#d0d0d0\"><td class=\"darkbox\" bgcolor=\"#d0d0d0\" valign=center align=left colspan=4>Today with <b>" + Name + " </b>(" + Symbol + ") </td></tr>");
	    out.println("        <tr bgcolor=\"#d0d0d0\"> ");
	    out.println("          <td class=\"lightbox\">Today's Open:</td>");
	    out.println("          <td class=\"lightbox\"><b>" + numFormat.format(Open) + "</b></td>");
	    out.println("          <td class=\"lightbox\"> Yesterday's Close:</td>");
	    out.println("          <td class=\"lightbox\"><b>" + numFormat.format(Previous) + "</b></td>");
	    out.println("        </tr>");
	    out.println("        <tr bgcolor=\"#d0d0d0\"> ");
	    out.println("          <td class=\"lightbox\">Current Price:</td>");
	    out.println("          <td class=\"lightbox\"><b>" + numFormat.format(Last) + "</b></td>");
	    out.println("          <td class=\"lightbox\">Change:</td>");
	    out.println("          <td class=\"lightbox\"><b>" + numFormat.format(Change) + "</b></td>");
	    out.println("        </tr>");
	    out.println("        <tr bgcolor=\"#d0d0d0\"> ");
	    out.println("          <td class=\"lightbox\">Today's Low:</td>");
	    out.println("          <td class=\"lightbox\"><b>" + numFormat.format(DayLo) + "</b></td>");
	    out.println("          <td class=\"lightbox\">Today's High:</td>");
	    out.println("          <td class=\"lightbox\"><b>" + numFormat.format(DayHi) + "</b></td>");
	    out.println("        </tr>");
	    out.println("        <tr bgcolor=\"#d0d0d0\"> ");
	    out.println("          <td class=\"lightbox\">52wk High:</td>");
	    out.println("          <td class=\"lightbox\"><b>" + numFormat.format(WkHi) + "</b></td>");
	    out.println("          <td class=\"lightbox\">52wk Low:</td>");
	    out.println("          <td class=\"lightbox\"><b>" + numFormat.format(WkLo) + "</b></td>");
	    out.println("        </tr>");
	    out.println("        <tr bgcolor=\"#d0d0d0\"> ");
	    out.println("          <td class=\"lightbox\">Volume:</td>");
	    out.println("          <td class=\"lightbox\" colspan=3><b>" + Volume + "</b></td>");
	    out.println("        </tr>");
	    out.println("<tr bgcolor=\"#d0d0d0\"><td class=\"lightbox\">Market Capitalization</td><td class=\"lightbox\" colspan=3><b>" + curFormat.format(Capitalization) + "</b></td></tr>");

	    if (Locked.equals("Y")) {
		out.println("        <tr bgcolor=\"#d0d0d0\"> <td class=\"lightbox\" colspan=4>");
		out.println("This company is currently in Locked status. ");
		out.println("Buying and Selling cannot take place for this company until ");
		out.println("it is unlocked.</td></tr>");
	    }
	    out.println("</table></td></tr></table>");

	    // Rude and crude to push the graph down - but it works.
	    out.println("<br><br><br><br><br><br><br><br><br><br><br><br>");
	    // Display the Company graph
	    sessionbase.displayGraph(out, "1", Symbol, 0);

	    out.println("</td>");

	    out.println("</td>");
	    out.println("<td class=\"lightbox\" align=\"right\" valign=\"_top\">");
	    printBot(out);
	    out.close();
	}
    }

    public void displayNews(HttpServletRequest request, HttpServletResponse response, String SessionId)
	throws IOException, ServletException {

	String query = (String)null;
	ResultSet result = null;

	// Initialize the output stream
	response.setContentType("text/html");
	PrintWriter out = response.getWriter();

	// Let's get the news
	printTop(out, 6);
	out.println("<TD class=\"lightbody\" width=\"100%\">");
	out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	out.println("<tr><td valign=\"_top\">");
	out.println("<img src=\"" + sessionbase.getURL() + "/html/members/images/news_head.gif\" alt=\"BSE Home\" width=\"178\" height=\"26\"><br>");

	// Get the Front Article
	String frontTitle = (String)null;
	String frontAuthor = (String)null;
	int frontId = 0;
	java.util.Date frontDate = new java.util.Date();
	java.util.Date frontTime = new java.util.Date();
	
	Locale locale = new Locale("en","US");
	
	// Set the format for time and date
	DateFormat dateFormat = DateFormat.getDateInstance(DateFormat.LONG, locale);
	DateFormat shortFormat = DateFormat.getDateInstance(DateFormat.SHORT, locale);
	DateFormat timeFormat = DateFormat.getTimeInstance(DateFormat.SHORT, locale);

	String frontStory = (String)null;

	query = "select Title, Author, Date, Story, Id from News where Type = 3";
	result = sessionbase.doQuery(query, SessionId);

	try {
	    while (result.next()) {
		frontTitle = result.getString("Title");
		frontAuthor = result.getString("Author");
		frontDate = result.getDate("Date");
		frontTime = result.getTime("Date");
		frontStory = result.getString("Story");
		frontId = result.getInt("Id");
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	// Get Author's Full Name
	query = "select Fname, Lname from Account where Username = '" + frontAuthor + "'";
	result = sessionbase.doQuery(query, SessionId);

	String frontFullAuthor = "";

	try {
	    while (result.next()) {
		frontFullAuthor += result.getString("Fname");
		frontFullAuthor += " ";
		frontFullAuthor += result.getString("Lname");
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	out.println("<font class=\"darklink\">");
	out.println("Article Submitted: <b>" + dateFormat.format(frontDate) + "</b> at <b>" + timeFormat.format(frontTime) + "</b><br></font>");
	out.println("<b>" + frontTitle + "</b><br>");
	out.println(frontStory + "<br>");
	out.println("<p><font class=\"darklink\">");
	out.println("Article submitted by: <b>" + frontFullAuthor + "</b><br></p>");

	// Get Breaking News Links

	query = "select Title, Date, Id from News where Type = 2";
	result = sessionbase.doQuery(query, SessionId);

	String breakingTitle = (String)null;
	java.util.Date breakingDate = new java.util.Date();
	java.util.Date breakingTime = new java.util.Date();
	
	String breakingId = (String)null;

	// Make sure there are any Breaking News articles
	int bId = 0;
	query = "select Id from News where Type = 2";
	result = sessionbase.doQuery(query, SessionId);

	try {
	    while (result.next()) {
		bId = result.getInt("Id");
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	if (bId > 0) {

	    out.println("<br>");
	    out.println("<b>Breaking News</b><br>");
	    
	    try {
		while (result.next()) {
		    breakingTitle = result.getString("Title");
		    breakingDate = result.getDate("Date");
		    breakingId = result.getString("Id");
		    
		    out.println("<font class=\"darklink\">" + dateFormat.format(breakingDate) + "</font>  <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArticle&Id=" + breakingId + "\">" + breakingTitle + "</a><br>");
		}
	    } catch (Exception e) {
		e.printStackTrace();
	    }
	}

	out.println("<br><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showHeadlines\"><img alt=More src=\"" + SystemURL + "/html/images/orange-arrow.gif\" border=0>View all headlines...</a></p>");

	out.println("</td>");

	out.println("</td>");
	out.println("<td valign=\"_top\" align=\"left\">");
	printBot(out);
	out.close();
    }

    public void displayHeadlines(HttpServletRequest request, HttpServletResponse response, String SessionId)
	throws IOException, ServletException {

	String query = (String)null;
	ResultSet result = null;

	// Initialize the output stream
	response.setContentType("text/html");
	PrintWriter out = response.getWriter();

	// Let's get the news
	
	printTop(out, 6);
	out.println("<TD class=\"lightbody\" width=\"100%\">");
	out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	out.println("<tr><td valign=\"_top\">");
	out.println("<img src=\"" + SystemURL + "/html/members/images/news_head.gif\" alt=\"Admin\" width=\"178\" height=\"26\"></p>");

	java.util.Date frontDate = new java.util.Date();
	java.util.Date frontTime = new java.util.Date();
	
	Locale locale = new Locale("en","US");
	
	// Set the format for time and date
	DateFormat dateFormat = DateFormat.getDateInstance(DateFormat.LONG, locale);
	DateFormat shortFormat = DateFormat.getDateInstance(DateFormat.SHORT, locale);
	DateFormat timeFormat = DateFormat.getTimeInstance(DateFormat.SHORT, locale);

	java.util.Date curDate = new java.util.Date();
	int Day = curDate.getDate();
	int Month = (curDate.getMonth()) + 1;
	int Year = (curDate.getYear()) + 1900;

	Day = Day - 14;

	if (Day < 1) {
	    Month = Month - 1;
	    if (Month == 1) {
		Day = 31 + Day;
	    } else if (Month == 2) {
		Day = 28 + Day;
	    } else if (Month == 3) {
		Day = 31 + Day;
	    } else if (Month == 4) {
		Day = 30 + Day;
	    } else if (Month == 5) {
		Day = 31 + Day;
	    } else if (Month == 6) {
		Day = 30 + Day;
	    } else if (Month == 7) {
		Day = 31 + Day;
	    } else if (Month == 8) {
		Day = 31 + Day;
	    } else if (Month == 9) {
		Day = 30 + Day;
	    } else if (Month == 10) {
		Day = 31 + Day;
	    } else if (Month == 11) {
		Day = 30 + Day;
	    } else if (Month == 12) {
		Day = 31 + Day;
	    }

	    if (Month < 1) {
		Month = 12;
		Year = Year - 1;
	    }
	}

	// Get all Headlines

	String headTitle = (String)null;
	String headId = (String)null;
	java.util.Date headDate = new java.util.Date();
	java.util.Date headDateO = new java.util.Date();

	query = "select Title, Date, Id from News where Date >= " + Year + "-" + Month + "-" + Day + " order by Date desc";
	result = sessionbase.doQuery(query, SessionId);
	int i = 0;

	out.println("These articles have been submitted within the last two weeks.<br>");
	out.println("To view older articles, visit the <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArchives\">archives</a>.");
	out.println("<br><h3>News Articles</h3>");
	try {
	    while (result.next()) {
		i++;
		headDateO = headDate;
		headTitle = result.getString("Title");
		headDate = result.getDate("Date");
		headId = result.getString("Id");

		if (!headDate.equals(headDateO)) {
		    if (i > 1) {
			out.println("<br>");
		    }
		    out.println("<font color=\"#707070\">" + shortFormat.format(headDate) + "</font><br>");
		    out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArticle&Id=" + headId + "\">" + headTitle + "</a><br>");
		} else {
		    out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArticle&Id=" + headId + "\">" + headTitle + "</a><br>");
		}
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	if (i == 0) {
	    out.println("No New Articles<br>");
	}

	out.println("<br><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArchives\"><img alt=More src=\"" + SystemURL + "/html/images/orange-arrow.gif\" border=0>View old news...</a></p>");

	out.println("</td>");
	out.println("<td valign=\"_top\" align=\"left\">");
	printBot(out);
	out.close();
    }

    public void displayArchives(HttpServletRequest request, HttpServletResponse response, String SessionId)
	throws IOException, ServletException {

	String query = (String)null;
	ResultSet result = null;

	// Initialize the output stream
	response.setContentType("text/html");
	PrintWriter out = response.getWriter();

	// Let's get the news
	
	printTop(out, 6);
	out.println("<TD class=\"lightbody\" width=\"100%\">");
	out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	out.println("<tr><td valign=\"_top\">");
	out.println("<img src=\"" + SystemURL + "/html/members/images/news_head.gif\" alt=\"Admin\" width=\"178\" height=\"26\"></p>");

	java.util.Date frontDate = new java.util.Date();
	java.util.Date frontTime = new java.util.Date();
	
	Locale locale = new Locale("en","US");
	
	// Set the format for time and date
	DateFormat dateFormat = DateFormat.getDateInstance(DateFormat.LONG, locale);
	DateFormat shortFormat = DateFormat.getDateInstance(DateFormat.SHORT, locale);
	DateFormat timeFormat = DateFormat.getTimeInstance(DateFormat.SHORT, locale);

	java.util.Date curDate = new java.util.Date();
	int Day = curDate.getDate();
	int Month = (curDate.getMonth()) + 1;
	int Year = (curDate.getYear()) + 1900;

	Day = Day - 14;

	if (Day < 1) {
	    Month = Month - 1;
	    if (Month == 1) {
		Day = 31 + Day;
	    } else if (Month == 2) {
		Day = 28 + Day;
	    } else if (Month == 3) {
		Day = 31 + Day;
	    } else if (Month == 4) {
		Day = 30 + Day;
	    } else if (Month == 5) {
		Day = 31 + Day;
	    } else if (Month == 6) {
		Day = 30 + Day;
	    } else if (Month == 7) {
		Day = 31 + Day;
	    } else if (Month == 8) {
		Day = 31 + Day;
	    } else if (Month == 9) {
		Day = 30 + Day;
	    } else if (Month == 10) {
		Day = 31 + Day;
	    } else if (Month == 11) {
		Day = 30 + Day;
	    } else if (Month == 12) {
		Day = 31 + Day;
	    }

	    if (Month < 1) {
		Month = 12;
		Year = Year - 1;
	    }
	}

	// Get all Headlines

	String headTitle = (String)null;
	String headId = (String)null;
	java.util.Date headDate = new java.util.Date();
	java.util.Date headDateO = new java.util.Date();

	query = "select Title, Date, Id from News where Date < " + Year + "-" + Month + "-" + Day + " order by Date desc";
	result = sessionbase.doQuery(query, SessionId);
	int i = 0;

	out.println("These articles are all over two weeks old. To view newer ");
	out.println("articles, visit the <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showHeadlines\">headlines</a>.");
	out.println("<br><h3>News Articles</h3>");
	try {
	    while (result.next()) {
		i++;
		headDateO = headDate;
		headTitle = result.getString("Title");
		headDate = result.getDate("Date");
		headId = result.getString("Id");

		if (!headDate.equals(headDateO)) {
		    if (i > 1) {
			out.println("<br>");
		    }
		    out.println("<font color=\"#707070\">" + shortFormat.format(headDate) + "</font><br>");
		    out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArticle&Id=" + headId + "\">" + headTitle + "</a><br>");
		} else {
		    out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArticle&Id=" + headId + "\">" + headTitle + "</a><br>");
		}
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	if (i == 0) {
	    out.println("No Old Articles<br>");
	}

	out.println("<br><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showHeadlines\"><img alt=More src=\"" + SystemURL + "/html/images/orange-arrow.gif\" border=0>View all headlines...</a></p>");

	out.println("</td>");
	out.println("<td valign=\"_top\" align=\"left\">");
	printBot(out);
	out.close();
    }

    public void displayArticle(HttpServletRequest request, HttpServletResponse response, String SessionId)
	throws IOException, ServletException {
	String Id = request.getParameter("Id");
	String query = (String)null;
	ResultSet result = null;

	// Initialize the output stream
	response.setContentType("text/html");
	PrintWriter out = response.getWriter();

	// Get the Article
	String Title = (String)null;
	String Author = (String)null;
	java.util.Date Date = new java.util.Date();
	java.util.Date Time = new java.util.Date();
	
	Locale locale = new Locale("en","US");
	
	// Set the format for time and date
	DateFormat dateFormat = DateFormat.getDateInstance(DateFormat.LONG, locale);
	DateFormat shortFormat = DateFormat.getDateInstance(DateFormat.SHORT, locale);
	DateFormat timeFormat = DateFormat.getTimeInstance(DateFormat.SHORT, locale);

	String Story = (String)null;

	query = "select Title, Author, Date, Story from News where Id = " + Id;
	result = sessionbase.doQuery(query, SessionId);

	try {
	    while (result.next()) {
		Title = result.getString("Title");
		Author = result.getString("Author");
		Date = result.getDate("Date");
		Time = result.getTime("Date");
		Story = result.getString("Story");
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	// Get Author's Full Name
	query = "select Fname, Lname from Account where Username = '" + Author + "'";
	result = sessionbase.doQuery(query, SessionId);

	String FullAuthor = "";

	try {
	    while (result.next()) {
		FullAuthor += result.getString("Fname");
		FullAuthor += " ";
		FullAuthor += result.getString("Lname");
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	printTop(out, 6);
	out.println("<TD class=\"lightbody\" width=\"100%\">");
	out.println("<table cellspacing=0 cellpadding=1 align=\"left\" border=0 width=\"475\">");
	out.println("<tr><td valign=\"_top\">");
	out.println("<img src=\"" + sessionbase.getURL() + "/html/members/images/news_head.gif\" alt=\"BSE Home\" width=\"178\" height=\"26\"><br>");
	out.println("<p><font class=\"darklink\">");
	out.println("Article Submitted: <b>" + dateFormat.format(Date) + "</b> at <b>" + timeFormat.format(Time) + "</b></p>");
	out.println("<b>" + Title + "</b><br>");
	out.println(Story + "<br>");
	out.println("<p><font class=\"darklink\"><b>");
	out.println("Article submitted by: " + FullAuthor + "</b><br>");
	out.println("</p>");

	// Get Breaking News Links

	// Make sure there are Breaking News articles
	int bId = 0;
	query = "select COUNT(Id) from News where Type = 2";
	result = sessionbase.doQuery(query, SessionId);

	try {
	    while (result.next()) {
		bId = result.getInt("COUNT(Id)");
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	if (bId > 0) {
	    query = "select Title, Date, Id from News where Type = 2";
	    result = sessionbase.doQuery(query, SessionId);
	    
	    String breakingTitle = (String)null;
	    java.util.Date breakingDate = new java.util.Date();
	    java.util.Date breakingTime = new java.util.Date();
	    
	    String breakingId = (String)null;
	    
	    out.println("<p>");
	    out.println("<b>Breaking News</b><br>");
	    
	    try {
		while (result.next()) {
		    breakingTitle = result.getString("Title");
		    breakingDate = result.getDate("Date");
		    breakingId = result.getString("Id");
		    
		    out.println("<font class=\"darklink\">" + dateFormat.format(breakingDate) + "</font>  <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showArticle&Id=" + breakingId + "\">" + breakingTitle + "</a><br>");
		}
	    } catch (Exception e) {
		e.printStackTrace();
	    }
	}

	out.println("<br><a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=showHeadlines\"><img alt=More src=\"" + SystemURL + "/html/images/orange-arrow.gif\" border=0>View all headlines...</a></p>");

	out.println("</td>");
	out.println("<td valign=\"_top\" align=\"left\">");
	printBot(out);
	out.close();
    }

    public void QuoteFlash(PrintWriter out)
	throws IOException, ServletException {
	String query = (String)null;
	ResultSet result = null;

	// Storage variables to hold the 5 values for display
	String Sym = (String)null;
	String Sym1 = (String)null;
	String Sym2 = (String)null;
	String Sym3 = (String)null;
	String Sym4 = (String)null;
	String Sym5 = (String)null;

	double Val = 0.00;
	double Val1 = 0.00;
	double Val2 = 0.00;
	double Val3 = 0.00;
	double Val4 = 0.00;
	double Val5 = 0.00;

	// Number format to force at least 0.00
	DecimalFormat numFormat = new DecimalFormat("################0.00");

	// Read in the Symbols and Last values
	query = "select Symbol, Last from Companies";
	result = sessionbase.doQuery(query);

	try {
	    while (result.next()) {
		Sym = result.getString("Symbol");
		Val = result.getDouble("Last");
		// Compare values and swap out the greater ones to
		// get the top 5. If a greater value is found, all
		// lesser values have to be moved down one.
		if (Val > Val1) {
		    Val5 = Val4;
		    Sym5 = Sym4;
		    Val4 = Val3;
		    Sym4 = Sym3;
		    Val3 = Val2;
		    Sym3 = Sym2;
		    Val2 = Val1;
		    Sym2 = Sym1;
		    Val1 = Val;
		    Sym1 = Sym;
		} else if (Val > Val2) {
		    Val5 = Val4;
		    Sym5 = Sym4;
		    Val4 = Val3;
		    Sym4 = Sym3;
		    Val3 = Val2;
		    Sym3 = Sym2;
		    Val2 = Val;
		    Sym2 = Sym;
		} else if (Val > Val3) {
		    Val5 = Val4;
		    Sym5 = Sym4;
		    Val4 = Val3;
		    Sym4 = Sym3;
		    Val3 = Val;
		    Sym3 = Sym;
		} else if (Val > Val4) {
		    Val5 = Val4;
		    Sym5 = Sym4;
		    Val4 = Val;
		    Sym4 = Sym;
		} else if (Val > Val5) {
		    Val5 = Val;
		    Sym5 = Sym;
		}
	    }
	} catch (Exception e) {
	    e.printStackTrace();
	}

	if (Sym1 != null) {
	    // Output Quote Flash table
	    out.println("<table cellspacing=0 width=110 height=100% cellpadding=1 bgcolor=#707070 border=0>");
	    out.println("<tbody><tr><td width=\"100%\">");
	    out.println("<table cellspacing=0 width=100% cellpadding=3 bgcolor=#707070 border=0>");
	    out.println("<tbody><tr bgcolor=\"#d0d0d0\">");
	    out.println("<td class=\"lightbox\" bgcolor=\"#d0d0d0\" valign=center align=left colspan=\"2\">");
	    out.println("<b>Quote Flash</b><br>top stocks</td></tr>");
	    out.println("<tr><td valign=top width=\"100%\" class=\"lightbox\" bgcolor=\"FFFFFF\"><p>");
	    if (Sym1 != null) {
		out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=viewQuote&Symbol=" + Sym1 + "\">" + Sym1.toUpperCase() + "</a><br>");
	    }
	    if (Sym2 != null) {
		out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=viewQuote&Symbol=" + Sym2 + "\">" + Sym2.toUpperCase() + "</a><br>");
	    }
	    if (Sym3 != null) {
		out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=viewQuote&Symbol=" + Sym3 + "\">" + Sym3.toUpperCase() + "</a><br>");
	    }
	    if (Sym4 != null) {
		out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=viewQuote&Symbol=" + Sym4 + "\">" + Sym4.toUpperCase() + "</a><br>");
	    }
	    if (Sym5 != null) {
		out.println("&deg; <a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=viewQuote&Symbol=" + Sym5 + "\">" + Sym5.toUpperCase() + "</a></p>");
	    }
	    
	    out.println("</td><td valign=top width=\"100%\" class=\"lightbox\" bgcolor=\"FFFFFF\"><p>");
	    
	    if (Sym1 != null) {
		out.println(numFormat.format(Val1) + "<br>");
	    }
	    
	    if (Sym2 != null) {
		out.println(numFormat.format(Val2) + "<br>");
	    }
	    
	    if (Sym3 != null) {
		out.println(numFormat.format(Val3) + "<br>");
	    }
	    
	    if (Sym4 != null) {
		out.println(numFormat.format(Val4) + "<br>");
	    }
	    
	    if (Sym5 != null) {
		out.println(numFormat.format(Val5) + "</p></td></tr>");
	    }
	    
	    out.println("<tr><td valign=top width=\"200%\" class=\"lightbox\" bgcolor=\"FFFFFF\" colspan=\"2\">");
	    out.println("<a target=\"_top\" href=\"" + ServletURL + ".nonMember?task=Quotes\">");
	    out.println("<img alt=More src=\"" + SystemURL + "/html/images/orange-arrow.gif\" border=0 width=\"10\" height=\"9\">All Quotes</a>");
	    out.println("</td></tr></tbody></table></td></tr></tbody></table>");
	}
    }

    static public void reload() {
	SystemURL = sessionbase.getURL();
	ServletURL = sessionbase.getServletURL();
	SystemEmail = sessionbase.getEmail();
	SystemPath = sessionbase.getPath();
	SystemName = sessionbase.getName();
	SystemShortName = sessionbase.getShortName();
    }
}