gerenxinxi.java

Bug管理系统

package gerenxinxi;

import java.sql.*;
import java.util.*;
import db.*;
import xiangmu.*;
import yonghu.*;

public class gerenxinxi {
    private yonghu benrenxinxi;//本人信息
    private String xitongquanxian;   //系统权限
    private xiangmuliebiao gerenxiangmuliebiao;//个人项目列表
    private xiangmu suochuxiangmu;//所处于的项目

    private String xiangmuquanxian;  //项目权限
    private mokuailiebiao gerenmokuailiebiao;//个人模块列表
    private mokuai suochumokuai; //所处模块

    private String suochujuese;      //所处于的角色

    private bugliebiao juesebugliebiao;  //角色bug列表 5个
    private bugliebiao xiangmujinglibugliebiao; //项目经理角色bug列表 2个

    public Db db1=new Db(); //连接数据库对象

    private Vector qitajueseliebiao;  //其他角色列表

    public gerenxinxi() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public void setXitongquanxian(String xitongquanxian) {
        this.xitongquanxian = xitongquanxian;
    }

    public void setXiangmuquanxian(String xiangmuquanxian) {
        this.xiangmuquanxian = xiangmuquanxian;
    }

    public void setGerenxiangmuliebiao(xiangmuliebiao gerenxiangmuliebiao) {
        this.gerenxiangmuliebiao = gerenxiangmuliebiao;
    }

    public void setSuochuxiangmu(xiangmu suochuxiangmu) {
        this.suochuxiangmu = suochuxiangmu;
    }

    public void setBenrenxinxi(yonghu benrenxinxi) {

        this.benrenxinxi = benrenxinxi;
    }

    public void setGerenmokuailiebiao(mokuailiebiao gerenmokuailiebiao) {
        this.gerenmokuailiebiao = gerenmokuailiebiao;
    }

    public void setSuochujuese(String suochujuese) {
        this.suochujuese = suochujuese;
    }

    public void setJuesebugliebiao(bugliebiao juesebugliebiao) {
        this.juesebugliebiao = juesebugliebiao;
    }

    public void setXiangmujinglibugliebiao(bugliebiao xiangmujinglibugliebiao) {
        this.xiangmujinglibugliebiao = xiangmujinglibugliebiao;
    }

    public void setSuochumokuai(mokuai suochumokuai) {
        this.suochumokuai = suochumokuai;
    }

    public void setQitajueseliebiao(Vector qitajueseliebiao) {
        this.qitajueseliebiao = qitajueseliebiao;
    }

    public String getXitongquanxian() {
        return xitongquanxian;
    }

    public String getXiangmuquanxian() {
        return xiangmuquanxian;
    }

    public xiangmuliebiao getGerenxiangmuliebiao() {
        return gerenxiangmuliebiao;
    }

    public xiangmu getSuochuxiangmu() {
        return suochuxiangmu;
    }

    public yonghu getBenrenxinxi() {

        return benrenxinxi;
    }

    public mokuailiebiao getGerenmokuailiebiao() {
        return gerenmokuailiebiao;
    }

    public String getSuochujuese() {
        return suochujuese;
    }

    public bugliebiao getJuesebugliebiao() {
        return juesebugliebiao;
    }

    public bugliebiao getXiangmujinglibugliebiao() {
        return xiangmujinglibugliebiao;
    }

    public mokuai getSuochumokuai() {
        return suochumokuai;
    }

    public Vector getQitajueseliebiao() {
        return qitajueseliebiao;
    }

    private void jbInit() throws Exception {
    }

    //判断用户是否存在,并提取出来(包括连接)
    public boolean denglupanduan(String name ,String password)throws Exception
    {
            //连接数据库
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt=db1.conn.createStatement();
            ResultSet rs=stmt.executeQuery("execute panduanyonghu '"+name+"','"+password+"'");//提取用户
            int n=0;
            while(rs.next())
            {
                n++;
                if(n==1)//如果查到了，存到个人信息中
                {
                    yonghu y1=new yonghu();
                    y1.setYonghuming(name.trim());
                    y1.setYonghuId(rs.getString("yonghuId"));
                    y1.setMima(rs.getString("mima"));
                    y1.setMimatishi(rs.getString("mimatishi"));
                    y1.setZhenshixingming(rs.getString("zhenshixingming"));
                    y1.setBangongdianhua(rs.getString("bangongdianhua"));
                    y1.setYidongdianhua(rs.getString("yidongdianhua"));
                    y1.setMsn(rs.getString("msn"));
                    y1.setBeizhu(rs.getString("beizhu"));
                    y1.setQq(rs.getString("qq"));
                    y1.setXitongquanxian(rs.getString("quanxianZhi"));
                    benrenxinxi=y1;
                }
            }
            db1.closeConnection();
            if(n==0)
                return false;
            else
                return true;
    }

    //得到系统权限
    public void addxitongquanxian()
    {
        if (!this.getBenrenxinxi().equals(null)) {
            String s = ((yonghu)this.getBenrenxinxi()).getXitongquanxian();
            this.setXitongquanxian(s);
        }
    }

    //得到个人项目列表
    public void addgerenxiangmuliebiao()throws Exception
    {
        if(!this.getBenrenxinxi().equals(null))
        {
            //得到用户id
            String yonghuid=((yonghu)this.getBenrenxinxi()).getYonghuId();
            //获得表中数据
            Statement stmt=db1.conn.createStatement();
            ResultSet rs=stmt.executeQuery("execute yonghuxiangmuliebiao "+yonghuid);//提取项目id
            xiangmuliebiao xl=new xiangmuliebiao();
            while(rs.next())
            {
                  String id=rs.getString("xiangmuid");
                  xl.addxiangmu(id,"","","","","");
            }
            //添加到个人项目列表中去
            this.setGerenxiangmuliebiao(xl);
        }
    }
    //个人信息初始化时 设置所处项目
    public void addsuochuxiangmu()throws Exception
    {
        if(this.suochuxiangmu==null)
        {
            Iterator i1 = this.gerenxiangmuliebiao.xiangmuitems.iterator();
            int n = 0;
            while (i1.hasNext()) {
                n++;
                xiangmu x = (xiangmu) i1.next();
                this.suochuxiangmu = x;
            }
            if (n == 0) {
                this.suochuxiangmu = null;
            }
        }
    }

//设置个人所处项目
public void shezhisuochuxiangmu(String xiangmuid)throws Exception
{
    Iterator i1=this.gerenxiangmuliebiao.xiangmuitems.iterator();
    while(i1.hasNext())
    {
       xiangmu x=(xiangmu)i1.next();
       if(x.getXiangmuId().equals(xiangmuid))
       {
           this.suochuxiangmu=x;
       }
    }
}

//设置所处模块
public void shezhisuomokuai(String mokuaiid)throws Exception
{
    Iterator i1 = this.gerenmokuailiebiao.mokuaiitems.iterator();
    while (i1.hasNext()) {
        mokuai m = (mokuai) i1.next();

        if (m.getMokuaiId().equals(mokuaiid)) {
            this.setSuochumokuai(m);
        }
    }

}

//设置所处角色
public void shezhisuochujues(String jueseid)throws Exception
{

    //
    //用户id
  String yonghuid=((yonghu)this.getBenrenxinxi()).getYonghuId();

  if(this.getSuochuxiangmu()!=null)  //如果有项目
  {

      //所处项目id
      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));

      //填充其他角色列表
      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(n==7)
      {
          if(jueseid.equals("1"))
          {
              v.add(j2);
              v.add(j3);
          }
          else if(jueseid.equals("2"))
          {
              v.add(j1);
              v.add(j3);
          }
          else
          {
              v.add(j1);
              v.add(j2);
          }
      }
      else if(n==6)
      {
          if(jueseid.equals("2"))
          {
              v.add(j3);
          }
          else
          {
              v.add(j2);
          }
      }
      else if(n==5)
      {
          if(jueseid.equals("1"))
              v.add(j3);
          else
              v.add(j1);
      }
      else if(n==3)
      {
          if(jueseid.equals("1"))
              v.add(j2);
          else
              v.add(j1);
      }
      //社定所处角色
      this.suochujuese = jueseid;
      this.qitajueseliebiao=v;
  }
}
    //添冲项目权限 设定 4、项目经理 1、项目测试人员 2、项目开发人员 和个人所处于的角色
    public void addxiangmuquanxian()throws Exception
    {
        //用户id
        String yonghuid=((yonghu)this.getBenrenxinxi()).getYonghuId();
        if(this.getSuochuxiangmu()!=null)  //如果有项目
        {
         //所处项目id