leibieliebiao.java~3~

来自「Bug管理系统」· JAVA~3~ 代码 · 共 26 行

package xiangmu;

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

public class leibieliebiao {
    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()) {
        jiandanyonghu y=new jiandanyonghu();
        y.setYonghuid(rs.getString("yonghuid"));
        y.setYonghuming(rs.getString("yonghuming"));
        this.items.add(y);
    }
db1.closeConnection();

    }
}