package com.vsked.servlet;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class searchNews extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public searchNews() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		if(request.getParameterValues("cb")!=null){
		String s[]=request.getParameterValues("cb");
		String sqls="select * from newst ";			
			for(int i=0;i<s.length;i++){
				System.out.println(s[i]);
				if(s[i].equals("0")){
					if(request.getParameter("name")!=null){
						sqls=sqls+" where newsname like'%"+request.getParameter("name")+"%'";	
					}else{
						sqls=sqls+" where newsname like'%%'";
					}
					if(s[i+1].equals("1")){
						if(request.getParameter("authors")!=null){
							sqls=sqls+" and authors like'%"+request.getParameter("authors")+"%'";
						}else{
							sqls=sqls+" and autors like'%'";
						}
						
					}
					if(s[i+2].equals("2")){
						if(request.getParameter("newsbody")!=null){
							sqls=sqls+" and newsbody like'%"+request.getParameter("newsbody")+"%'";
						}else{
							sqls=sqls+" and newsbody like'%'";
						}
					}
					if(s[i+3].equals("3")){
						if(request.getParameter("newsdate")!=null){
							sqls=sqls+" and newsdate like'%"+request.getParameter("newsdate")+"%'";
						}else{
							sqls=sqls+" and newsdate like'%%'";
						}
						
					}
					if(s[i].equals("4")){
						if(request.getParameter("typename")!=null){
							sqls=sqls+" and typeid="+request.getParameter("typename");										
						}
					}
					
				}
			System.out.println("語句是:"+sqls);
		  }
		}else{			
			response.sendRedirect("newsList.jsp");
		}	
		
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		this.doGet(request, response);
		
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}