specialityproject_add_mod.java~1~

这是一个图书和学生信息的管理系统,它可以在数据库里面增加,修改,删除数据来管理图书和学生信息

        else
          obj[8] = new Integer(kttl.getText().trim());

        if (knsj.getText().trim().equals(""))
          obj[9] = null;
        else
          obj[9] = new Integer(knsj.getText().trim());

        if (kwsj.getText().trim().equals(""))
          obj[10] = null;
        else
          obj[10] = new Integer(kwsj.getText().trim());

        if (oper.equals("add"))
          obj[11] = "N";
        else
          obj[11] = "Y";

        int i = 0;
        if(jCheckBox1.isSelected())
          i++;
        if(jCheckBox2.isSelected())
          i++;
        if(jCheckBox3.isSelected())
          i++;
        if(jCheckBox4.isSelected())
          i++;
        if(jCheckBox5.isSelected())
          i++;
        if(jCheckBox6.isSelected())
          i++;
        if(jCheckBox7.isSelected())
          i++;
        if(jCheckBox8.isSelected())
          i++;
        Object[][] objxq = new Object[i][6];
        Object[] tmp;
        int k = 0;
        if(jCheckBox1.isSelected()){
          objxq[k][0] =new Integer(zy_id);
          if(oper.equals("add"))
            objxq[k][1] = new Integer(kcname.getSelectvalue());
          else
            objxq[k][1] = new Integer(kc_id);
          objxq[k][2] = new Integer(1);
          objxq[k][3] = new Integer(xkzs_1.getText().trim());
          objxq[k][4] = new Integer(mzks_1.getText().trim());
          k++;
        }
        if(jCheckBox2.isSelected()){
          objxq[k][0] =new Integer(zy_id);
          if(oper.equals("add"))
            objxq[k][1] = new Integer(kcname.getSelectvalue());
          else
            objxq[k][1] = new Integer(kc_id);
          objxq[k][2] = new Integer(2);
          objxq[k][3] = new Integer(xkzs_2.getText().trim());
          objxq[k][4] = new Integer(mzks_2.getText().trim());
          k++;
        }
        if(jCheckBox3.isSelected()){
          objxq[k][0] =new Integer(zy_id);
          if(oper.equals("add"))
            objxq[k][1] = new Integer(kcname.getSelectvalue());
          else
            objxq[k][1] = new Integer(kc_id);
          objxq[k][2] = new Integer(3);
          objxq[k][3] = new Integer(xkzs_3.getText().trim());
          objxq[k][4] = new Integer(mzks_3.getText().trim());
          k++;
        }
        if(jCheckBox4.isSelected()){
          objxq[k][0] =new Integer(zy_id);
          if(oper.equals("add"))
            objxq[k][1] = new Integer(kcname.getSelectvalue());
          else
            objxq[k][1] = new Integer(kc_id);
          objxq[k][2] = new Integer(4);
          objxq[k][3] = new Integer(xkzs_4.getText().trim());
          objxq[k][4] = new Integer(mzks_4.getText().trim());
          k++;
        }
        if(jCheckBox5.isSelected()){
          objxq[k][0] =new Integer(zy_id);
          if(oper.equals("add"))
            objxq[k][1] = new Integer(kcname.getSelectvalue());
          else
            objxq[k][1] = new Integer(kc_id);
          objxq[k][2] = new Integer(5);
          objxq[k][3] = new Integer(xkzs_5.getText().trim());
          objxq[k][4] = new Integer(mzks_5.getText().trim());
          k++;
        }
        if(jCheckBox6.isSelected()){
          objxq[k][0] =new Integer(zy_id);
          if(oper.equals("add"))
            objxq[k][1] = new Integer(kcname.getSelectvalue());
          else
            objxq[k][1] = new Integer(kc_id);
          objxq[k][2] = new Integer(6);
          objxq[k][3] = new Integer(xkzs_6.getText().trim());
          objxq[k][4] = new Integer(mzks_6.getText().trim());
          k++;
        }
        if(jCheckBox7.isSelected()){
          objxq[k][0] =new Integer(zy_id);
          if(oper.equals("add"))
            objxq[k][1] = new Integer(kcname.getSelectvalue());
          else
            objxq[k][1] = new Integer(kc_id);
          objxq[k][2] = new Integer(7);
          objxq[k][3] = new Integer(xkzs_7.getText().trim());
          objxq[k][4] = new Integer(mzks_7.getText().trim());
          k++;
        }
        if(jCheckBox8.isSelected()){
          objxq[k][0] =new Integer(zy_id);
          if(oper.equals("add"))
            objxq[k][1] = new Integer(kcname.getSelectvalue());
          else
            objxq[k][1] = new Integer(kc_id);
          objxq[k][2] = new Integer(8);
          objxq[k][3] = new Integer(xkzs_8.getText().trim());
          objxq[k][4] = new Integer(mzks_8.getText().trim());
          k++;
        }
        OperData od = new OperData();

        if (oper.equals("add"))
        {
          msg = od.addZYJHinfo(obj,objxq);
          if (msg[0].equals("false"))//调用方法失败
            JOptionPane.showMessageDialog(this,"操作失败!","",JOptionPane.ERROR_MESSAGE);
          else{
            int index  = kclx.getSelectvalue();
            switch(index){
              case 1:{
                tableRepant(sp_list.ds1,sp_list.astable1);
                break;
              }
              case 2:{
                tableRepant(sp_list.ds2,sp_list.astable2);
                break;
              }
              case 3:{
                tableRepant(sp_list.ds3,sp_list.astable3);
                break;
              }
              case 4:{
                tableRepant(sp_list.ds4,sp_list.astable4);
                break;
              }
              case 5:{
                tableRepant(sp_list.ds5,sp_list.astable5);
                break;
              }
              case 6:{
                tableRepant(sp_list.ds6,sp_list.astable6);
                break;
              }
              case 7:{
                tableRepant(sp_list.ds7,sp_list.astable7);
                break;
              }
              case 8:{
                tableRepant(sp_list.ds8,sp_list.astable8);
                break;
              }
              case 9:{
                tableRepant(sp_list.ds9,sp_list.astable9);
                break;
              }
              case 10:{
                tableRepant(sp_list.ds10,sp_list.astable10);
                break;
              }
            }
            this.dispose();//关闭本对话框
          }
        }
        else{
          msg = od.modZYJHinfo(obj,objxq);
          if (msg[0].equals("false"))//调用方法失败
            JOptionPane.showMessageDialog(this,"操作失败!","",JOptionPane.ERROR_MESSAGE);
          else{
            int index  = kclx.getSelectvalue();
            if(index!=kclx_id){
              dsm.removeRow(tablem.getSelectedRow());
              tablem.ASTableRepant();
              oper = "add";
              flagp = true;
              switch(index){
                case 1:{
                  tableRepant(sp_list.ds1,sp_list.astable1);
                  break;
                }
                case 2:{
                  tableRepant(sp_list.ds2,sp_list.astable2);
                  break;
                }
                case 3:{
                  tableRepant(sp_list.ds3,sp_list.astable3);
                  break;
                }
                case 4:{
                  tableRepant(sp_list.ds4,sp_list.astable4);
                  break;
                }
                case 5:{
                  tableRepant(sp_list.ds5,sp_list.astable5);
                  break;
                }
                case 6:{
                  tableRepant(sp_list.ds6,sp_list.astable6);
                  break;
                }
                case 7:{
                  tableRepant(sp_list.ds7,sp_list.astable7);
                  break;
                }
                case 8:{
                  tableRepant(sp_list.ds8,sp_list.astable8);
                  break;
                }
                case 9:{
                  tableRepant(sp_list.ds9,sp_list.astable9);
                  break;
                }
                case 10:{
                  tableRepant(sp_list.ds10,sp_list.astable10);
                  break;
                }
              }
            }
            else
              tableRepant(dsm,tablem);
            this.dispose();
          }
        }
      }
      catch (Exception ex) {
        ex.printStackTrace();
      }
    }
  }

  void jCheckBox1_actionPerformed(ActionEvent e) {
    if(jCheckBox1.isSelected()){
      xkzs_1.setEditable(true);
      xkzs_1.setEnabled(true);
      xkzs_1.setBackground(Color.white);
      mzks_1.setEditable(true);
      mzks_1.setEnabled(true);
      mzks_1.setBackground(Color.white);
    }
    else{
      xkzs_1.setText("");
      xkzs_1.setEditable(false);
      xkzs_1.setEnabled(false);
      xkzs_1.setBackground(SystemColor.activeCaptionBorder);
      xkzs_1.setText("");
      mzks_1.setEditable(false);
      mzks_1.setEnabled(false);
      mzks_1.setBackground(SystemColor.activeCaptionBorder);
    }

  }

  void jCheckBox2_actionPerformed(ActionEvent e) {
    if(jCheckBox2.isSelected()){
      xkzs_2.setEditable(true);
      xkzs_2.setEnabled(true);
      xkzs_2.setBackground(Color.white);
      mzks_2.setEditable(true);
      mzks_2.setEnabled(true);
      mzks_2.setBackground(Color.white);
    }
    else{
      xkzs_2.setText("");
      xkzs_2.setEditable(false);
      xkzs_2.setEnabled(false);
      xkzs_2.setBackground(SystemColor.activeCaptionBorder);
      mzks_2.setText("");
      mzks_2.setEditable(false);
      mzks_2.setEnabled(false);
      mzks_2.setBackground(SystemColor.activeCaptionBorder);
    }
  }

  void jCheckBox3_actionPerformed(ActionEvent e) {
    if(jCheckBox3.isSelected()){
      xkzs_3.setEditable(true);
      xkzs_3.setEnabled(true);
      xkzs_3.setBackground(Color.white);
      mzks_3.setEditable(true);
      mzks_3.setEnabled(true);
      mzks_3.setBackground(Color.white);
    }
    else{
      xkzs_3.setText("");
      xkzs_3.setEditable(false);
      xkzs_3.setEnabled(false);
      xkzs_3.setBackground(SystemColor.activeCaptionBorder);
      mzks_3.setText("");
      mzks_3.setEditable(false);