adminhistoryshow.java

招标网站

package com.jblack.servlet;

import java.util.List;

import com.jblack.dao.ApplyDAO;
import com.jblack.dao.TpublishDAO;
import com.jblack.model.Tapply;
import com.jblack.model.Tpublish;
import com.jblack.tool.BaseServlet;

public class AdminHistoryShow extends BaseServlet {

	private static final long serialVersionUID = 1L;
	private TpublishDAO tpublishDAO = new TpublishDAO();

	@Override
	protected void doBusiness() {
		String method = request.getParameter("method");
		if (method.equals("against")) { 
			String sql = "select * from Tpublish where " +
					"TP_status = "+ Tpublish.AGAINST;
			List<Tpublish> tpublishs = tpublishDAO.queryPublish(sql);
			request.setAttribute("tpublishs", tpublishs);
			forward("/admin/history/history.jsp");
			
		} else if (method.equals("done")) {
			String sql = "select * from Tpublish where " +
			"TP_winner > 0";
			List<Tpublish> tpublishs = tpublishDAO.queryPublish(sql);
			request.setAttribute("tpublishs", tpublishs);
			forward("/admin/history/history.jsp");
			
		} else if (method.equals("historybid")) {
			String sql = "select * from Tapply ";
			List<Tapply> tapplys = new ApplyDAO().aquery(sql);
			request.setAttribute("tapplys", tapplys);
			forward("/admin/history/th_apply.jsp");
			
		} else if (method.equals("historypublish")) {
			List<Tpublish> tpublishs = new TpublishDAO().queryAll();
			request.setAttribute("tpublishs", tpublishs);
			forward("/admin/history/history.jsp");
		}
		
	}

}