update.java~96~

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

package supermarket;
import DB.*;
import javax.swing.*;
import javax.swing.JOptionPane;
import java.awt.Color;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.Vector;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;

public class Update
    extends JDialog {

  JLabel lblname = new JLabel();
  JComboBox cmbleibie = new JComboBox();
  JTextField txtname = new JTextField();
  JLabel lbljiege = new JLabel();
  JTextField txtprice = new JTextField();
  JLabel lblkucun = new JLabel();
  JTextField txtkucun = new JTextField();
  JLabel lblzhekou = new JLabel();
  JTextField txtzhekou = new JTextField();
  JLabel lblbeizhu = new JLabel();
  JTextArea taxbeizhu = new JTextArea();
  JButton btngengai = new JButton();
  JButton btnhuanhui = new JButton();
  Vector vt = new Vector();
  int count = 0;
  JLabel lbldanwei = new JLabel();
  JTextField txtdanwei = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField txtid = new JTextField();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JLabel jLabel9 = new JLabel();
  public Update() {

    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.getContentPane().setBackground(new Color(212, 208, 200));
    this.setTitle("商品修改");
    this.getContentPane().setLayout(null);
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setText("商品名");
    lblname.setBounds(new Rectangle(22, 54, 71, 33));
    cmbleibie.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbleibie.setBounds(new Rectangle(247, 57, 109, 29));
    cmbleibie.addKeyListener(new Update_cmbleibie_keyAdapter(this));
    cmbleibie.addActionListener(new Update_cmbleibie_actionAdapter(this));
    //    cmbleibie.addActionListener(new Update_cmbleibie_actionAdapter(this));
    cmbleibie.addMouseListener(new Update_cmbleibie_mouseAdapter(this));
    txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtname.setEditable(true);
    txtname.setText("");
    txtname.setBounds(new Rectangle(95, 58, 91, 29));
    lbljiege.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lbljiege.setText("价格/元");
    lbljiege.setBounds(new Rectangle(23, 98, 66, 32));
    txtprice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtprice.setText("");
    txtprice.setBounds(new Rectangle(95, 100, 91, 29));
    txtprice.addKeyListener(new Update_txtprice_keyAdapter(this));
    lblkucun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblkucun.setText("库存量");
    lblkucun.setBounds(new Rectangle(20, 138, 66, 31));
    txtkucun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtkucun.setText("");
    txtkucun.setBounds(new Rectangle(95, 139, 91, 29));
    txtkucun.addKeyListener(new Update_txtkucun_keyAdapter(this));
    lblzhekou.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblzhekou.setText("折扣率/折");
    lblzhekou.setBounds(new Rectangle(206, 98, 82, 32));
    txtzhekou.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtzhekou.setText("");
    txtzhekou.setBounds(new Rectangle(299, 100, 59, 29));
    txtzhekou.addKeyListener(new Update_txtzhekou_keyAdapter(this));
    lblbeizhu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblbeizhu.setText("备注");
    lblbeizhu.setBounds(new Rectangle(23, 175, 55, 30));
    taxbeizhu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    taxbeizhu.setText("");
    taxbeizhu.setBounds(new Rectangle(19, 211, 345, 67));
    taxbeizhu.addKeyListener(new Update_taxbeizhu_keyAdapter(this));
    btngengai.setBounds(new Rectangle(76, 289, 91, 33));
    btngengai.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btngengai.setText("修改");
    btngengai.addActionListener(new Update_btngengai_actionAdapter(this));
    btnhuanhui.setBounds(new Rectangle(213, 289, 91, 33));
    btnhuanhui.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnhuanhui.setText("返回");
    btnhuanhui.addActionListener(new Update_btnhuanhui_actionAdapter(this));
    lbldanwei.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lbldanwei.setText("单位");
    lbldanwei.setBounds(new Rectangle(206, 143, 46, 20));
    txtdanwei.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtdanwei.setText("");
    txtdanwei.setBounds(new Rectangle(299, 139, 59, 29));
    txtdanwei.addKeyListener(new Update_txtdanwei_keyAdapter(this));
    jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel2.setText("商品编号");
    jLabel2.setBounds(new Rectangle(23, 20, 90, 23));
    txtid.setEnabled(false);
    txtid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtid.setBounds(new Rectangle(110, 19, 76, 25));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(13, 13, 369, 276));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(13, 285, 368, 39));
    jLabel1.setForeground(Color.red);
    jLabel1.setText("*");
    jLabel1.setBounds(new Rectangle(177, 6, 20, 23));
    jLabel3.setForeground(Color.red);
    jLabel3.setText("*");
    jLabel3.setBounds(new Rectangle(177, 46, 20, 23));
    jLabel4.setForeground(Color.red);
    jLabel4.setText("*");
    jLabel4.setBounds(new Rectangle(177, 89, 20, 23));
    jLabel5.setForeground(Color.red);
    jLabel5.setText("*");
    jLabel5.setBounds(new Rectangle(178, 126, 20, 23));
    jLabel6.setForeground(Color.red);
    jLabel6.setText("*");
    jLabel6.setBounds(new Rectangle(348, 91, 43, 26));
    jLabel7.setForeground(Color.red);
    jLabel7.setText("*");
    jLabel7.setBounds(new Rectangle(345, 128, 51, 23));
    jLabel8.setForeground(Color.red);
    jLabel8.setText("*");
    jLabel8.setBounds(new Rectangle(343, 47, 29, 23));
    jLabel9.setForeground(Color.red);
    jLabel9.setText("带星号为必填项");
    jLabel9.setBounds(new Rectangle(208, 11, 156, 23));
    this.getContentPane().add(lblname);
    this.getContentPane().add(lbljiege);
    this.getContentPane().add(lblzhekou);
    this.getContentPane().add(jLabel2);
    this.getContentPane().add(txtid);
    this.getContentPane().add(txtzhekou);
    this.getContentPane().add(txtprice);
    this.getContentPane().add(txtname);
    this.getContentPane().add(lbldanwei);
    this.getContentPane().add(lblkucun);
    this.getContentPane().add(txtkucun);
    this.getContentPane().add(txtdanwei);
    this.getContentPane().add(lblbeizhu);
    this.getContentPane().add(taxbeizhu);
    this.getContentPane().add(cmbleibie);
    jPanel1.add(jLabel1);
    jPanel1.add(jLabel3);
    jPanel1.add(jLabel4);
    jPanel1.add(jLabel5);
    jPanel1.add(jLabel8);
    jPanel1.add(jLabel7);
    jPanel1.add(jLabel6);
    jPanel1.add(jLabel9);
    this.getContentPane().add(btngengai);
    this.getContentPane().add(btnhuanhui);
    this.getContentPane().add(jPanel2);
    this.getContentPane().add(jPanel1);
    this.setModal(true);
    txtid.setHorizontalAlignment(JTextField.RIGHT); //文本居右显示
    //从右边输入
    txtname.setHorizontalAlignment(JTextField.RIGHT);
    txtzhekou.setHorizontalAlignment(JTextField.RIGHT);
    txtprice.setHorizontalAlignment(JTextField.RIGHT);
    txtkucun.setHorizontalAlignment(JTextField.RIGHT);
    txtdanwei.setHorizontalAlignment(JTextField.RIGHT);
    disleibei(); //显示下拉框
  }

  public void Update(Vector vt, int count) {
    this.vt = vt;
    this.count = count; //当哪一行被选中后取出表中这个列的所有值
    Vector tmpe = (Vector) vt.get(count);
//    int fl=0;
//    for(int i=0;;i++){
//    if(cmbleibie.getSelectedIndex(i)==)
//    }
    // txtid.setText(temp.get());
    txtid.setText(tmpe.get(0).toString());
    cmbleibie.setSelectedItem(tmpe.get(1));
    txtname.setText(tmpe.get(2).toString()); //商品名
    txtprice.setText(tmpe.get(3).toString()); //价格
    txtkucun.setText(tmpe.get(4).toString()); //库存量
    txtdanwei.setText(tmpe.get(5).toString()); //单位
    txtzhekou.setText(tmpe.get(6).toString()); //折扣率
    taxbeizhu.setText(tmpe.get(7).toString()); //备注
  }

  public void btnhuanhui_actionPerformed(ActionEvent e) { //返回
    this.dispose();
  }

  public void disleibei() { //显示
    Link obj = new Link();
    obj.connection();
    String sql = "select kindsname from kinds";
    ResultSet rs = obj.Select(sql);
//    vt.removeAllElements();//清理表里原有的数据
//    Vector v=new Vector();
    cmbleibie.addItem("商品类别");
    cmbleibie.removeAllItems();
    cmbleibie.addItem("商品类别");
    try {
      while (rs.next()) {
        cmbleibie.addItem(rs.getString(1));
      }
      rs.close();
      obj.close();
    }
    catch (SQLException ex) {
//      JOptionPane.showMessageDialog(null,"Game Over");
    }
//  vt.add(v);//添加数据
//  tbljieguo.updateUI();//更新表
  }

  public void btngengai_actionPerformed(ActionEvent e) { //修改
    //验证
    if (txtkucun.getText().trim().equals("") ||
        txtprice.getText().trim().equals("") ||
        txtdanwei.getText().trim().equals("") ||
        txtid.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "信息输入不完整，请认真核实!", "错误",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    if (cmbleibie.getSelectedItem().equals("商品类别")) { //判断类别是否被选种
      JOptionPane.showMessageDialog(null, "请选择商品类别", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;