/***********************************************************************

	File:		Search.java
	Author:		Jake Olefsky 
	Credits:
				This code is based on code from Craig Jurney, ITSS
				and on the JDBC handout from class and from sample code
				from the java.sun.com web page.  It also has some elements 
				taken from the StateQuerier source code provided to class
	Description:
				This is a servlet that performs keyword searches on a
				variety of fields.

************************************************************************/

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

public class Search extends HttpServlet 
{
	public void doPost(HttpServletRequest request, HttpServletResponse response)
 	throws IOException, ServletException
    {
		String title = "";
		String hint = "";
		String answer = "";
        int id = 0;
		double diffrating = 0;
		double funrating = 0;
		String category = ""; 
		int i=0;
		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
        
		String op = request.getParameter("op");
		String value = request.getParameter("value");
		String user = request.getParameter("user");
		
    	HTMLCommon.printTop(out, "Search Results");
		HTMLCommon.printDate(out);
		HTMLCommon.printUser(out, user);
		HTMLCommon.printLocation(out, user);
		HTMLCommon.printSidebar(out, user);
		
		out.println("<H1><FONT COLOR='#000099'>Search Results</FONT></H1>");
		try { //Do Query
    		Connection con = SQLUtil.getConnection();
            	
 			Statement stmt = con.createStatement();
       		ResultSet rs = stmt.executeQuery("SELECT * FROM teaser WHERE "+op+" LIKE '%"+value+"%' ORDER BY title");
			
			out.println("<TABLE BORDER=0 CELLPADDING=5 WIDTH=80%>");
			
			if(op.equals("title")) {
				out.println("<TR><TD><B>Title</B></TD><TD><B>Category</B></TD><TD></TD></TR>");
			} else if(op.equals("hint")){
				out.println("<TR><TD><B>Title</B></TD><TD><B>Category</B></TD><TD><B>Hint</B></TD></TR>");
			} else if(op.equals("answer")){
				out.println("<TR><TD><B>Title</B></TD><TD><B>Category</B></TD><TD><B>Answer</B></TD></TR>");
			}
			
         	while(rs.next()) {
         		i++;
          		title = rs.getString("title");
          		category = rs.getString("category");
          		hint = rs.getString("hint");
          		answer = rs.getString("answer");
          		id = rs.getInt("id");
          		if(user!=null) {
         			out.println("<TR><TD VALIGN=top><a href='/servlet/Teaser?id="+id+"&user="+user+"'>"+title+"</A></TD>");
         		} else {
         			out.println("<TR><TD VALIGN=top><a href='/servlet/Teaser?id="+id+"'>"+title+"</A></TD>");
         		}
         		out.println("<TD VALIGN=top>"+category+"</TD>");
				if(op.equals("title")) {
					out.println("<TD VALIGN=top></TD></TR>");
				} else if(op.equals("hint")){
					out.println("<TD VALIGN=top><FONT SIZE=-1>"+hint+"</FONT></TD></TR>");
				} else if(op.equals("answer")){
					out.println("<TD VALIGN=top><FONT SIZE=-1>"+answer+"</FONT></TD></TR>");
				}
     		}
  			stmt.close();
  			con.close();
     		out.println("</TABLE>");
            
            if(i==0) out.println("<BR><BR>Nothing matched your search.");
		} catch (SQLException e) { HTMLCommon.printError(out);}
            
		HTMLCommon.printTag(out);
		HTMLCommon.printBottom(out);
    }
    
}