import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.net.*;

/**
 * Looks up an author in the database and produces information
 * about him/her from the database.
 */

public class DescribeAuthor extends LitsearchBase {

    public String drawPage(HttpServletRequest request,
			   HttpServletResponse response) throws Exception {
	String author = request.getParameter("name");

	//If no author is specified, show the form.
	if (author == null || author.equals("")) {
	    Template t = new Template(TEMPLATE_DIR + "authorsearch.html");
	    return t.toString();
	}

	//get a connection from the database
	ConnectionWrapper wrapper = null;
	try {
	    wrapper = DatabaseHook.getConnection();
	    Connection c = wrapper.connection();
	    Statement stmt = c.createStatement();
	    String text = "";

	    //see how many authors the query matches
	    String query = "SELECT COUNT(*) FROM Author WHERE name LIKE " +
		formatString(author + "%");
	    ResultSet rs = stmt.executeQuery(query);
	    rs.next();
	    int count = rs.getInt(1);
	    if (count == 0) {
		//if there are none, show failure.
		text += "Sorry. The author " + author + " was not found.";

	    } else if (count > 1) {
		//if many, show a list to choose from.
		text = "<font size=4>Authors whose last names begin with '" + author + "':<br>";
		query = "SELECT name " +
		        "FROM Author " +
		        "WHERE name LIKE " + formatString(author + "%") + " " +
		        "ORDER BY name";
		rs = stmt.executeQuery(query);
		while (rs.next()) {
		    text += "<br><a href='DescribeAuthor?name=" + URLEncoder.encode(rs.getString(1)) +
			"'>" + rs.getString(1) + "</a>";
		}

	    } else {
		//if excatly one, show his record in tabular format.
		text += "<table width=100% cellpadding=5 cellspacing=0><tr>" +
		    "<td valign='top' width='440'>\n";
		
		query = "SELECT * FROM Author WHERE name LIKE " + formatString(author + "%");
		rs = stmt.executeQuery(query);
		if (rs.next()) {
		    author = rs.getString("name");
		    text += "<font size='5'>" + author + " (" +
			rs.getInt("birth") + "-" + rs.getInt("death") + ")</font><br>\n";
		    String desc = rs.getString("description");
		    if (desc != null) text += desc + "<br><br>\n";
		}
		
		text += "<table cellpadding='4' cellspacing='2' width='100%'>";
		
		query = "SELECT c.title, c.critic, c.synopsis, c.url, c.publication " +
		    "FROM Criticism c, AuthorCriticized a " +
		    "WHERE a.url = c.url AND a.name=" + formatString(author);
		rs = stmt.executeQuery(query);
		
		//look up critical analysis about this author and display in tabular format.
		boolean firstPass = true;
		while (rs.next()) {
		    if (firstPass) {
			text += "<tr><td>&nbsp;<br><font size=4>Critical analysis of " + 
			    author + "</font></td></tr>\n";
			firstPass = false;
		    }
		    String title = rs.getString("title");
		    String critic = rs.getString("critic");
		    String synopsis = rs.getString("synopsis");
		    String url = rs.getString("url");
		    String publication = rs.getString("publication");
		    text += "<tr><td bgcolor=#d0d0d0><a href='" + url + "'><b>" + title + 
			"</b></a></td></tr>\n";
		    if (!critic.equals(""))
			text += "<tr><td bgcolor=#d0d0d0><b>Author:</b> " + critic + "</td></tr>\n";
		    text += "<tr><td bgcolor=#d0d0d0><b>Source:</b> " + publication + "</td></tr>\n";
		    text += "<tr><td bgcolor=#e8e8e8>" + synopsis + "<br>&nbsp;</td></tr>\n";
		    text += "<tr><td bgcolor=#ffffff><img src='spacer.gif' height=1 width=1></td></tr>\n";
		}
		text += "</table></td>\n<td valign='top' width='200'>";
		text += "<table align='right' cellpadding=10 cellspacing=0 bgcolor='#e0e0c0'>";
		text += "<tr><td><b>Works by this author:</b></td></tr><tr><td valign='top'>";


		//query works that this author has written and display their titles
		query = "SELECT w.id, w.title " +
		    "FROM WrittenBy, Work w " +
		    "WHERE WrittenBy.name=" + formatString(author) + 
		    " AND w.id = WrittenBy.work ORDER BY w.title";
		rs = stmt.executeQuery(query);
		while (rs.next()) {
		    text += "<a href='DescribeWork?work=" + rs.getInt("id") + "'>" +
			rs.getString("title") + "</a><br>\n";
		}
		text += "</td></tr></table>\n</td></table>";
	    }

	    wrapper.checkIn();
	    return text;

	} catch (SQLException e) {
	    wrapper.checkIn();
	    throw e;
	}
    }
}