tianjiaceshirenyuanaction.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 db.Db;
import java.sql.Statement;
import gerenxinxi.gerenxinxi;
import javax.servlet.http.HttpSession;
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 tianjiaceshirenyuanAction extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse)throws Exception {
        tianjiaceshirenyuanActionForm f = (tianjiaceshirenyuanActionForm) actionForm;
        String yonghuId=f.getYonghu1();
        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 ceshirenyuan 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 ceshirenyuan 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");

    }
}