kaifarenyuanliebiao.java

Bug管理系统

package yonghu;

import java.util.*;
import db.Db;
import java.sql.ResultSet;
import java.sql.Statement;


public class kaifarenyuanliebiao {
    public Vector items=new Vector();   //bug状态列表集合
    public kaifarenyuanliebiao()throws Exception {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt = db1.conn.createStatement();
            ResultSet rs = stmt.executeQuery("select yonghuid,yonghuming from yonghu where yonghuid in(select y.yonghuid from yonghu y, kaifarenyuan k where k.yonghuid=y.yonghuid and y.yonghuid<>0)");
            while (rs.next()) {
                jiandanyonghu y=new jiandanyonghu();
                y.setYonghuid(rs.getString("yonghuid"));
                y.setYonghuming(rs.getString("yonghuming"));
                this.items.add(y);
            }
        db1.closeConnection();
    }
    public kaifarenyuanliebiao(String xiangmuid)throws Exception {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt = db1.conn.createStatement();
            ResultSet rs = stmt.executeQuery("execute chaxunkaifarenyuan "+xiangmuid);
            while (rs.next()) {
                jiandanyonghu y=new jiandanyonghu();
                y.setYonghuid(rs.getString("yonghuid"));
                y.setYonghuming(rs.getString("yonghuming"));
                this.items.add(y);
            }
        db1.closeConnection();
    }
 /*   public static void main(String args[])throws Exception
    {
        kaifarenyuanliebiao k=new kaifarenyuanliebiao("2");
        Iterator i=k.items.iterator();
        while(i.hasNext())
        {
            System.out.println(((jiandanyonghu)i.next()).getYonghuid());
        }
    }*/
}