showbid.java

招标网站

package com.jblack.servlet;

import java.util.List;

import com.jblack.dao.ApplyDAO;
import com.jblack.dao.TcompanyDAO;
import com.jblack.dao.TjoinDAO;
import com.jblack.model.Tapply;
import com.jblack.model.Tcompany;
import com.jblack.model.Tjoin;
import com.jblack.tool.BaseServlet;

public class ShowBid extends BaseServlet {

	private static final long serialVersionUID = 1L;
	private TcompanyDAO tcompanyDAO = new TcompanyDAO();
	private ApplyDAO applyDAO = new ApplyDAO();
	private TjoinDAO tjoinDAO = new TjoinDAO();

	@Override
	protected void doBusiness() {
		String query = request.getParameter("query");
		String tcusername = (String) request.getSession().getAttribute("username");
		Tcompany tc = tcompanyDAO.getpub(tcusername);
		if (query.equals("apply")) { //申请未得到回复
			String sql = "select * from Tapply where TA_status = " +
				Tapply.UN_APPLY_PASS + " and TC_id ="+tc.getTcid();
			List<Tapply> tapplys = applyDAO.aquery(sql);
			request.setAttribute("tapplys", tapplys);
			forward("/company/bid/bid_query.jsp");
				
		} else if (query.equals("bidding")) {
			String sql = "select * from Tjoin where TJ_status = " +
				Tjoin.UN_BIDDING + " and TC_id = " + tc.getTcid();
			List<Tjoin> tjoins = tjoinDAO.aquery(sql);		
			request.setAttribute("tjoins", tjoins);
		} else if (query.equals("endbid")) { //列出中标信息
			
		}
	}

}