showpublish.java

招标网站

package com.jblack.servlet;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import com.jblack.dao.TcompanyDAO;
import com.jblack.dao.TpublishDAO;
import com.jblack.model.Tcompany;
import com.jblack.model.Tpublish;
import com.jblack.tool.BaseServlet;

public class ShowPublish extends BaseServlet {

	private static final long serialVersionUID = 1L;
	private TcompanyDAO tcompanyDAO = new TcompanyDAO();
	private TpublishDAO tpublishDAO = new TpublishDAO();
	private SimpleDateFormat date = new SimpleDateFormat("yyyy-MM-dd");

	@Override
	protected void doBusiness() {
		String query = request.getParameter("query");
		String tcusername = (String) request.getSession().getAttribute("username");
		Tcompany tc = tcompanyDAO.getpub(tcusername);
		if(query.equals("current")) {
			String sql = "select * from Tpublish where " +
					"TP_gameDate < date('" + date.format(new Date()) +
					"') and " +
					"TP_gameDeadline > date('" + date.format(new Date()) +
					"') and " +
					"TC_id ="+tc.getTcid();
			List<Tpublish> tpublishs = tpublishDAO.queryPublish(sql);
			request.setAttribute("tpublishs", tpublishs);
			forward("/company/publish/publish_query.jsp");
		} else if (query.equals("end")) {
			String sql = "select * from Tpublish where "
				+ "TP_gameDeadline < date('" + date.format(new Date()) 
				+ "') and TC_id ="+tc.getTcid();
			List<Tpublish> tpublishs = tpublishDAO.queryPublish(sql);
			request.setAttribute("tpublishs", tpublishs);
			forward("/company/publish/publish_query.jsp");
		} else if (query.equals("last")) {
			String sql = "select * from Tpublish where "
				+" TP_winner >" + 0
				+ " and TC_id ="+tc.getTcid();
			List<Tpublish> tpublishs = tpublishDAO.queryPublish(sql);
			request.setAttribute("tpublishs", tpublishs);
			forward("/company/publish/publish_query.jsp");
		}
		                             
		
	}

}