tianjiakaifarenyuanaction.java~7~

来自「Bug管理系统」· JAVA~7~ 代码 · 共 99 行

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;

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);

                return actionMapping.findForward("xiugaixiangmu");

}