goodsadd.java~58~

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

        txtname.getText().trim().equals("") ||
        txtkucun.getText().trim().equals("") ||
        txtprice.getText().trim().equals("") ||
        txtdanwei.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "信息输入不完整，请认真核实!", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }

    if (cmbleibie.getSelectedItem().equals("商品类别")) {
      JOptionPane.showMessageDialog(null, "请选择商品类别!", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    String id = txtid.getText().trim(); //存商品编号
    int kucun = Integer.parseInt(txtkucun.getText().trim()); //存库存量
    Link lk = new Link();
    lk.connection();
    String sql = "select * from shopping where id='" + id + "'";
    ResultSet rs = lk.Select(sql);
    try {
      if (rs.next()) { //判断商品编号是否重复
        /* JOptionPane.showMessageDialog(null, "该商品编号已经存在，请重新输入！", "错误",
                                       JOptionPane.ERROR_MESSAGE);*/
        kucun += Integer.parseInt(rs.getString(5));
        //判断该商品是否已经存在
        if (rs.getString(1).trim().equals(cmbleibie.getSelectedItem().toString()) &&
            rs.getString(2).trim().equals(txtname.getText().trim())) {
          sql = "update shopping set total='" + kucun + "' where id='" + id +
              "'";
        }
        else {
          JOptionPane.showMessageDialog(null, "该商品编号已经存在,请重新输入!", "错误",
                                        JOptionPane.ERROR_MESSAGE);//错误提示
          rs.close();
          lk.close();
          return;
        }
        int it = lk.Update(sql);
        if (it > 0) {
          JOptionPane.showMessageDialog(null, "库存更新成功");

          txtid.setText("");
          txtname.setText("");
          txtkucun.setText("");
          txtprice.setText("");
          txtdanwei.setText("");
          txtbeizhu.setText("");

        }
        rs.close();
        lk.close();
        return;

      }
    }
    catch (SQLException ex) {
    }
    sql = "insert into shopping values(" + txtid.getText() + ",'" +
        cmbleibie.getSelectedItem() +
        "','" + txtname.getText() + "'," + txtprice.getText() + "," +
        txtkucun.getText() + ",'" + txtdanwei.getText() + "'," +
        txtzhekou.getText() + ",'" + txtbeizhu.getText() + "')";
    int re = lk.Update(sql);
    if (re > 0) {
      //添加成功,将所有文本框清空
      JOptionPane.showMessageDialog(null, "添加成功");
      //更新树,传商品类别和名称
 //         frm.updateTree(cmbleibie.getSelectedItem(),txtname.getText());
      txtid.setText("");
      txtname.setText("");
      txtprice.setText("");
      txtkucun.setText("");
      txtdanwei.setText("");
      txtbeizhu.setText("");
    }
    lk.close();
  }

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

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

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

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

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

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

}

class goodsAdd_txtbeizhu_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtbeizhu_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtbeizhu_keyPressed(e);
  }
}

class goodsAdd_txtzhekou_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtzhekou_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtzhekou_keyPressed(e);
  }
}

class goodsAdd_txtdanwei_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtdanwei_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {

    adaptee.txtdanwei_keyPressed(e);
  }
}

class goodsAdd_txtkucun_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtkucun_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtkucun_keyPressed(e);
  }
}

class goodsAdd_txtprice_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtprice_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtprice_keyPressed(e);
  }
}

class goodsAdd_cmbleibie_actionAdapter
    implements ActionListener {
  private goodsAdd adaptee;
  goodsAdd_cmbleibie_actionAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {

  }
}

class goodsAdd_jButton1_actionAdapter
    implements ActionListener {
  private goodsAdd adaptee;
  goodsAdd_jButton1_actionAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class goodsAdd_btntijiao_actionAdapter
    implements ActionListener {
  private goodsAdd adaptee;
  goodsAdd_btntijiao_actionAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

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

class goodsAdd_txtname_keyAdapter
    extends KeyAdapter {
  private goodsAdd adaptee;
  goodsAdd_txtname_keyAdapter(goodsAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtname_keyPressed(e);
  }
}