xiangmutongji.java~23~

Bug管理系统

package xiangmu;

import java.util.Vector;
import java.sql.Statement;
import java.sql.ResultSet;
import db.Db;
import java.util.Iterator;

public class xiangmutongji {
    //需要初始化的属性
    public String xiangmuid="";   //项目id
    public String kaishishijian="1900-01-01";
    public String jieshushijian="2100-12-31";
    //存储单位
    public tongjikuai bugzongshu=new tongjikuai();  //bug总数
    public Vector mokuaiitems=new Vector();   //模块统计
    public Vector ceshirenyuanitems=new Vector();   //测试人员统计
    public Vector kaifarenyuanitems=new Vector();   //开发人员统计
    public Vector leixingitems=new Vector();   //类型统计

    public xiangmutongji() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public void chaxunbugzongshu() throws Exception  //查询bug总数
    {
            //连接数据库
            Db db1=new Db();
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt=db1.conn.createStatement();
            System.out.println(xiangmuid+" 444444444");
            String s="execute bugzongshu '"+this.xiangmuid+"','"+this.kaishishijian+"','"+this.jieshushijian+"'";
            ResultSet rs=stmt.executeQuery(s);
            rs.next();
            //设置
            String s1="Bug总数";
            this.bugzongshu.setBiaoti(s1);
            String s2=rs.getString("bugzongshu");
            System.out.println(s2);
            this.bugzongshu.setShuliang(s2);
            db1.closeConnection();
    }

    public void chaxunmokuai() throws Exception  //查询各模块中bug数
    {
            //连接数据库
            Db db1=new Db();
            db1.getCon("bugBarrier");
            //获得表中各个模块名称和id
            Statement stmt=db1.conn.createStatement();
            String s="select * from mokuai where xiangmuid='"+this.xiangmuid+"'";
            ResultSet rs=stmt.executeQuery(s);
            while(rs.next())
            {
                //新建一个模块对象
                tongjikuai t=new tongjikuai();
                //设置模块名称
                String s1 =rs.getString("mokuaizhi");   //模块名称
                t.setBiaoti(s1);
                String id=rs.getString("mokuaiId");     //模块id
                //查询模块中bug数
                Statement stmt1=db1.conn.createStatement();
                String st="execute mokuaibugshu '"+this.xiangmuid+"','"+id+"','"+this.kaishishijian+"','"+this.jieshushijian+"'";
                ResultSet rs1=stmt1.executeQuery(st);
                rs1.next();
                String s2 = rs1.getString("mokuaibugshu");

                t.setShuliang(s2);

                if((Integer.parseInt(this.bugzongshu.getShuliang())!=0))
                                t.bili=(Integer.parseInt(s2)*100)/Integer.parseInt(this.bugzongshu.getShuliang());
                else
                    t.bili=0;
                //添加 模块统计块
                this.mokuaiitems.add(t);
              }
             db1.closeConnection();
    }


    public void chaxunceshirenyuan() throws Exception  //查询测试人员的bug数
    {
            //连接数据库
            Db db1=new Db();
            db1.getCon("bugBarrier");

            //获得表中各测试人员信息
            Statement stmt=db1.conn.createStatement();
            String s="select c.yonghuid , y.yonghuming from ceshirenyuan c ,yonghu y where c.yonghuid=y.yonghuid and c.xiangmuid ='"+this.xiangmuid+"'";
            ResultSet rs=stmt.executeQuery(s);
            while(rs.next())
            {
                //新建一个统计对象
                tongjikuai t=new tongjikuai();
                //设置测试人员名称
                String s1 =rs.getString("yonghuming");   //测试人员用户名
                t.setBiaoti(s1);
                String id=rs.getString("yonghuid");     //测试人员id
                //查询测试人员的bug数
                Statement stmt1=db1.conn.createStatement();
                String st="execute ceshirenyuanfaxianbugshu '"+this.xiangmuid+"','"+id+"','"+this.kaishishijian+"','"+this.jieshushijian+"'";
                ResultSet rs1=stmt1.executeQuery(st);
                rs1.next();
                String s2 = rs1.getString("ceshirenyuanfaxianbugshu");
                t.setShuliang(s2);
                if((Integer.parseInt(this.bugzongshu.getShuliang())!=0))
                                t.bili=(Integer.parseInt(s2)*100)/Integer.parseInt(this.bugzongshu.getShuliang());
                else
                    t.bili=0;
                //添加 测试人员统计块
                this.ceshirenyuanitems.add(t);
              }
             db1.closeConnection();
    }

    public void chaxunkaifarenyuan() throws Exception  //查询开发人员的bug数
    {
            //连接数据库
            Db db1=new Db();
            db1.getCon("bugBarrier");

            //获得表中各测试人员信息
            Statement stmt=db1.conn.createStatement();
            String s="select c.yonghuid , y.yonghuming from kaifarenyuan c ,yonghu y where c.yonghuid=y.yonghuid and c.xiangmuid ='"+this.xiangmuid+"'";
            ResultSet rs=stmt.executeQuery(s);
            while(rs.next())
            {
                //新建一个统计对象
                tongjikuai t=new tongjikuai();
                //设置开发人员名称
                String s1 =rs.getString("yonghuming");   //开发人员用户名
                t.setBiaoti(s1);
                String id=rs.getString("yonghuid");     //开发人员id
                //查询开发人员的bug数
                Statement stmt1=db1.conn.createStatement();
                String st="execute kaifarenyuanfashengbugshu '"+this.xiangmuid+"','"+id+"','"+this.kaishishijian+"','"+this.jieshushijian+"'";
                ResultSet rs1=stmt1.executeQuery(st);
                rs1.next();
                String s2 = rs1.getString("kaifarenyuanfashengbugshu");
                t.setShuliang(s2);
                if((Integer.parseInt(this.bugzongshu.getShuliang())!=0))
                                t.bili=(Integer.parseInt(s2)*100)/Integer.parseInt(this.bugzongshu.getShuliang());
                else
                    t.bili=0;
                //添加 开发人员统计块
                this.kaifarenyuanitems.add(t);
              }
             db1.closeConnection();
    }

    public void chaxunbugleibie() throws Exception  //查询各类别中bug数
    {
            //连接数据库
            Db db1=new Db();
            db1.getCon("bugBarrier");
            //获得表中各个类别名称和id
            Statement stmt=db1.conn.createStatement();
            String s="select * from bugleibie ";
            ResultSet rs=stmt.executeQuery(s);
            while(rs.next())
            {
                //新建一个类别对象
                tongjikuai t=new tongjikuai();
                 //设置模块名称
                String s1 =rs.getString("bugLeibiezhi");   //模块名称
                t.setBiaoti(s1);
                String id=rs.getString("bugLeibieId");     //模块id

               //查询模块中bug数
                Statement stmt1=db1.conn.createStatement();
                String st="execute bugleixingbugshu '"+this.xiangmuid+"','"+id+"','"+this.kaishishijian+"','"+this.jieshushijian+"'";
                ResultSet rs1=stmt1.executeQuery(st);
                rs1.next();
                String s2 = rs1.getString("bugleixingbugshu");
                t.setShuliang(s2);
                if((Integer.parseInt(this.bugzongshu.getShuliang())!=0))
                                t.bili=(Integer.parseInt(s2)*100)/Integer.parseInt(this.bugzongshu.getShuliang());
                else
                    t.bili=0;
                //添加 模块统计块
                this.leixingitems.add(t);
              }
             db1.closeConnection();
    }

    public void chushihua()throws Exception
    {
        //查询 bug总数
        this.chaxunbugzongshu();

        //查询 模块中bug数
        this.chaxunmokuai();

        //查询 测试人员bug数
        this.chaxunceshirenyuan();

        //查询 开发人员bug数
        this.chaxunkaifarenyuan();

        //查询 bug类别
        this.chaxunbugleibie();

    }
    private void jbInit() throws Exception {
    }

   //测试
/*    public static void main(String args[])throws Exception
    {
       xiangmutongji tongji1=new xiangmutongji();
       tongji1.xiangmuid="1";
       tongji1.chushihua();

       String s1=tongji1.bugzongshu.getBiaoti();
       String s2=tongji1.bugzongshu.getShuliang();
       System.out.println(s1+" "+s2);


       Iterator i1=tongji1.leixingitems.iterator();

       while(i1.hasNext())
       {
           tongjikuai b1=(tongjikuai)i1.next();
           System.out.println(b1.getBiaoti()+" "+b1.getShuliang()+" "+b1.bili);
       }

    }*/

}