package supermarket;
import DB.*;
import javax.swing.*;
import java.awt.Color;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import javax.swing.border.Border;
import javax.swing.border.TitledBorder;

public class goodsAdd
    extends JDialog {
 // Select st;//存Select 對象,用于更新表
  JLabel lblname = new JLabel();
  JTextField txtname = new JTextField();
  JComboBox cmbleibie = new JComboBox();
  JLabel lblkucun = new JLabel();
  JTextField txtkucun = new JTextField();
  JButton btntijiao = new JButton();
  JButton btnhuanhui = new JButton();
  JLabel lblzhekou = new JLabel();
  JTextField txtzhekou = new JTextField();
  JLabel jLabel1 = new JLabel();
  JTextArea txtbeizhu = new JTextArea();
  JLabel lblprice = new JLabel();
  JTextField txtprice = new JTextField();
  JLabel lbldanwei = new JLabel();
  JTextField txtdanwei = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField txtid = new JTextField();
  JPanel jPanel1 = new JPanel();
  Border border1 = BorderFactory.createEtchedBorder(Color.white,
      new Color(148, 145, 140));
  Border border2 = new TitledBorder(border1, "添加商品");
  JPanel jPanel2 = new JPanel();
  MainFrm frm= null;
  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();
  JLabel jLabel10 = new JLabel();
  public goodsAdd(MainFrm frm) {
    try {
      this.frm = frm;
      jbInit();
      disleibei();
//      cmbleibie.addItem("商品類別");
//      cmbleibie.addItem("日用品類");
//      cmbleibie.addItem("飲料類");
//      cmbleibie.addItem("化裝品類");
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  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();//更新表
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    this.getContentPane().setBackground(new Color(212, 208, 200));
    this.setForeground(Color.darkGray);
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setText("商品名");
    lblname.setBounds(new Rectangle(14, 62, 74, 29));
    txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtname.setText("");
    txtname.setBounds(new Rectangle(96, 61, 91, 28));
    txtname.addKeyListener(new goodsAdd_txtname_keyAdapter(this));
    cmbleibie.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    cmbleibie.setBounds(new Rectangle(251, 61, 108, 28));
    cmbleibie.addActionListener(new goodsAdd_cmbleibie_actionAdapter(this));
    lblkucun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtkucun.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtkucun.setEditable(false);
    txtkucun.setText("0");
    txtkucun.setBounds(new Rectangle(97, 144, 90, 28));
    txtkucun.addKeyListener(new goodsAdd_txtkucun_keyAdapter(this));
    btntijiao.setBackground(new Color(212, 255, 207));
    btntijiao.setBounds(new Rectangle(75, 292, 91, 33));
    btntijiao.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntijiao.setText("添加");
    btntijiao.addActionListener(new goodsAdd_btntijiao_actionAdapter(this));
    btnhuanhui.setBackground(new Color(212, 255, 200));
    btnhuanhui.setBounds(new Rectangle(212, 292, 91, 33));
    btnhuanhui.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnhuanhui.setText("返回");
    btnhuanhui.addActionListener(new goodsAdd_jButton1_actionAdapter(this));
    lblzhekou.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblzhekou.setText("折扣率/折");
    lblzhekou.setBounds(new Rectangle(208, 104, 80, 29));
    txtzhekou.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtzhekou.setText("10");
    this.setModal(true);
    txtzhekou.setBounds(new Rectangle(298, 102, 59, 25));
    txtzhekou.addKeyListener(new goodsAdd_txtzhekou_keyAdapter(this));
    lblkucun.setText("庫存量");
    lblkucun.setBounds(new Rectangle(15, 145, 68, 29));
    jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel1.setText("備注");
    jLabel1.setBounds(new Rectangle(17, 181, 68, 30));
    txtbeizhu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtbeizhu.setText("");
    txtbeizhu.setBounds(new Rectangle(15, 217, 351, 65));
    txtbeizhu.addKeyListener(new goodsAdd_txtbeizhu_keyAdapter(this));
    lblprice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblprice.setText("價格/元");
    lblprice.setBounds(new Rectangle(16, 104, 61, 27));
    txtprice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtprice.setText("");
    txtprice.setBounds(new Rectangle(96, 102, 91, 29));
    txtprice.addKeyListener(new goodsAdd_txtprice_keyAdapter(this));
    lbldanwei.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lbldanwei.setText("單位");
    lbldanwei.setBounds(new Rectangle(233, 148, 46, 20));
    txtdanwei.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtdanwei.setText("");
    txtdanwei.setBounds(new Rectangle(298, 147, 59, 25));
    txtdanwei.addKeyListener(new goodsAdd_txtdanwei_keyAdapter(this));
    this.setModal(true);
    this.setTitle("商品添加");
    jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel2.setText("商品編號");
    jLabel2.setBounds(new Rectangle(12, 25, 93, 23));
    txtid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtid.setText("");
    txtid.setBounds(new Rectangle(99, 21, 88, 25));
    jPanel1.setBorder(border2);
    jPanel1.setBounds(new Rectangle( -2, 0, 393, 291));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle( -2, 284, 393, 50));
    jPanel2.setLayout(null);
    jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel3.setForeground(Color.red);
    jLabel3.setText("帶星號的必填");
    jLabel3.setBounds(new Rectangle(244, 19, 135, 33));
    jLabel4.setForeground(Color.red);
    jLabel4.setText("*");
    jLabel4.setBounds(new Rectangle(192, 23, 27, 23));
    jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel5.setForeground(Color.red);
    jLabel5.setText("*");
    jLabel5.setBounds(new Rectangle(195, 65, 28, 23));
    jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jLabel6.setText("折扣率");
    jLabel6.setBounds(new Rectangle(229, 106, 62, 23));
    jLabel7.setForeground(Color.red);
    jLabel7.setText("*");
    jLabel7.setBounds(new Rectangle(191, 109, 34, 23));
    jLabel8.setForeground(Color.red);
    jLabel8.setText("*");
    jLabel8.setBounds(new Rectangle(191, 146, 26, 23));
    jLabel9.setForeground(Color.red);
    jLabel9.setText("*");
    jLabel9.setBounds(new Rectangle(364, 61, 40, 23));
    jLabel10.setForeground(Color.red);
    jLabel10.setText("*");
    jLabel10.setBounds(new Rectangle(361, 149, 60, 23));
    this.getContentPane().add(btnhuanhui);
    this.getContentPane().add(btntijiao);
    this.getContentPane().add(jLabel1); //從右邊輸入
    this.getContentPane().add(lblkucun);
    this.getContentPane().add(txtdanwei);
    this.getContentPane().add(lblname);
    this.getContentPane().add(lblprice);
    this.getContentPane().add(jLabel2);
    this.getContentPane().add(txtzhekou);
    this.getContentPane().add(cmbleibie);
    this.getContentPane().add(txtbeizhu);
    this.getContentPane().add(txtname);
    this.getContentPane().add(txtid);
    this.getContentPane().add(txtprice);
    this.getContentPane().add(txtkucun);
    this.getContentPane().add(jPanel1);
    jPanel1.add(jLabel3);
    jPanel1.add(jLabel4);
    jPanel1.add(jLabel5);
    jPanel1.add(lbldanwei);
    jPanel1.add(jLabel6);
    jPanel1.add(jLabel7);
    jPanel1.add(jLabel8);
    jPanel1.add(jLabel9);
    jPanel1.add(jLabel10);
    this.getContentPane().add(jPanel2); //文本對齊方式
    txtzhekou.setHorizontalAlignment(JTextField.RIGHT);
    txtprice.setHorizontalAlignment(JTextField.RIGHT);
    txtkucun.setHorizontalAlignment(JTextField.RIGHT);
    txtdanwei.setHorizontalAlignment(JTextField.RIGHT);
  }

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

  public void btntijiao_actionPerformed(ActionEvent e) { //商品添加界面

    if (txtid.getText().trim().equals("") ||