jComboBox4.setEnabled(true);
        }
        if(jRadioButton3.isSelected()){
            txtName.setText("");
            txtmath.setText("");
            txtAdd.setText("");
            txt1.setText("");
            txtnum.setText("");
            txtPrice.setText("");
            txtPrice2.setText("");
            txtID.setEditable(false);
            txtName.setEnabled(true);
            txtmath.setEnabled(true);
            txtnum.setEnabled(false);
            txtAdd.setEnabled(true);
            txt1.setEnabled(true);
            txtPrice.setEnabled(true);
            txtPrice2.setEnabled(true);
            txtTime.setEnabled(false);
            jComboBox1.setEnabled(true);
            jComboBox2.setEnabled(true);
            jComboBox3.setEnabled(true);
            jComboBox4.setEnabled(true);


        }
        if(jRadioButton1.isSelected()){
            txtName.setText("");
            txtmath.setText("");
            txtAdd.setText("");
            txtnum.setText("");
            txt1.setText("");
            txtPrice.setText("");
            txtPrice2.setText("");
            txtID.setEditable(true);
            txtName.setEnabled(false);
            txtmath.setEnabled(false);
            txtAdd.setEnabled(false);
            txt1.setEnabled(false);
            txtnum.setEnabled(false);
            txtPrice.setEnabled(false);
            txtPrice2.setEnabled(false);
            txtTime.setEnabled(false);
            jComboBox1.setEnabled(false);
            jComboBox2.setEnabled(false);
            jComboBox3.setEnabled(false);
            jComboBox4.setEnabled(false);
        }
    }
//控制按紐對表內的數據進行增加
    public void jRadioButton2_actionPerformed(ActionEvent e) {
        getTime();
        setButton();
    }

    //控制按紐對表內的數據進行更新
    public void jRadioButton3_actionPerformed(ActionEvent e) {
        getTime();
        setButton();

    }

//控制按紐對表內的數據進行刪除

    public void jRadioButton1_actionPerformed(ActionEvent e) {
        getTime();
        setButton();
    }

    public void jButton10_actionPerformed(ActionEvent e) throws SQLException {
        if (this.jRadioButton2.isSelected()) {
            String id = txtID.getText();                  //珠寶編號
            String name = txtName.getText();             //珠寶名稱
            String math =txtmath.getText();               //總數量
            String num = txtnum.getText();                //售出數量
            String add = txtAdd.getText();                //珠寶產地
            String rest = txt1.getText();                 //珠寶純度
           // int price = Integer.parseInt(txtPrice.getText()) ;          //珠寶遠價
            String price = txtPrice.getText();
            String price2 = txtPrice2.getText();          //珠寶售價
            String txtbox4 = jComboBox4.getSelectedItem().toString();                          //珠寶重量單位
            String time = txtTime.getText();              //珠寶入庫時間
            String txtBox1 = jComboBox1.getSelectedItem().toString();  //珠寶大類
            String txtBox2 = jComboBox2.getSelectedItem().toString();  //珠寶小類
            String txtBox3 = jComboBox3.getSelectedItem().toString();  //首飾

            Aid aid = new Aid();
            Aname aname = new Aname();
//判斷編號語句
            if (id.length() == 0) {
                JOptionPane.showMessageDialog(this, "編號不能為空，請填寫！");
                return;
            } else {
                if (aid.aid(id)) {
                    JOptionPane.showMessageDialog(this, "編號已存在，請重新輸入");
                    return;
                }
            }
//判斷名稱語句
            if (name.length() == 0) {
                JOptionPane.showMessageDialog(this, "珠寶名稱不能為空，請填寫！");
                return;
            } else {
                if (name.length() <= 1) {
                    JOptionPane.showMessageDialog(this, "珠寶名稱輸入錯誤");
                    return;
                }
//判斷產地語句
            }
            if (add.length() == 0) {
                JOptionPane.showMessageDialog(this, "珠寶產地不能為空，請填寫！");
                return;
            }
            //判斷重量語句
            if (rest.length() == 0) {
                JOptionPane.showMessageDialog(this, "物品單位不能為空，請填寫！");
                return;
            }
            //判斷價格語句
            if (price.length() == 0) {
                JOptionPane.showMessageDialog(this, "成本價格不能為空，請填寫！");
                return;
            }else{

                if (!this.objBool(price)) {
                   JOptionPane.showMessageDialog(this, "對不起,成本價格只能輸入阿拉伯數字");
                   return;
               }


            }
            if (price2.length() == 0) {
                JOptionPane.showMessageDialog(this, "銷售價格不能為空，請填寫！");
                return;
            } else {
                if (!this.objBool(price2)) {
                    JOptionPane.showMessageDialog(this, "對不起,銷售價格只能輸入阿拉伯數字");
                    return;
                }
            }
            //判斷單位語句

//導數據庫

            AssetInfo ass = new AssetInfo();
            if (ass.info(id, name,math,num, txtBox2, txtBox1, txtBox3, txtbox4, rest, price,price2,
                         time, add)) {

            }
//在表格打印最新表格
            this.jbInit1();
            txtName.setText("");
            txtID.setText("");
            txtmath.setText("");
            txtAdd.setText("");
            txt1.setText("");
            txtPrice.setText("");
            txtPrice2.setText("");
            txtTime.setText("");
            JOptionPane.showMessageDialog(this, "編號" + id + "成功添加");
            getTime();
        }
//更改數據庫的數據
    if(this.jRadioButton3.isSelected()){
        String id = null;
        String name = null;
        String math = null;
        String num = null;
        String box2 = null;
        String box1 = null;
        String box3 = null;
        String box4 = null;
        String txt2 = null;
        String time = null;
        String price = null;
        String price2 = null;
        String add = null;


        id = this.txtID.getText();
        name = this.txtName.getText();
        math = this.txtmath.getText();
        num = this.txtnum.getText();
        add = this.txtAdd.getText();
        txt2 = this.txt1.getText();
        price = this.txtPrice.getText();
        price2 = this.txtPrice2.getText();
        box4 = this.jComboBox4.getSelectedItem().toString();
        time = this.txtTime.getText();
        box1 = this.jComboBox1.getSelectedItem().toString();
        box2 = this.jComboBox2.getSelectedItem().toString();
        box3 = this.jComboBox3.getSelectedItem().toString();

        Aid aid = new Aid();
         Aname aname = new Aname();
          if (name.length() == 0) {
              JOptionPane.showMessageDialog(this, "珠寶名稱不能為空，請填寫！");
              return;
          } else {
              if (name.length() <= 1) {
                  JOptionPane.showMessageDialog(this, "珠寶名稱輸入錯誤");
                  return;
              }

          }
          if (add.length() == 0) {
              JOptionPane.showMessageDialog(this, "珠寶產地不能為空，請填寫！");
              return;
          }
          if (txt2.length() == 0) {
              JOptionPane.showMessageDialog(this, "物品單位不能為空，請填寫！");
              return;
          }
          if (price.length() == 0) {
              JOptionPane.showMessageDialog(this, "成本價格不能為空，請填寫！");
              return;
          } else {
              if (!this.objBool(price)) {
                  JOptionPane.showMessageDialog(this, "對不起,只能輸入阿拉伯數字");
                  return;
              }
          }

          if (price2.length() == 0) {
              JOptionPane.showMessageDialog(this, "銷售價格不能為空，請填寫！");
              return;
          } else {
              if (!this.objBool(price2)) {
                  JOptionPane.showMessageDialog(this, "對不起,只能輸入阿拉伯數字");
                  return;
              }
          }


          AssetBean ass = new AssetBean();
          AssetAction act = new AssetAction();

        ass.setAid(id);
          ass.setAname(name);ass.setAcount(math);ass.setAnumber(num);ass.setAname(box2);ass.setAbig(box1);ass.setAstyle(box3);ass.setAunit(box4);
          ass.setAheft(txt2);ass.setAdate(time);ass.setAcost(price);ass.setAprice(price2);ass.setAaddress(add);
          if(act.changeSet(ass)){
              JOptionPane.showMessageDialog(this, "修改操作成功！");
          }else{
              JOptionPane.showMessageDialog(this, "修改操作失敗！");
          }
          this.jbInit1();
    }

//刪除數據庫中的數據
    if(jRadioButton1.isSelected()){
        String id = txtID.getText();
        Aid1 aid = new Aid1();
        if (id.length() == 0) {
            JOptionPane.showMessageDialog(this, "編號不能為空，請填寫！");
            return;
        }  else{
            if (!aid.aid(id)) {
                JOptionPane.showMessageDialog(this, "編號不存在，請重新輸入");
                return;
            }
            AssetInfo asse = new AssetInfo();
            if (asse.info1(id)) {

            }
       }
        this.jbInit1();
         JOptionPane.showMessageDialog(this, "編號"+id+"被成功刪除");
         //刪除后在填寫框資料
         txtName.setText("");
         txtID.setText("");
         txtmath.setText("");
         txtAdd.setText("");
         txt1.setText("");
         txtPrice.setText("");
         txtPrice2.setText("");
            txtTime.setText("");

    }
}
//產生隨即數字1---1000
public void getNumber() {
    boolean sidd = true;
    do {
        String str = "ANI00" + Math.round(Math.random() * 1000 + 1);
        if (SDBManager.getOne("select aid from asset where aid = '" + str +
                              "'").isEmpty()) {
            this.txtID.setText(str);
            sidd = false;
        }
    } while (sidd);
}


//////////////////////////////
    public void jTable1_mouseClicked(MouseEvent e) {
        jTable1.setSelectionBackground(Color.GREEN);
        int row = jTable1.getSelectedRow();
        int col = jTable1.getSelectedColumn();
        if(row >= 0){
            txtID.setText(this.jTable1.getValueAt(row,0).toString());
            txtName.setText(this.jTable1.getValueAt(row,1).toString());
            txtmath.setText(this.jTable1.getValueAt(row,2).toString());
            txtnum.setText(this.jTable1.getValueAt(row,3).toString());
            jComboBox2.setSelectedItem(this.jTable1.getValueAt(row,4).toString());
            jComboBox1.setSelectedItem(this.jTable1.getValueAt(row,5).toString());
            jComboBox3.setSelectedItem(this.jTable1.getValueAt(row,6).toString());
            jComboBox4.setSelectedItem(this.jTable1.getValueAt(row,7).toString());
            txt1.setText(this.jTable1.getValueAt(row,8).toString());
            txtPrice2.setText(this.jTable1.getValueAt(row,9).toString());
            txtPrice.setText(this.jTable1.getValueAt(row,10).toString());
            txtTime.setText(this.jTable1.getValueAt(row,11).toString());
            txtAdd.setText(this.jTable1.getValueAt(row,12).toString());
        }
    }


    class ASMainMenu_jRadioButton1_actionAdapter implements ActionListener {
        private ASMainMenu adaptee;
        ASMainMenu_jRadioButton1_actionAdapter(ASMainMenu adaptee) {
            this.adaptee = adaptee;
        }

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

    }


    class ASMainMenu_jRadioButton2_actionAdapter implements ActionListener {
        private ASMainMenu adaptee;
        ASMainMenu_jRadioButton2_actionAdapter(ASMainMenu adaptee) {
            this.adaptee = adaptee;
        }