lookonequestionaction.java

使用J2EE Struts开发的房地产信息咨询系统

/**
 * 查看具体某个咨询问题的Action Bean
 * LookOneQuestionAction.java
 * @author usr
 */

package building;

import java.util.*;
import javax.sql.*;
import javax.servlet.ServletContext;
import javax.servlet.http.*;

import org.apache.struts.action.*;

public final class LookOneQuestionAction extends Action
{
	public ActionForward execute(
			ActionMapping mapping,
			ActionForm form,
			HttpServletRequest request,
			HttpServletResponse response)
	throws Exception
	{
		DynaActionForm questionIdForm = (DynaActionForm)form;
		
		Integer questionId = (Integer)questionIdForm.get("questionid");
		
		HttpSession session = request.getSession(true);
		ServletContext context = servlet.getServletContext();
		DataSource dataSource = (DataSource)context.getAttribute(Constants.DATASOURCE_KEY);
		DB db = new DB(dataSource);
		
		Question qt = Question.getOneQuestion(db,questionId.intValue());
		Vector awList = Answer.getAnswerByQTID(db,questionId.intValue());
		
		String PageForward = null;
		
		if ( qt != null )
		{
			session.setAttribute(Constants.QT_ONE_KEY,qt);
			session.setAttribute(Constants.AWLIST_KEY,awList);
		}//End of 
		else
		{
			session.setAttribute(Constants.QT_ONE_KEY,null);
			session.setAttribute(Constants.AWLIST_KEY,null);
		}//End of else
		
		PageForward = "toOneQuestion";
		
		db.close();
		
		return(mapping.findForward(PageForward));
	}//End of execute
	
}//End of class LookOneQuestionAction