src/servlet/OrderShowServlet.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package servlet;

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

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

import util.Validate;
import bean.InsertUpdateDelBean;
import bean.SelectBean;

public class OrderShowServlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public OrderShowServlet() {
		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 {
		Validate vd = new Validate();
		String show = vd.getUnicode(request.getParameter("show"));
		String state = vd.getUnicode(request.getParameter("state"));
		String str = "";
		
		InsertUpdateDelBean ib = new InsertUpdateDelBean();
		SelectBean sb = new SelectBean();
		
		if(show != null && !show.equals("")){
			str = "/order_show.jsp";
			String sql = "select a.*,phone,addr,contact from orders a,supplier b where a.supplierid=b.id and a.id="+show;
			String[] args = {"id","aggregate","supplierid","suppliername","times","state","phone","addr","contact"};
			ArrayList al = sb.select(sql, args);
			request.setAttribute("orders", al);
			
			String sql1 = "select * from orderlist where orderid="+show;
			String[] args1 = {"id","orderid","bookid","bookname","price","sums","aggregate"};
			ArrayList al1 = sb.select(sql1, args1);
			request.setAttribute("orderlists", al1);
		}
		
		if(state != null && !state.equals("")){
			str = "/order_select.jsp";
			String sql = "update orders set state='已结束' where id="+state;
			ib.insertANDupdateANDdel(sql);
		}