gerenxinxi.java

Bug管理系统

           String xiangmuid=(this.getSuochuxiangmu()).getXiangmuId();
           this.db1.getCon("bugBarrier");

           Statement stmt1=db1.conn.createStatement();
           Statement stmt2=db1.conn.createStatement();
           Statement stmt3=db1.conn.createStatement();

           ResultSet rs1=stmt1.executeQuery("select * from xiangmu  where xiangmujingliid='"+yonghuid+"' and xiangmuid='"+xiangmuid+"'");
           ResultSet rs2=stmt2.executeQuery("select * from ceshirenyuan  where xiangmuid='"+xiangmuid+"' and yonghuid='"+yonghuid+"'");
           ResultSet rs3=stmt3.executeQuery("select * from kaifarenyuan where xiangmuid='"+xiangmuid+"' and yonghuid='"+yonghuid+"'");
           int n1=0;
           int n2=0;
           int n3=0;
           while(rs1.next())
           {
               if(n1!=4)
                   n1=4;
           };
           while(rs2.next())
           {
               if(n2!=1)
                   n2=1;
           }
            while(rs3.next())
           {
               if(n3!=2)
                   n3=2;
           }
           //n为项目权限值
           int n=n1+n2+n3;
           //设置项目权限
           this.setXiangmuquanxian(String.valueOf(n));

           //设置当前项目中所处于的角色
           int js=0;
           js=Integer.parseInt(this.getXiangmuquanxian());

           //
           juese j1=new juese();
           j1.setJueseid("1");
           j1.setJuesezhi("测试人员");

           juese j2=new juese();
           j2.setJueseid("2");
           j2.setJuesezhi("开发人员");

           juese j3=new juese();
           j3.setJueseid("4");
           j3.setJuesezhi("项目组长");

           //填充 其他角色列表
           Vector v=new Vector();
           if(js==7  || js==6 || js==5 || js==4)
           {
               if(js==7)
               {
                   v.add(j1);
                   v.add(j2);
               }
               else if(js==6)
               {
                   v.add(j2);
               }
               else if(js==5)
               {
                   v.add(j1);
               }
               js=4;
           }
           else if(js==3 || js==2)
           {
               if(js==3)
               {
                   v.add(j1);
               }
               js=2;
           }
           else
           {
               js=1;
           }
           //储存起来
           this.setSuochujuese(String.valueOf(js));  //所处角色
           this.setQitajueseliebiao(v);   //其他角色列表
        }
    }

    //添冲所处项目中的模块列表
     public void addgerenmokuailiebiao()throws Exception
     {
         if(this.getSuochuxiangmu()!=null)  //如果有所处项目
         {
             //所处项目id
             String xiangmuid = (this.getSuochuxiangmu()).getXiangmuId();

             mokuailiebiao ml = new mokuailiebiao();
             ml.addmokuai(xiangmuid);

             this.setGerenmokuailiebiao(ml);
         }
     }

     //添冲2个请求沿后的bug
     public void addqingqiuyanhou()throws Exception
     {
         if (this.getSuochuxiangmu() != null) { //如果有所处项目
             String s = this.getSuochujuese();
             //如果所处角色是 项目经理
             if (s.equals("4")) {
                 //所处项目id
                 String xiangmuid = (this.getSuochuxiangmu()).getXiangmuId();
                 //连接数据库
                 db1.getCon("bugBarrier");
                 //获得表中数据
                 Statement stmt = db1.conn.createStatement();
                 ResultSet rs = stmt.executeQuery(
                         "select bugid from bug where  bugSuoshuxiangmuId='" +
                         xiangmuid + "' and bugZhuangtaiId=7");
                 int n = 0;
                 bugliebiao bl = new bugliebiao();
                 while (rs.next()) {
                     String bugid = rs.getString("bugid");
                     bl.addbug(bugid, "", "", "", "", "", "", "", "", "", "", "", "",
                               "", "");
                     n++;
                     if (n == 2)
                         return;
                 }
                 //
                 this.setXiangmujinglibugliebiao(bl);
                 db1.closeConnection();
             }
         }
     }
     //添冲5个bug事务
     public void addgerenbugshiwu() throws Exception
     {
         if (this.getSuochuxiangmu() != null) { //如果有所处项目
             //用户id
             String yonghuid = ((yonghu)this.getBenrenxinxi()).getYonghuId();
             if (this.getSuochuxiangmu() != null) {
                 //所处项目id
                 String xiangmuid = (this.getSuochuxiangmu()).getXiangmuId();
                 //查询字符串
                 String s = null;
                 //连接数据库
                 this.db1.getCon("bugBarrier");

                 //所处角色
                 String js = this.getSuochujuese();

                 if (js.equals("1")) { //测试人员
                     s = "select bugid from bug where bugChuangjianzheId='" +
                         yonghuid + "' and  bugSuoshuxiangmuId='" + xiangmuid + "' and (bugZhuangtaiId='3' or bugZhuangtaiId='4' or bugZhuangtaiId='5')  order by bugChulishijian desc ";
                 } else if (js.equals("2")) { //开发人员
                     s = "select bugid from bug where bugChulizheId='" +
                         yonghuid +
                         "' and  bugSuoshuxiangmuId='" + xiangmuid + "' and (bugZhuangtaiId='1' or bugZhuangtaiId='2') order by  bugChuangjianshijian desc";
                 } else if (js.equals("4")) { //项目经理
                     s = "select bugid from bug where bugYujiezhishijian<getdate() and bugSuoshuxiangmuId='" +
                         xiangmuid + "'  order by  bugChuangjianshijian desc";
                 }
                 Statement stmt = db1.conn.createStatement();
                 if (s != null) {
                     ResultSet rs = stmt.executeQuery(s); //提取bug
                     int n = 0;
                     bugliebiao bl = new bugliebiao();
                     while (rs.next()) {
                         String bugid = rs.getString("bugid");
                         bl.addbug(bugid, "", "", "", "", "", "", "", "", "",
                                   "",
                                   "", "", "", "");
                         n++;
                         if (n == 5)
                             break;
                     }
                     //添冲这5个bug
                     this.setJuesebugliebiao(bl);
                 }
                 //关闭数据库
                 this.db1.closeConnection();
             }
         }
     }
    //个人信息初始化
    public void chushihua()throws Exception
    {
           //连接数据库
           this.db1.getCon("bugBarrier");

           //添冲系统权限
           this.addxitongquanxian();

           //添冲项目列表
           this.addgerenxiangmuliebiao();

           //添冲所处项目
           this.addsuochuxiangmu();

           if(this.getSuochuxiangmu()==null)//如果此用户不含项目则不执行下面的初始化
               return;

           //添冲项目权限 和所处角色 4、项目经理 1、项目测试人员 2、项目开发人员
           this.addxiangmuquanxian();

           //添冲模块列表
           this.addgerenmokuailiebiao();

           //设置所处模块为空
           this.suochumokuai=null;

           //添冲2个待沿后bug
           this.addqingqiuyanhou();

           //添加个人5个bug事物
           this.addgerenbugshiwu();

           //关闭数据库
           this.db1.closeConnection();

    }

    //个人信息初始化:设置所处项目
    public void chushihuaxiangmu(String xiangmuid)throws Exception
    {
           //连接数据库
           this.db1.getCon("bugBarrier");

           //添冲系统权限
           this.addxitongquanxian();

           //添冲项目列表
           this.addgerenxiangmuliebiao();

           //添冲所处项目,在项目列表中的最后一个
           this.addsuochuxiangmu();

           /***********设置所处项目************/
           this.shezhisuochuxiangmu(xiangmuid);

           if(this.getSuochuxiangmu()==null)//如果此用户不含项目则不执行下面的初始化
               return;

           //添冲项目权限 和所处角色 4、项目经理 1、项目测试人员 2、项目开发人员
           this.addxiangmuquanxian();

           //添冲模块列表
           this.addgerenmokuailiebiao();

           //添冲2个待沿后bug
           this.addqingqiuyanhou();

           //添加个人5个bug事物
           this.addgerenbugshiwu();

           //关闭数据库
           this.db1.closeConnection();

    }

    //个人信息初始化:设置所处项目
    public void chushihuamokuai(String mokuaiid)throws Exception
    {
           //连接数据库
           this.db1.getCon("bugBarrier");

           //添冲系统权限
           this.addxitongquanxian();

           //添冲项目列表
           this.addgerenxiangmuliebiao();

           //添冲所处项目,在项目列表中的最后一个
           this.addsuochuxiangmu();

           if(this.getSuochuxiangmu()==null)//如果此用户不含项目则不执行下面的初始化
               return;

           //添冲项目权限 和所处角色 4、项目经理 1、项目测试人员 2、项目开发人员
           this.addxiangmuquanxian();

           //添冲模块列表
           this.addgerenmokuailiebiao();

           /*********设置所处模块**********/
           this.shezhisuomokuai(mokuaiid);

           //添冲2个待沿后bug
           this.addqingqiuyanhou();

           //添加个人5个bug事物
           this.addgerenbugshiwu();

           //关闭数据库
           this.db1.closeConnection();

    }
    //个人信息初始化:设置所处项目
    public void chushihuasuochujuese(String jueseid)throws Exception
    {
           //连接数据库
           this.db1.getCon("bugBarrier");

           //添冲项目权限 和所处角色 4、项目经理 1、项目测试人员 2、项目开发人员
          // this.addxiangmuquanxian();

           /**********设置所处角色*************/
           this.shezhisuochujues(jueseid);

           //添冲模块列表
           this.addgerenmokuailiebiao();


           //添冲2个待沿后bug
           this.addqingqiuyanhou();

           //添加个人5个bug事物
           this.addgerenbugshiwu();

           //关闭数据库
           this.db1.closeConnection();

    }


/*   //测试
    public static void main(String args[])throws Exception
    {
        gerenxinxi ren=new gerenxinxi();
        boolean b=ren.denglupanduan("六六","123");  //添冲本人信息
        if(b==true)
        {
            ren.chushihua();  //个人信息初始化

            System.out.println(ren.xitongquanxian);
            System.out.println(((xiangmu)ren.getSuochuxiangmu()).getXiangmumingcheng());
            System.out.println(ren.xiangmuquanxian);
            System.out.println(ren.getSuochujuese());

            if(ren.qitajueseliebiao!=null)
            {
                Iterator i1 = ren.getQitajueseliebiao().iterator();
                while (i1.hasNext()) {
                    juese js=new juese();
                    js=(juese)i1.next();
                    System.out.println(js.getJuesezhi());
                }
            }
        }
        else
        {
            System.out.println("无此用户！");
        }
    }
*/
}