projectnameaction.java

来自「BUG跟踪系统是用来对开发软件时发现的bug进行跟踪。里面包括用户管理模块」· Java 代码 · 共 65 行

package su.bts1.action;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;

import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import su.bts1.bean.ProjectBean;
import su.bts1.imp.BugBeansDB;

public class ProjectNameAction extends Action {

	/*
	 * (non-Javadoc)
	 *
	 * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping,
	 *      org.apache.struts.action.ActionForm,
	 *      javax.servlet.http.HttpServletRequest,
	 *      javax.servlet.http.HttpServletResponse)
	 */
	@Override
	public ActionForward execute(ActionMapping mapping, ActionForm actionform,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		ProjectBean pb = (ProjectBean) actionform;

		// 获得连接实例
		DataSource ds = this.getDataSource(request, "testDb");
		Connection conn = ds.getConnection();

		if (conn == null) {
			return mapping.findForward("error.jsp");
		}

		String projName = pb.getProjName();
		HttpSession session = request.getSession();

		// 显示bug属性
		BugBeansDB bug = new BugBeansDB();
		List list = bug.bugBeans(projName, conn);
		session.setAttribute("bugN", list);

		// 关闭连接
		try {
			conn.close();
		} catch (Exception e) {
			e.getStackTrace();
		}
		return mapping.findForward("success");
	}

}