mainfrm.java~668~

基于java+sql2000超市货品进销存管理

        btnguanyu.setEnabled(true);
        btncancel.setEnabled(false);
        btntianjia.setEnabled(false);
        btnsell.setEnabled(false);
        txtid.setEnabled(false);
        btncan.setEnabled(false);
        txtnumber.setEnabled(false);
        chbvip.setEnabled(false);
        btnyingye.setEnabled(false);
        lblpv.setText("当前登陆用户：仓库管理员");
        jMenuItem1.setEnabled(false);
        jMenuItem2.setEnabled(true);
        cmbname.setEnabled(false);
        txtspname.setEnabled(false);
        btntong.setEnabled(false);
        btndate.setEnabled(false);
        btnkong.setEnabled(false);
        treeIn.setEnabled(true);
        btnjinhuo.setEnabled(true);
        btnquan.setEnabled(true);
        btncls.setEnabled(true);
        btninto.setEnabled(true);
        btncl.setEnabled(true);
        btnall.setEnabled(true);
        cmbyear.setEnabled(true);
        cmbmonth.setEnabled(true);

        break;
      case 3: //系统管理员权限
        btnshangpin.setEnabled(true);
        btnhuiyuan.setEnabled(true);
        btnguanyu.setEnabled(true);
        tpnjieguo.setEnabled(true);
        btncancel.setEnabled(true);
        btntianjia.setEnabled(true);
        btnsell.setEnabled(true);
        txtid.setEnabled(true);
        lblpv.setText("当前登陆用户：系统管理员");
        txtnumber.setEnabled(true);
        btncan.setEnabled(true);
        chbvip.setEnabled(true);
        btnyingye.setEnabled(true);
        jMenuItem1.setEnabled(true);
        jMenuItem2.setEnabled(true);
        cmbname.setEnabled(true);
        txtspname.setEnabled(true);
        btntong.setEnabled(true);
        btndate.setEnabled(true);
        btnkong.setEnabled(true);
        treeIn.setEnabled(true);
        btnjinhuo.setEnabled(true);
        btnquan.setEnabled(true);
        btncls.setEnabled(true);
        btninto.setEnabled(true);
        btncl.setEnabled(true);
        btnall.setEnabled(true);
        cmbyear.setEnabled(true);
        cmbmonth.setEnabled(true);
        break;
    }
  }

  public void zhuxiao() { //注销
    btnhuiyuan.setEnabled(false);
    btnshangpin.setEnabled(false);
    tpnjieguo.setEnabled(false);
    btncancel.setEnabled(false);
    btntianjia.setEnabled(false);
    btnsell.setEnabled(false);
    txtid.setEnabled(false);
    btnyingye.setEnabled(false);
    txtnumber.setEnabled(false);
    btncan.setEnabled(false);
    chbvip.setEnabled(false);
    jMenuItem1.setEnabled(false);
    jMenuItem2.setEnabled(false);
    pnejinhuo.setEnabled(false);
    pnetotal.setEnabled(false);
    pnesell.setEnabled(false);
    cmbname.setEnabled(false);
    txtspname.setEnabled(false);
    btntong.setEnabled(false);
    btndate.setEnabled(false);
    btnkong.setEnabled(false);
    treeIn.setEnabled(false);
    btnjinhuo.setEnabled(false);
    btnquan.setEnabled(false);
    btncls.setEnabled(false);
    btninto.setEnabled(false);
    btncl.setEnabled(false);
    btnall.setEnabled(false);
    cmbyear.setEnabled(false);
    cmbmonth.setEnabled(false);

  }

  public void year() {
    cmbyear.addItem("2008");
    cmbyear.addItem("2009");
    cmbyear.addItem("2010");
    cmbyear.addItem("2011");
    cmbyear.addItem("2012");
    cmbyear.addItem("2013");
    cmbyear.addItem("2014");
    cmbyear.addItem("2015");
    cmbyear.addItem("2016");
    cmbmonth.addItem("1");
    cmbmonth.addItem("2");
    cmbmonth.addItem("3");
    cmbmonth.addItem("4");
    cmbmonth.addItem("5");
    cmbmonth.addItem("6");
    cmbmonth.addItem("7");
    cmbmonth.addItem("8");
    cmbmonth.addItem("9");
    cmbmonth.addItem("10");
    cmbmonth.addItem("11");
    cmbmonth.addItem("12");

  }

  public void btnexit_actionPerformed(ActionEvent e) { //退出
    if ( (JOptionPane.showConfirmDialog(null, "确认退出?", "确认",
                                        JOptionPane.YES_NO_OPTION)) == 0) {
      System.exit(0); //确认退出
    }
  }

  public void updateTree(Object kind, String name, int pvi) { //对树进行更新

    switch (pvi) {
      case 1: //增加
        DefaultMutableTreeNode root1 = (DefaultMutableTreeNode) treeIn.getModel().
            getRoot();
        for (int i = 0; i < root1.getChildCount(); i++) {
          DefaultMutableTreeNode node = (DefaultMutableTreeNode) root1.
              getChildAt(i);
          if (node.getUserObject().equals(kind)) {
            node.add(new DefaultMutableTreeNode(name));
            treeIn.updateUI();
            break;
          }
        }
        break;
      case 2: //删除
        DefaultMutableTreeNode root2 = (DefaultMutableTreeNode) treeIn.getModel().
            getRoot();
        for (int i = 0; i < root2.getChildCount(); i++) {
          DefaultMutableTreeNode node = (DefaultMutableTreeNode) root2.
              getChildAt(i);
          if (node.getUserObject().equals(kind)) {
            for (int j = 0; j < node.getChildCount(); j++) {
              DefaultMutableTreeNode child = (DefaultMutableTreeNode) node.
                  getChildAt(i);
              if (child.getUserObject().equals(name)) {
                child.removeFromParent();
                treeIn.updateUI(); //更新树
                tbljinhuo.updateUI();
                break;
              }
            }
            break;
          }
        }
        break;
      case 3: //更改
        DefaultMutableTreeNode root3 = (DefaultMutableTreeNode) treeIn.getModel().
            getRoot();
        for (int i = 0; i < root3.getChildCount(); i++) {
          DefaultMutableTreeNode node = (DefaultMutableTreeNode) root3.
              getChildAt(i);
          if (node.getUserObject().equals(kind)) {
            for (int j = 0; j < node.getChildCount(); j++) {
              DefaultMutableTreeNode child = (DefaultMutableTreeNode) node.
                  getChildAt(i);
              if (!child.getUserObject().equals(name)) {
                node.insert(child, j);
                treeIn.updateUI(); //更新树
                tbljinhuo.updateUI();
                break;
              }
            }
            break;
          }
        }

    }
  }

  public void treeupdate() {

  }

  public void btnshangpin_actionPerformed(ActionEvent e) { //商品查询
    Select obj = new Select(this);
    // Select obj = new Select();
    obj.setLocation(200, 150);
    obj.show();
    //treeIn.remove(root);
    // treeIn = new JTree(tree());//对树进行更新,重新加载树

    //treeIn.updateUI();
  }

  public DefaultMutableTreeNode tree() { //从库中把商品 类别及商品加到树上
    String sql = "";
    Link lk = new Link();
    lk.connection();
    sql = "select kindsname from kinds"; //取出所有类别名
    ResultSet rs = lk.Select(sql);
    DefaultMutableTreeNode root = new DefaultMutableTreeNode("进货管理"); //树根节点
    try {
      while (rs.next()) {
        String str = rs.getString(1).trim();
        DefaultMutableTreeNode node1 = new DefaultMutableTreeNode(str);
        String sql1 = "select name from shopping where kindname='" +
            str + "'";
        //System.out.println(sql1);
        Link ln = new Link();
        ln.connection();
        ResultSet rt = ln.Select(sql1);
        while (rt.next()) {
          DefaultMutableTreeNode node2 = new DefaultMutableTreeNode(rt.
              getString(1));
          node1.add(node2);
        }
        rt.close();
        ln.close();
        root.add(node1); //将类别名添加到树中
      }
    }
    catch (SQLException ex) {
    }
    try {
      rs.close();
    }
    catch (SQLException ex1) {
    }
    lk.close();
    return root;
  }

  public void btnguanyu_actionPerformed(ActionEvent e) { //关于我们
    Dialog1 dl = new Dialog1();
    dl.setLocation(300, 150);
    dl.setSize(400, 330);
    dl.show();
    dl.setModal(true);
  }

  public void btnhuiyuan_actionPerformed(ActionEvent e) { //会员管理
    VipFrm vf = new VipFrm();
    vf.setLocation(200, 150);
    vf.show();
  }

  public void jButton2_actionPerformed(ActionEvent e) {
    //清空表中数据
    if (vt.size() == 0) {
      return;
    }
    if (JOptionPane.showConfirmDialog(null, "是否清空表中数据", "提示",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      // shopping = "";
      vt.removeAllElements(); //清空所存商品数据
      tblsp.updateUI();
    }
  }

  public void clear() {
    //清空表中数据
    vt.removeAllElements();
    tblsp.updateUI();
  }

  public void btntianjia_actionPerformed(ActionEvent e) { //将要出售的商品添加到表中

    String id = txtid.getText().trim(); //获取商品名
    int num = 0; //存商品个数
    String tatol = txtnumber.getText(); //将商品个数放如表中
    if (id.equals("")) {
      JOptionPane.showMessageDialog(null, "请输入商品编号", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    try {
      num = Integer.parseInt(txtnumber.getText()); //获取商品个数
    }
    catch (Exception ex) {
      JOptionPane.showMessageDialog(null, "请正确填写商品个数", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    String sql = "select * from shopping where id='" + id + "'";
    Link lk = new Link();
    lk.connection();
    ResultSet rs = lk.Select(sql);
    try {
      if (rs.next()) {
        int geshu = Integer.parseInt(rs.getString(5));
        if (geshu < num) { //判断库存是否小于商品个数
          JOptionPane.showMessageDialog(null, "库存量不足,请联系仓库管理员", "警告",
                                        JOptionPane.INFORMATION_MESSAGE);
        }
        else {
          do {
            Vector v = new Vector();
            v.removeAllElements();
            v.add(rs.getString(1).trim());
            v.add(rs.getString(2).trim()); //类别
            v.add(rs.getString(3).trim()); //商品名
            v.add(rs.getString(4).trim()); //单价
            v.add(tatol); //商品个数
            v.add(rs.getString(6).trim()); //单位
            v.add(rs.getString(7).trim()); //折扣率
            v.add(rs.getString(8).trim()); //备注
            vt.add(v); //添加数据
          }
          while (rs.next());
          shopping += id + "\n";
          tblsp.updateUI();
          txtid.setText("");
          txtnumber.setText("");
        }
      }
      else {
        JOptionPane.showMessageDialog(null, "没有该商品,请确认商品名是否正确", "错误",
                                      JOptionPane.ERROR_MESSAGE);
      }
    }
    catch (SQLException ex1) {
    }
    lk.close();
    txtnumber.setText("1");

  }

  public void disleibei() { //显示
    Link obj = new Link();
    obj.connection();
    String sql = "select kindsname from kinds";
    ResultSet rs = obj.Select(sql);
    cmbname.removeAllItems(); //清除下拉框中所有的项
    cmbname.addItem("商品类别");
    try {
      while (rs.next()) {
        cmbname.addItem(rs.getString(1));
      }
      rs.close();
      obj.close();
    }
    catch (SQLException ex) {
    }
  }

  public void jButton1_actionPerformed(ActionEvent e) {
    vr.removeAllElements(); //删除表中原有数据
    String name = txtspname.getText().trim();
    String sql = ""; //
    if (name.equals("") && cmbname.getSelectedItem().equals("商品类别")) {
      sql = "select * from sellnote";
    }
    else if (!name.equals("") &&
             cmbname.getSelectedItem().equals("商品类别")) {
      sql = "select * from sellnote where name like'%" + name + "%'";
    }
    else if (name.equals("") &&
             !cmbname.getSelectedItem().equals("商品类别")) {
      sql = "select * from sellnote where kindsname='" +
          cmbname.getSelectedItem() + "'";
    }
    else {
      sql = "select * from sellnote where kindsname='" +
          cmbname.getSelectedItem() + "' and name like'%" + name + "%'";
    }
    Link lk = new Link();
    lk.connection();
    ResultSet rs = lk.Select(sql);
    try {
      if (rs.next()) {
        do {
          Vector v = new Vector();
          v.removeAllElements();
          v.add(rs.getString(1).trim()); //商品编号
          v.add(rs.getString(2).trim()); //类别
          v.add(rs.getString(3).trim()); //商品名
          v.add(rs.getString(4).trim()); //总数
          v.add(rs.getString(5).trim()); //总额
          v.add(rs.getString(6).trim()); //售出时间
          vr.add(v); //添加数据
        }
        while (rs.next());
        tbltotal.updateUI();
      }
      else {
        JOptionPane.showMessageDialog(null, "不存在该商品记录", "",
                                      JOptionPane.INFORMATION_MESSAGE);
      }

    }
    catch (SQLException ex1) {
    }
    try {
      rs.close();
    }
    catch (SQLException ex) {
    }
    lk.close();
  }

  public void btnsell_actionPerformed(ActionEvent e) { //销售表中商品
    if (vt.size() == 0) {
      JOptionPane.showMessageDialog(null, "表中无任何数据!", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    String shopping = ""; //用于存所售出的商品名
    String sql = ""; //用于存SQL语句
    float vipzhek = 10; //用于存会员折扣率
    float price = 0; //用于存总额
    boolean fl = false; //判断是否是会员
    float mo = 0; //用于存单件商品的总额
    Link lk = new Link();
    lk.connection();
    ResultSet rs = null;
    if (chbvip.isSelected()) { //如果是会员,判断会员等级
      rs = lk.Select("select grade from vip where cardid='" +
                     txtvipid.getText().trim() + "'");
      try {
        if (rs.next()) {
          fl = true;
          if (rs.getInt(1) == 1) {
            vipzhek = 9.5f;
          }
          else {
            vipzhek = 9.0f;
          }
        }
        else {
          JOptionPane.showMessageDialog(null, "该会员号不存在，请核实再查询！", "错误",
                                        JOptionPane.ERROR_MESSAGE);
          rs.close();
          lk.close();
          return;
        }
      }
      catch (SQLException ex1) {
      }
    }
    for (int i = 0; i < vt.size(); i++) {
      int sum = 0; //用于剩余库存量
      float danjia = 0; //用于存单价
      float zhek = 10; //用于存折扣率
      int su = 0; //售出数量
      Vector tmep = (Vector) vt.get(i); //把表中的每一行都存在一个数组中

      //查询原有库存
      sql = "select price,total,abate from shopping where id='" +