mainfrm.java~668~

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

          tmep.get(0) + "'";
      rs = lk.Select(sql);
      //更新库存
      try {
        if (rs.next()) { //减去售出的数量
          danjia = rs.getFloat(1);
          su = Integer.parseInt(tmep.get(4).toString());
          sum = rs.getInt(2) - su; //剩余库存量
          zhek = rs.getFloat(3); //取出折扣
          //  System.out.println("su=" + su + " sum=" + sum + " zhek=" + zhek);
          if (fl) {
            mo = vipzhek * su * danjia * zhek * 0.01f;
          }
          else {
            mo = danjia * zhek * 0.1f * su;
          }
          price += mo; //累计总额
        }
      }
      catch (NumberFormatException ex) {
        System.out.println("整形数据转换出错！");
      }
      catch (SQLException ex) {
      } //取得当前时间
      Calendar date = Calendar.getInstance(); //获取一个日历
      t = new Date();
      String temp = t.toString().substring(11,
                                           (t.toString().length() - 4));
      temp = temp.substring(0, 8);
      date.get(Calendar.MINUTE);
      date.get(Calendar.SECOND);
      String time = date.get(Calendar.YEAR) + "-" +
          (date.get(Calendar.MONTH) + 1)
          + "-" + date.get(Calendar.DATE) + " " + temp;
      sql = "update shopping set total=" + sum + " where id='" +
          tmep.get(0).toString() + "'";
      int count = 0;
      count = lk.Update(sql); //更新库存
      if (count <= 0) {
        JOptionPane.showMessageDialog(null, "更新库存出错了!", "错误",
                                      JOptionPane.ERROR_MESSAGE);
        lk.close();
        return;
      }

      sql = "insert into sellnote values('" + tmep.get(0) + "','" +
          tmep.get(1) + "','" + tmep.get(2) + "'," + tmep.get(4) +
          "," + mo + ",'" + time + "')";
      count = 0;
      count = lk.Update(sql); //插入销售记录

      if (count <= 0) {
        JOptionPane.showMessageDialog(null, "无法更新销售记录!", "错误",
                                      JOptionPane.ERROR_MESSAGE);
        lk.close();
        return;
      }
      shopping += "商品名：" + tmep.get(2) + "\n商品数量：" + su + "\n商品折扣率：" +
          zhek +
          "折\n"; //将出售信息存在一个字符串中，便于打印清单
    }
    System.out.println(price);
    if (fl) {
      sql = "update vip set integral=integral+" + (int) price +
          " where cardid='" + //更新会员积分
          txtvipid.getText().trim() + "'"; //每次消费增加积分
      int count = 0;
      count = lk.Update(sql);
      if (count <= 0) {
        JOptionPane.showMessageDialog(null, "会员积分出错了!", "错误",
                                      JOptionPane.ERROR_MESSAGE);
        lk.close();
        return;
      }
      lk.Update("update vip set grade=2 where integral>=1000"); //当会员积分大于等于1000分时自动提升等级
      try {
        if (rs.next()) {

        }
      }
      catch (SQLException ex3) {
      }
    }
    try {
      rs.close();
    }
    catch (SQLException ex2) {
    }
    lk.close();
    System.out.println(price + "   " + mo);
    Checkout ct = new Checkout(shopping, fl, vipzhek, price, this);
    ct.setSize(450, 420);
    ct.setLocation(300, 200);
    ct.show();
    txtvipid.setText("");
//    this.clear();//清空表中的数据
  }

  public void txtnumber_keyPressed(KeyEvent e) { //单击回车触发添加
    if ( (int) e.getKeyChar() == 10) {
      btntianjia_actionPerformed(null);
    }
  }

  public void txtname_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      btntianjia_actionPerformed(null);
    }
  }

  public void txtspname_keyPressed(KeyEvent e) {
    if ( (int) e.getKeyChar() == 10) {
      jButton1_actionPerformed(null);
    }
  }

  public void btncan_actionPerformed(ActionEvent e) { //删除表中的要销售商品的记录
    int count = tblsp.getSelectedRow();
    if (vt.size() == 0) {
      JOptionPane.showMessageDialog(null, "表中无任何数据!", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    if (count < 0) {
      JOptionPane.showMessageDialog(null, "请选择要删除的商品", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }

    String str = (String) tblsp.getValueAt(count, 1);
    if (JOptionPane.showConfirmDialog(null, "确认删除?", "确认",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      vt.remove(count); //删除表中的数据
      tblsp.updateUI(); //更新表
    }
  }

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

  public void jMenuItem1_actionPerformed(ActionEvent e) { //添加用户
    UserAdd ua = new UserAdd();
    ua.setSize(400, 330);
    ua.setLocation(300, 250);
    ua.show();
  }

  public void jMenuItem2_actionPerformed(ActionEvent e) { //登陆窗口
    LandFrm lf = new LandFrm(this);
    lf.setLocation(300, 250);
    lf.show();
  }

  public void chbvip_mouseClicked(MouseEvent e) {
    if (chbvip.isSelected()) {
      txtvipid.setEnabled(true);
    }
    else {
      txtvipid.setEnabled(false);
    }
  }

  public void jMenuItem4_actionPerformed(ActionEvent e) { //计算器
    try {
      Runtime.getRuntime().exec("calc"); //调用计算器
    }
    catch (IOException ex) {
    }
  }

  public void jMenuItem9_actionPerformed(ActionEvent e) { //计算器
    try {
      Runtime.getRuntime().exec("notepad"); //调用记事本
    }
    catch (IOException ex) {
    }
  }

  public void jMenuItem11_actionPerformed(ActionEvent e) { //帮助提示
    Help help = new Help();
    help.setSize(450, 450);
    help.setLocation(300, 250);
    help.show();
  }

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

  public void btndate_actionPerformed(ActionEvent e) { //每日统计
    vr.removeAllElements();
    tbltotal.updateUI(); //清空表
    String name = txtspname.getText().trim();
    String sql;
    String day = "";
    Calendar cr;
    cr = Calendar.getInstance();
    int year = cr.get(Calendar.YEAR);
    int month = cr.get(Calendar.MONTH) + 1;
    int date = cr.get(Calendar.DATE);
    day = year + "-" + month + "-" + date + ""; //获取当前日期
    if (name.equals("") && cmbname.getSelectedItem().equals("商品类别")) {
      sql = "select * from sellnote where times like '%" + day + "%'";
    }
    else if (!name.equals("") &&
             cmbname.getSelectedItem().equals("商品类别")) {
      sql = "select * from sellnote where times like '%" + day +
          "%' and name like'%" + name + "%'";
    }
    else if (name.equals("") &&
             !cmbname.getSelectedItem().equals("商品类别")) {
      sql = "select * from sellnote where times like '%" + day +
          "%' and kindsname='" +
          cmbname.getSelectedItem() + "'";
    }
    else {
      sql = "select * from sellnote where times like '%" + day +
          "%' and kindsname='" +
          cmbname.getSelectedItem() + "' and name like'%" + name + "%'";
    }

    // sql = "select * from sellnote where times like '%" + day +"%'";
    // System.out.print(sql);

    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());
        tbljinhuo.updateUI(); //更新表
      }
      else {
        JOptionPane.showMessageDialog(null, "不存在纪录", "提示",
                                      JOptionPane.INFORMATION_MESSAGE);
      }
      rs.close();
      lk.close();
    }
    catch (SQLException ex) {
    }

    //lk.close();
  }

  public void treeChanged() {
    ve.removeAllElements();
    //System.out.println("够了");
    tbljinhuo.updateUI();
    String sql = ""; //存SQL语句
    try {
      DefaultMutableTreeNode node = (DefaultMutableTreeNode) treeIn.
          getLastSelectedPathComponent(); //用于确定当前选定节点
      String nodeInfo = node.getUserObject().toString().trim(); //用于存选定的接点名称
      if (node.isLeaf()) { //判断是否选中商品
        sql = "select * from shopping where name='" + nodeInfo + "'";
      }
      else { //判断选定的类
        sql = "select * from shopping where kindname='" + nodeInfo +
            "'";
      }
      if (nodeInfo.equals("进货管理")) { //未选中商品则进行模糊查询
        sql = "select * from shopping  order by kindname";
      }
    }
    catch (Exception ex) {

    }
    Link lk = new Link();
    lk.connection();
    //System.out.print(sql);
    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()); //单位
          v.add(rs.getString(8).trim()); //备注
          ve.add(v); //添加数据
        }
        while (rs.next());
        tbljinhuo.updateUI();
      }
    }
    catch (SQLException ex1) {
    }
    lk.close();

  }

  public void treeIn_valueChanged(TreeSelectionEvent e) {
    DefaultMutableTreeNode node = (DefaultMutableTreeNode) treeIn.
        getLastSelectedPathComponent();
    if (node == null) { //判断是否选种节点
      return;
    }
    else {
      treeChanged(); //调用树方法
    }
  }

  public void btnquan_actionPerformed(ActionEvent e) { //进货显示所有
    ve.removeAllElements(); //清空数组原有数据
    tbljinhuo.updateUI(); //更新表
    String sql = "select * from shopping order by kindname"; //存SQL语句
    Link lk = new Link();
    lk.connection();
    System.out.print(sql);
    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()); //单位
          v.add(rs.getString(8).trim()); //备注
          ve.add(v); //添加数据
        }
        while (rs.next());
        tbljinhuo.updateUI();
      }
    }
    catch (SQLException ex1) {
    }
    lk.close();
  }

  public void btnjinhuo_actionPerformed(ActionEvent e) { //未完成
    int count = tbljinhuo.getSelectedRow();
    String id = "";
    String num = "";
    int sum; //存输入的库存
    if (count >= 0) { //判断是否被选中
      Calendar date = Calendar.getInstance(); //获取一个日历
      t = new Date();
      String te = t.toString().substring(11, (t.toString().length() - 4));
      te = te.substring(0, 8);
      date.get(Calendar.MINUTE);
      date.get(Calendar.SECOND);
      String time = date.get(Calendar.YEAR) + "-" +
          (date.get(Calendar.MONTH) + 1)
          + "-" + date.get(Calendar.DATE) + " " + te;

      Vector temp = (Vector) ve.get(count);
      id = temp.get(0).toString().trim();
      String sql = "select total from shopping where id='" + id + "'";
      num = JOptionPane.showInputDialog(null, "请输入需要进货的数量");
      if (num.toString().equals("")) { //判断输入是否为空
        return;
      }
      try {
        sum = Integer.parseInt(num);
      }
      catch (Exception ex) {
        JOptionPane.showMessageDialog(null, "请输入整数");
        return;
      }
      Link lk = new Link();
      lk.connection();
      ResultSet rs = lk.Select(sql); //用于将现有的库存量查询出来
      try {
        if (rs.next()) {
          int to = Integer.parseInt(rs.getString(1).trim());
          sum += to;
          sql = "update shopping set total=" + sum + " where id='" + id +
              "'";
          int ao = lk.Update(sql);
          if (ao > 0) {
            sql = "insert into jinhuo values('" + temp.get(1) + "','" +
                temp.get(2) + "','" + num + "','" + time + "')";
            lk.Update(sql);
            JOptionPane.showMessageDialog(null, "库存添加完成！", "成功",
                                          JOptionPane.
                                          INFORMATION_MESSAGE);
            tbljinhuo.updateUI(); //更新表
          }
          else {
            JOptionPane.showMessageDialog(null, "添加库存失败！", "错误",
                                          JOptionPane.ERROR_MESSAGE);
            rs.close();
            lk.close();
            return;
          }
        }
      }
      catch (SQLException ex1) {
      }
      catch (NumberFormatException ex1) {
      }
      try {
        rs.close();
      }
      catch (SQLException ex2) {
      }
      lk.close();
    }
    else {
      JOptionPane.showMessageDialog(null, "请在表中选择需要进货的商品", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
  }

  public void btncl_actionPerformed(ActionEvent e) { //清空进货管理表中的数据
    if (ve.size() == 0) {
      return;
    }
    if (JOptionPane.showConfirmDialog(null, "确认清空？", "提示",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      ve.removeAllElements(); //清空表中数据
      tbljinhuo.updateUI();
    }
  }

  public void btninto_actionPerformed(ActionEvent e) { //根据条件进货明细表
    vc.removeAllElements();
    String yr = null;
    String mn = null;
    yr = cmbyear.getSelectedItem().toString();
    mn = cmbmonth.getSelectedItem().toString();
    String sql = "";
    Link lk = new Link();