caozuoxitongliebiao.java

来自「Bug管理系统」· Java 代码 · 共 27 行

package xiangmu;

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


public class caozuoxitongliebiao {
            public Vector items=new Vector();   //操作系统列表集合
    public caozuoxitongliebiao()throws Exception {
            //连接数据库
            Db db1 = new Db();
            db1.getCon("bugBarrier");
            //获得表中数据
            Statement stmt = db1.conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from caozuoxitong ");
            while (rs.next()) {
                caozuoxitong czxt=new caozuoxitong();
                czxt.setXitongid(rs.getString("caozuoxitongId"));
                czxt.setXitongzhi(rs.getString("caozuoxitongZhi"));
                this.items.add(czxt);
            }
        db1.closeConnection();
    }
}