queryordersrecords.java

很好的东东 本人随便做的 仅供学习之用

package xiaoshou.servlets;

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

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

import xiaoshou.classes.CUser;
import xiaoshou.javabeans.Operator;

public class QueryOrdersRecords extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public QueryOrdersRecords() {
		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 {

		doPost(request,response);
	}

	/**
	 * 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 {
		System.out.println("***begin***:" );
		request.setCharacterEncoding("gb2312");
		String col=request.getParameter("select");
		String key=request.getParameter("keyWord").trim().toLowerCase();
		System.out.println("**********:" + col + "*****:" + key);
		String sql=null;
		CUser user=(CUser)request.getSession().getAttribute("user");
		System.out.println("**********user:" + user.getName());
		if("".equals(key)||key==null||"null".equals(key)){
			sql="select * from [order] where ";
			key="null";
		}else{
			if("a".equals(col))//时间
				sql="select * from [order] where convert(varchar(10),ordertime,20) like ? and ";
			if("b".equals(col))//客户
				sql="select * from [order] where customername like ? and ";
			if("c".equals(col))//负责人
				sql="select * from [order] where principal like ? and ";
			if("d".equals(col))//状态
				sql="select * from [order] where status like ? and ";
			if("e".equals(col))//类型
				sql="select * from [order] where type like ? and ";
			
			key="%" + key + "%";
		}
		sql+="sell='" + user.getSell() + "'";
		
		ArrayList list=Operator.queryOrders(sql, key);
		if(list.size()>0)
			request.setAttribute("list", list);
		else
			request.setAttribute("noOrderRecord", "无记录");
		
		request.getRequestDispatcher("/xiaoshou/sellRecords.jsp").forward(request, response);
	}

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

}