xitongquanxianliebiao.java

Bug管理系统

package yonghu;

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

public class xitongquanxianliebiao {
    public Vector items=new Vector();   //系统权限列表集合
    public xitongquanxianliebiao()throws Exception {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt = db1.conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from xitongquanxian");
            while (rs.next()) {
                xitongquanxian tmp = new xitongquanxian();
                tmp.xitongquanxianid = rs.getString("xitongquanxianId");
                tmp.xitongquanxianzhi = rs.getString("quanxianZhi");
                this.items.add(tmp);
            }
        db1.closeConnection();
    }
}