youxianjiliebiao.java

Bug管理系统

package xiangmu;

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


public class youxianjiliebiao {
        public Vector items=new Vector();   //优先级列表集合
    public youxianjiliebiao()throws Exception {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt = db1.conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from bugyanzhongchengdu");
            while (rs.next()) {
                youxianji tmp = new  youxianji();
                tmp.setXiuxianjiid(rs.getString("bugyanzhongchengduId"));
                tmp.setXiuxianjizhi(rs.getString("bugyanzhongchengduZhi"));

                this.items.add(tmp);
            }
        db1.closeConnection();
    }
/*    public static void main(String args[])throws Exception
    {
        youxianjiliebiao yl=new youxianjiliebiao();
        java.util.Iterator i=yl.items.iterator();
        while(i.hasNext())
        {
            youxianji y=new youxianji();
            y=(youxianji)i.next();
            System.out.println(y.getXiuxianjiid());
        }
    }*/
}