xiangmuzhuangtailiebiao.java~6~

Bug管理系统

package xiangmu;

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

public class xiangmuzhuangtailiebiao {
    public Vector items=new Vector();   //项目状态列表集合
    public xiangmuzhuangtailiebiao() throws Exception{
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt = db1.conn.createStatement();
            ResultSet rs = stmt.executeQuery(" select * from dbo.xiangmuzhuangtai ");
            while (rs.next()) {
                xiangmuzhuangtai xtqx=new xiangmuzhuangtai();
                xtqx.setXiangmuzhuangtaiid(rs.getString("xiangmuzhuangtaiId"));
                xtqx.setXiangmuzhuangtaizhi(rs.getString("xiangmuzhuangtaiZhi"));
                this.items.add(xtqx);
            }
        db1.closeConnection();
    }
    public static void main()
    {
        xiangmuzhuangtailiebiao x=new xiangmuzhuangtailiebiao();

    }
}