cbshowlist.java

库存管理信息系统

package KcglSys;

/**
 * <p>Title: 库存管理信息系统</p>
 * <p>Description: 库存管理信息系统，企业好帮手</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: ios</p>
 * @author dragon
 * @version 1.0
 */

import java.sql.*;

import javax.swing.*;

class CbShowList {
  CbShowList() {}

  public void load_Data(JComboBox jcb, String sql) {
    ResultSet rs = null;
    //实例化ConnectDBBean
    ConnectDBBean conndb = new ConnectDBBean();
    try {
      rs = conndb.executeQuery(sql); //执行查询
      while (rs.next()) { //判断结果集是否存在
        jcb.addItem(rs.getString(1));
      }
    }
    catch (SQLException ex) {
      System.err.println("sql error!");
    }
  }
}