mainfrm.java

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

      // 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);
           treeChanged();
            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();
    lk.connection();
    sql = "select * from jinhuo where times like '" + yr + "-" + mn + "%'";
    ResultSet rs = lk.Select(sql);
    tblinto.updateUI();
    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()); //进货时间
          vc.add(v);
        }
        while (rs.next());
        tblinto.updateUI();
      }
      else {
        JOptionPane.showMessageDialog(null, "没有记录");
      }
    }
    catch (SQLException ex) {
    }
    lk.close();
  }

  public void btncls_actionPerformed(ActionEvent e) {
    if (vc.size() == 0) {
      return;
    }
    if (JOptionPane.showConfirmDialog(null, "确认清空？", "提示",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      vc.removeAllElements(); //清空表中数据
      tblinto.updateUI();
    }
  }

  public void btnall_actionPerformed(ActionEvent e) { //显示全部
    vc.removeAllElements();

    String sql = "";
    Link lk = new Link();
    lk.connection();
    sql = "select * from jinhuo";
    ResultSet rs = lk.Select(sql);
    tblinto.updateUI();
    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()); //进货时间
          vc.add(v);
        }
        while (rs.next());
        tblinto.updateUI();
      }
      else {
        JOptionPane.showMessageDialog(null, "没有记录");
      }
    }
    catch (SQLException ex) {
    }
    lk.close();
  }

  public void btnyingye_actionPerformed(ActionEvent e) { //弹出统计框
    Taking tk = new Taking();
    tk.setSize(300, 250);
    tk.setLocation(300, 250);
    tk.show();
  }

  public void jMenuItem6_actionPerformed(ActionEvent e) {
Deluser dr=new Deluser();
    dr.setLocation(300,250);
    dr.setSize(360,290);
    dr.show();
  }

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

class MainFrm_jMenuItem6_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;
  MainFrm_jMenuItem6_actionAdapter(MainFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem6_actionPerformed(e);
  }
}

class MainFrm_btnyingye_actionAdapter
    implements ActionListener {
  private MainFrm adaptee;