specialityproject_add_mod.java~1~

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

      mzks_3.setEnabled(false);
      mzks_3.setBackground(SystemColor.activeCaptionBorder);
    }
  }

  void jCheckBox4_actionPerformed(ActionEvent e) {
    if(jCheckBox4.isSelected()){
      xkzs_4.setEditable(true);
      xkzs_4.setEnabled(true);
      xkzs_4.setBackground(Color.white);
      mzks_4.setEditable(true);
      mzks_4.setEnabled(true);
      mzks_4.setBackground(Color.white);
    }
    else{
      xkzs_4.setText("");
      xkzs_4.setEditable(false);
      xkzs_4.setEnabled(false);
      xkzs_4.setBackground(SystemColor.activeCaptionBorder);
      mzks_4.setText("");
      mzks_4.setEditable(false);
      mzks_4.setEnabled(false);
      mzks_4.setBackground(SystemColor.activeCaptionBorder);
    }
  }

  void jCheckBox5_actionPerformed(ActionEvent e) {
    if(jCheckBox5.isSelected()){
      xkzs_5.setEditable(true);
      xkzs_5.setEnabled(true);
      xkzs_5.setBackground(Color.white);
      mzks_5.setEditable(true);
      mzks_5.setEnabled(true);
      mzks_5.setBackground(Color.white);
    }
    else{
      xkzs_5.setText("");
      xkzs_5.setEditable(false);
      xkzs_5.setEnabled(false);
      xkzs_5.setBackground(SystemColor.activeCaptionBorder);
      mzks_5.setText("");
      mzks_5.setEditable(false);
      mzks_5.setEnabled(false);
      mzks_5.setBackground(SystemColor.activeCaptionBorder);
    }
  }

  void jCheckBox6_actionPerformed(ActionEvent e) {
    if(jCheckBox6.isSelected()){
      xkzs_6.setEditable(true);
      xkzs_6.setEnabled(true);
      xkzs_6.setBackground(Color.white);
      mzks_6.setEditable(true);
      mzks_6.setEnabled(true);
      mzks_6.setBackground(Color.white);
    }
    else{
      xkzs_6.setText("");
      xkzs_6.setEditable(false);
      xkzs_6.setEnabled(false);
      xkzs_6.setBackground(SystemColor.activeCaptionBorder);
      mzks_6.setText("");
      mzks_6.setEditable(false);
      mzks_6.setEnabled(false);
      mzks_6.setBackground(SystemColor.activeCaptionBorder);
    }
  }

  void jCheckBox7_actionPerformed(ActionEvent e) {
    if(jCheckBox7.isSelected()){
      xkzs_7.setEditable(true);
      xkzs_7.setEnabled(true);
      xkzs_7.setBackground(Color.white);
      mzks_7.setEditable(true);
      mzks_7.setEnabled(true);
      mzks_7.setBackground(Color.white);
    }
    else{
      xkzs_7.setText("");
      xkzs_7.setEditable(false);
      xkzs_7.setEnabled(false);
      xkzs_7.setBackground(SystemColor.activeCaptionBorder);
      mzks_7.setText("");
      mzks_7.setEditable(false);
      mzks_7.setEnabled(false);
      mzks_7.setBackground(SystemColor.activeCaptionBorder);
    }
  }

  void jCheckBox8_actionPerformed(ActionEvent e) {
    if(jCheckBox8.isSelected()){
      xkzs_8.setEditable(true);
      xkzs_8.setEnabled(true);
      xkzs_8.setBackground(Color.white);
      mzks_8.setEditable(true);
      mzks_8.setEnabled(true);
      mzks_8.setBackground(Color.white);
    }
    else{
      xkzs_8.setText("");
      xkzs_8.setEditable(false);
      xkzs_8.setEnabled(false);
      xkzs_8.setBackground(SystemColor.activeCaptionBorder);
      mzks_8.setText("");
      mzks_8.setEditable(false);
      mzks_8.setEnabled(false);
      mzks_8.setBackground(SystemColor.activeCaptionBorder);
    }
  }
  private boolean isSelect(){
    if(jCheckBox1.isSelected())
      return true;
    else if(jCheckBox2.isSelected())
      return true;
    else if(jCheckBox3.isSelected())
      return true;
    else if(jCheckBox4.isSelected())
      return true;
    else if(jCheckBox5.isSelected())
      return true;
    else if(jCheckBox6.isSelected())
      return true;
    else if(jCheckBox7.isSelected())
      return true;
    else if(jCheckBox8.isSelected())
      return true;
    else
      return false;
  }
  private boolean isInput(){
    boolean flag = true;
    if(jCheckBox1.isSelected()){
      if(xkzs_1.getText().trim().equals("")||mzks_1.getText().trim().equals(""))
        flag = false;

    }
    if(flag){
      if(jCheckBox2.isSelected()){
        if(xkzs_2.getText().trim().equals("")||mzks_2.getText().trim().equals(""))
          flag = false;

      }
    }
    if(flag){
      if(jCheckBox3.isSelected()){
        if(xkzs_3.getText().trim().equals("")||mzks_3.getText().trim().equals(""))
          flag = false;

      }
    }
    if(flag){
      if(jCheckBox4.isSelected()){
        if(xkzs_4.getText().trim().equals("")||mzks_4.getText().trim().equals(""))
          flag = false;

      }
    }
    if(flag){
      if(jCheckBox5.isSelected()){
        if(xkzs_5.getText().trim().equals("")||mzks_5.getText().trim().equals(""))
          flag = false;

      }
    }
    if(flag){
      if(jCheckBox6.isSelected()){
        if(xkzs_6.getText().trim().equals("")||mzks_6.getText().trim().equals(""))
          flag = false;

      }
    }
    if(flag){
      if(jCheckBox7.isSelected()){
        if(xkzs_7.getText().trim().equals("")||mzks_7.getText().trim().equals(""))
          flag = false;

      }
    }
    if(flag){
      if(jCheckBox8.isSelected()){
        if(xkzs_8.getText().trim().equals("")||mzks_8.getText().trim().equals(""))
          flag = false;

      }
    }
    return flag;
  }
  private void tableRepant(ASDatastore ds,ASTable table){
    try {
      int row;
      if(oper.equals("add"))
        row =ds.addRow();
      else
        row =table.getSelectedRow();
      ds.setObjectAt(row,"zy_id",new Integer(zy_id));
      if(oper.equals("add")){
        if(!flagp)
          ds.setObjectAt(row,"kc_id",new Integer(kcname.getSelectvalue()));
        else
          ds.setObjectAt(row,"kc_id",new Integer(kc_id));
      }
      else
        ds.setObjectAt(row,"kc_id",new Integer(kc_id));

      ds.setObjectAt(row,"kc_code",kcdm.getText());
      if(oper.equals("add")){
        if(!flagp)
          ds.setObjectAt(row,"kc_name",kcname.getSelectedItem());
        else
          ds.setObjectAt(row,"kc_name",jLabel9.getText());
      }
      ds.setObjectAt(row,"kclx_id",new Integer(kclx.getSelectvalue()));
      ds.setObjectAt(row,"kclx_name",kclx.getSelectedItem());
      ds.setObjectAt(row,"kslx_id",new Integer(kslx.getSelectvalue()));
      ds.setObjectAt(row,"kslx_name",kslx.getSelectedItem());
      ds.setObjectAt(row,"kc_hour",new Integer(zxs.getText().trim()));
      ds.setObjectAt(row,"class_hour",ktjs.getText().trim().equals("") ? null: new Integer(ktjs.getText().trim()));
      ds.setObjectAt(row,"self_hour",zx.getText().trim().equals("") ? null: new Integer(zx.getText().trim()));
      ds.setObjectAt(row,"class_experiment",knsy.getText().trim().equals("") ? null: new Integer(knsy.getText().trim()));
      ds.setObjectAt(row,"class_discuss",kttl.getText().trim().equals("") ? null: new Integer(kttl.getText().trim()));
      ds.setObjectAt(row,"class_computer",knsj.getText().trim().equals("") ? null: new Integer(knsj.getText().trim()));
      ds.setObjectAt(row,"self_practice",kwsj.getText().trim().equals("") ? null: new Integer(kwsj.getText().trim()));
      switch(xqs){
        case 1:{
          ds.setObjectAt(row,"week_hour1",mzks_1.getText().trim().equals("") ? null: new Integer(mzks_1.getText().trim()));
          break;
        }
        case 2:{
          ds.setObjectAt(row,"week_hour1",mzks_1.getText().trim().equals("") ? null: new Integer(mzks_1.getText().trim()));
          ds.setObjectAt(row,"week_hour2",mzks_2.getText().trim().equals("") ? null: new Integer(mzks_2.getText().trim()));
        break;
       }
       case 3:{
         ds.setObjectAt(row,"week_hour1",mzks_1.getText().trim().equals("") ? null: new Integer(mzks_1.getText().trim()));
         ds.setObjectAt(row,"week_hour2",mzks_2.getText().trim().equals("") ? null: new Integer(mzks_2.getText().trim()));
         ds.setObjectAt(row,"week_hour3",mzks_3.getText().trim().equals("") ? null: new Integer(mzks_3.getText().trim()));
         break;
       }
       case 4:{
         ds.setObjectAt(row,"week_hour1",mzks_1.getText().trim().equals("") ? null: new Integer(mzks_1.getText().trim()));
         ds.setObjectAt(row,"week_hour2",mzks_2.getText().trim().equals("") ? null: new Integer(mzks_2.getText().trim()));
         ds.setObjectAt(row,"week_hour3",mzks_3.getText().trim().equals("") ? null: new Integer(mzks_3.getText().trim()));
         ds.setObjectAt(row,"week_hour4",mzks_4.getText().trim().equals("") ? null: new Integer(mzks_4.getText().trim()));
         break;
       }
       case 5:{
         ds.setObjectAt(row,"week_hour1",mzks_1.getText().trim().equals("") ? null: new Integer(mzks_1.getText().trim()));
         ds.setObjectAt(row,"week_hour2",mzks_2.getText().trim().equals("") ? null: new Integer(mzks_2.getText().trim()));
         ds.setObjectAt(row,"week_hour3",mzks_3.getText().trim().equals("") ? null: new Integer(mzks_3.getText().trim()));
         ds.setObjectAt(row,"week_hour4",mzks_4.getText().trim().equals("") ? null: new Integer(mzks_4.getText().trim()));
         ds.setObjectAt(row,"week_hour5",mzks_5.getText().trim().equals("") ? null: new Integer(mzks_5.getText().trim()));
         break;
       }
       case 6:{
         ds.setObjectAt(row,"week_hour1",mzks_1.getText().trim().equals("") ? null: new Integer(mzks_1.getText().trim()));
         ds.setObjectAt(row,"week_hour2",mzks_2.getText().trim().equals("") ? null: new Integer(mzks_2.getText().trim()));
         ds.setObjectAt(row,"week_hour3",mzks_3.getText().trim().equals("") ? null: new Integer(mzks_3.getText().trim()));
         ds.setObjectAt(row,"week_hour4",mzks_4.getText().trim().equals("") ? null: new Integer(mzks_4.getText().trim()));
         ds.setObjectAt(row,"week_hour5",mzks_5.getText().trim().equals("") ? null: new Integer(mzks_5.getText().trim()));
         ds.setObjectAt(row,"week_hour6",mzks_6.getText().trim().equals("") ? null: new Integer(mzks_6.getText().trim()));
         break;
       }
       case 7:{
         ds.setObjectAt(row,"week_hour1",mzks_1.getText().trim().equals("") ? null: new Integer(mzks_1.getText().trim()));
         ds.setObjectAt(row,"week_hour2",mzks_2.getText().trim().equals("") ? null: new Integer(mzks_2.getText().trim()));
         ds.setObjectAt(row,"week_hour3",mzks_3.getText().trim().equals("") ? null: new Integer(mzks_3.getText().trim()));
         ds.setObjectAt(row,"week_hour4",mzks_4.getText().trim().equals("") ? null: new Integer(mzks_4.getText().trim()));
         ds.setObjectAt(row,"week_hour5",mzks_5.getText().trim().equals("") ? null: new Integer(mzks_5.getText().trim()));
         ds.setObjectAt(row,"week_hour6",mzks_6.getText().trim().equals("") ? null: new Integer(mzks_6.getText().trim()));
         ds.setObjectAt(row,"week_hour7",mzks_7.getText().trim().equals("") ? null: new Integer(mzks_7.getText().trim()));
         break;
       }
       case 8:{
         ds.setObjectAt(row,"week_hour1",mzks_1.getText().trim().equals("") ? null: new Integer(mzks_1.getText().trim()));
         ds.setObjectAt(row,"week_hour2",mzks_2.getText().trim().equals("") ? null: new Integer(mzks_2.getText().trim()));
         ds.setObjectAt(row,"week_hour3",mzks_3.getText().trim().equals("") ? null: new Integer(mzks_3.getText().trim()));
         ds.setObjectAt(row,"week_hour4",mzks_4.getText().trim().equals("") ? null: new Integer(mzks_4.getText().trim()));
         ds.setObjectAt(row,"week_hour5",mzks_5.getText().trim().equals("") ? null: new Integer(mzks_5.getText().trim()));
         ds.setObjectAt(row,"week_hour6",mzks_6.getText().trim().equals("") ? null: new Integer(mzks_6.getText().trim()));
         ds.setObjectAt(row,"week_hour7",mzks_7.getText().trim().equals("") ? null: new Integer(mzks_7.getText().trim()));
         ds.setObjectAt(row,"week_hour8",mzks_8.getText().trim().equals("") ? null: new Integer(mzks_8.getText().trim()));

         break;
       }
      }
      table.ASTableRepant();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  void kcname_actionPerformed(ActionEvent e) {
    try {
      OperData od = new OperData();
      kcdm.setText(od.getKCCode(kcname.getSelectvalue()));
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }
}