tianjiakaifarenyuanaction.java

Bug管理系统

package tmp;

import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import gerenxinxi.gerenxinxi;
import javax.servlet.http.HttpSession;
import db.Db;
import java.sql.Statement;
import java.sql.ResultSet;
import xiangmu.xiangmuliebiao;
import yonghu.ceshirenyuanliebiao;
import xiangmu.xiangmu;
import yonghu.yonghuliebiao;
import yonghu.kaifarenyuanliebiao;
import java.util.Iterator;
import xiangmu.mokuailiebiao;
import xiangmu.*;

public class tianjiakaifarenyuanAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse) throws
            Exception {

        tianjiakaifarenyuanActionForm f = (tianjiakaifarenyuanActionForm)
                                          actionForm;
        String yonghuId = f.getYonghu2();
        yonghuId = new String(yonghuId.getBytes("ISO-8859-1"), "gbk");

        //得到对象
        HttpSession session = servletRequest.getSession();
        gerenxinxi yonghu1 = new gerenxinxi();
        yonghu1 = (gerenxinxi) session.getAttribute("yonghu1");
        String xiangmuid = yonghu1.getSuochuxiangmu().getXiangmuId();

        if (!yonghuId.equals("")) {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            String s = "";
            //先看项目中是否有此用户
            Statement stmt = db1.conn.createStatement();
            s = "select * from kaifarenyuan where xiangmuid='" + xiangmuid +
                "' and yonghuid='" + yonghuId + "'";
            ResultSet rs = stmt.executeQuery(s);
            int n = 0;
            while (rs.next()) {
                n++;
            }
            if (n == 0) {
                //先看项目中是否有此用户
                Statement stmt2 = db1.conn.createStatement();
                s = "insert into kaifarenyuan values('" + xiangmuid + "','" +
                    yonghuId + "')";
                stmt.execute(s);
            }
            db1.closeConnection();
        }

        //拿到此项目
        xiangmuliebiao xl = new xiangmuliebiao();
        xl.addxiangmu(xiangmuid, "", "", "", "", "");
        Iterator i1 = xl.xiangmuitems.iterator();
        xiangmu xm = new xiangmu();
        if (i1.hasNext()) {
            xm = (xiangmu) i1.next();
        }
        servletRequest.setAttribute("xm", xm);

        //全部用户列表
        yonghuliebiao yl = new yonghuliebiao();
        yl.addyonghu();
        servletRequest.setAttribute("yl", yl);

        //得到测试人员
        ceshirenyuanliebiao cl = new ceshirenyuanliebiao(xiangmuid);
        servletRequest.setAttribute("cl", cl);

        //得到开发人员
        kaifarenyuanliebiao kl = new kaifarenyuanliebiao(xiangmuid);
        servletRequest.setAttribute("kl", kl);

        //项目状态列表
        xiangmuzhuangtailiebiao xmztlb = new xiangmuzhuangtailiebiao();
        servletRequest.setAttribute("xmztlb", xmztlb);

        //模块列表
        mokuailiebiao ml = new mokuailiebiao();
        ml.addmokuai(xiangmuid);
        servletRequest.setAttribute("ml", ml);

        //提示信息
        String xinxi="添加开发人员成功!";
        servletRequest.setAttribute("xinxi",xinxi);

        return actionMapping.findForward("xiugaixiangmu");

    }
}