leibieliebiao.java~2~

Bug管理系统

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 y.yonghuid,y.yonghuming from yonghu y, kaifarenyuan k where k.yonghuid=y.yonghuid ");
    while (rs.next()) {
        jiandanyonghu y=new jiandanyonghu();
        y.setYonghuid(rs.getString("yonghuid"));
        y.setYonghuming(rs.getString("yonghuming"));
        this.items.add(y);
    }
db1.closeConnection();

    }
}