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();
  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("價(jià)格/元");
    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("庫(kù)存量");
    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("商品編號(hào)");
    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, 12, 368, 276));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(13, 285, 368, 39));
    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);
    this.getContentPane().add(jPanel1);
    this.getContentPane().add(btngengai);
    this.getContentPane().add(btnhuanhui);
    this.getContentPane().add(jPanel2);
    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; //當(dāng)哪一行被選中后取出表中這個(gè)列的所有值
    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()); //價(jià)格
    txtkucun.setText(tmpe.get(4).toString()); //庫(kù)存量
    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();//清理表里原有的數(shù)據(jù)
//    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);//添加數(shù)據(jù)
//  tbljieguo.updateUI();//更新表
  }

  public void btngengai_actionPerformed(ActionEvent e) { //修改
    //驗(yàn)證
    if (txtkucun.getText().trim().equals("") ||
        txtprice.getText().trim().equals("") ||
        txtdanwei.getText().trim().equals("") ||
        txtid.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "信息輸入不完整，請(qǐng)認(rèn)真核實(shí)!", "錯(cuò)誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    if (cmbleibie.getSelectedItem().equals("商品類別")) { //判斷類別是否被選種
      JOptionPane.showMessageDialog(null, "請(qǐng)選擇商品類別", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
    Link lk = new Link();
    lk.connection();
    String sql = "update shopping set kindname='" +

        cmbleibie.getSelectedItem().toString() +
        "',name='" + txtname.getText() + "',price=" + txtprice.getText() +
        ",total=" + txtkucun.getText() + ",abate=" + txtzhekou.getText() +
        ",danwei='" + txtdanwei.getText().trim() + "',beizhu='" +
        taxbeizhu.getText() + "' where id='" + txtid.getText() +
        "'";

    //此方法返回0則為確認(rèn),1則為取消
//    if (JOptionPane.showConfirmDialog(null, "確認(rèn)修改?", "確認(rèn)",
//                                      JOptionPane.YES_NO_OPTION) == 0) {
      int count = lk.Update(sql);
      if (count > 0) {
//        JOptionPane.showMessageDialog(null, "更新成功!", "成功",
//                                      JOptionPane.INFORMATION_MESSAGE);
      lk.close();
      this.dispose();