buildwarehousetree.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.*;
import javax.swing.tree.DefaultMutableTreeNode;

class buildWarehouseTree {
  buildWarehouseTree() {
  }

  public void get_Tree(JTree tree, DefaultMutableTreeNode top) {
    ResultSet rs = null;
    //实例化ConnectDBBean
    ConnectDBBean conndb = new ConnectDBBean();
    //sql查询语句
    String sql = " select whid,whname from warehouses";

    try {
      rs = conndb.executeQuery(sql); //执行查询

      while (rs.next()) { //判断结果集是否存在
        int whid = rs.getInt(1);
        String warename = rs.getString(2);

        DefaultMutableTreeNode warenode = new DefaultMutableTreeNode("[" + whid +
            "]" + warename);
        top.add(warenode);
        //实例化buildTree
        buildWhStallsTree buildtree = new buildWhStallsTree();
        //初始化tree
        buildtree.get_Tree(tree, warenode, whid);

      }
    }
    catch (SQLException ex) {
      System.err.println("sql error!");
    }
  }
}