goodsinquire.java

整个系统采用MVC开发模式

package Manager;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import bean.Goods;
import bean.GoodsDao;

public class GoodsInquire extends HttpServlet {

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

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


	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html; charset=GBK");
		response.setHeader("Cache-Control", "no-cache");
		PrintWriter out = response.getWriter();
		String goodsname=request.getParameter("goodsname");
		String name=request.getParameter("key");
		System.out.print(name);
		
		String category=request.getParameter("category");
		ArrayList<Goods> result=new ArrayList<Goods>();
		Goods book=new Goods();
		GoodsDao goodsdao=new GoodsDao();
		HttpSession session=request.getSession();

		if(goodsname.equals("all")){
			String sql="select * from goods";
			try {
				result=goodsdao.goodsSelect(sql);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			session.setAttribute("result", result);
			response.sendRedirect("GoodsManage/GoodsSurvey.jsp");
			}
		else{
			if(category.equals("bookname")){
		String sql="select * from goods where bookname like '%"+name+"%'";
		try {
			result=goodsdao.goodsSelect(sql);
			book=result.get(0);
			System.out.println(book.getBookname());
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
			}
			else if(category.equals("author")){
				String sql="select * from goods where author like'%"+name+"%'";
				try {
					result=goodsdao.goodsSelect(sql);

				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}				
			}
			else if(category.equals("category")){
				String sql="select * from goods where sort like'%"+name+"%'";
				try {
					result=goodsdao.goodsSelect(sql);
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
		
		if(result.size()==0){
			out.print("没有搜到符合你条件的记录");
			out.print("<a href='GoodsManage/GoodsInquire.jsp'>"+"返回"+"</a>");
		}
		else{
			session.setAttribute("result", result);
			response.sendRedirect("/gouwuche3/GoodsManage/InquireResult.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 {

		doGet(request,response);
	}

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

}