leibieliebiao.java

Bug管理系统

package xiangmu;

import db.Db;
import yonghu.jiandanyonghu;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;

public class leibieliebiao {
        public Vector items=new Vector();   //bug类别列表集合
    public leibieliebiao() throws Exception{
            //连接数据库
    Db db1 = new Db();
    db1.getCon("bugBarrier");
    //获得表中数据
    Statement stmt = db1.conn.createStatement();
    ResultSet rs = stmt.executeQuery("select * from bugleibie");
    while (rs.next()) {
        bugleibie blb=new bugleibie();
        blb.setLiebiaozhi(rs.getString("bugLeibiezhi"));
        blb.setLiebieid(rs.getString("bugLeibieId"));
        this.items.add(blb);
    }
    db1.closeConnection();
    }
}