specialityproject_list.java~1~

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

    });
    jButton2.setFont(new java.awt.Font("Serif", 0, 12));
    jButton2.setText("增加");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton2_actionPerformed(e);
      }
    });
    jLabel1.setFont(new java.awt.Font("Serif", 0, 20));
    jLabel1.setText("专业计划设置");
    jButton3.setFont(new java.awt.Font("Serif", 0, 12));
    jButton3.setText("修改");
    jButton3.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton3_actionPerformed(e);
      }
    });
    jPanel16 = new JPanel();
    jPanel16.setLayout(borderLayout3);
    jLabel2.setFont(new java.awt.Font("Serif", 0, 12));
    jLabel2.setText("请选择专业:");
    select_zy.setFont(new java.awt.Font("Serif", 0, 12));
    jPanel19 = new JPanel();
    jPanel19.add(jLabel2, null);
    jPanel11 = new JPanel();
    this.add(jPanel11, BorderLayout.SOUTH);
    this.add(jPanel13, BorderLayout.CENTER);
    jPanel13.add(jPanel16, BorderLayout.CENTER);
    jPanel16.add(jPanel19, BorderLayout.NORTH);
    jPanel19.add(select_zy, null);
    jPanel20 = new JPanel();
    jPanel16.add(jPanel20, BorderLayout.CENTER);
    jPanel20.add(jTabbedPane1, null);
    jPanel17 = new JPanel();
    jPanel13.add(jPanel17, BorderLayout.SOUTH);
    jPanel17.add(jButton2, null);
    jPanel17.add(jButton3, null);
    jPanel17.add(jButton1, null);
    jPanel18 = new JPanel();
    jPanel13.add(jPanel18, BorderLayout.NORTH);
    jPanel18.add(jLabel1, null);
    jPanel12 = new JPanel();
    this.add(jPanel12, BorderLayout.WEST);
    jPanel14 = new JPanel();
    this.add(jPanel14, BorderLayout.EAST);
    jPanel15 = new JPanel();
    this.add(jPanel15, BorderLayout.NORTH);
    select_zy.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        select_zy_actionPerformed(e);
      }
    });
  }
  void select_zy_actionPerformed(ActionEvent e)
  {
    zy_id = select_zy.getSelectvalue();
    jTabbedPane1.removeAll();
    init();
  }
  void jButton2_actionPerformed(ActionEvent e) {

    SpecialityProject_add_mod add = new SpecialityProject_add_mod(this,zy_id);
    add.show();
  }

  void jButton3_actionPerformed(ActionEvent e) {
    int i = jTabbedPane1.getSelectedIndex()+1;
    switch(i){
      case 1:{
        if (astable1.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds1,astable1,zy_id);
          mod.show();
        }
        break;
      }
    case 2:{
      if (astable2.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds2,astable2,zy_id);
          mod.show();
        }
        break;
    }
    case 3:{
      if (astable3.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds3,astable3,zy_id);
          mod.show();
        }
        break;
    }
    case 4:{
      if (astable4.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds4,astable4,zy_id);
          mod.show();
        }
        break;
    }
    case 5:{
      if (astable5.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds5,astable5,zy_id);
          mod.show();
        }
        break;
    }
    case 6:{
      if (astable6.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds6,astable6,zy_id);
          mod.show();
        }
        break;
    }
    case 7:{
      if (astable7.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds7,astable7,zy_id);
          mod.show();
        }
        break;
    }
    case 8:{
      if (astable7.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds8,astable8,zy_id);
          mod.show();
        }
        break;
    }
    case 9:{
      if (astable9.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds9,astable9,zy_id);
          mod.show();
        }
        break;
    }
    case 10:{
      if (astable10.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          SpecialityProject_add_mod mod = new SpecialityProject_add_mod(this,ds10,astable10,zy_id);
          mod.show();
        }
        break;
    }
    }
  }

  void jButton1_actionPerformed(ActionEvent e) {
    int i = jTabbedPane1.getSelectedIndex()+1;
    switch(i){
      case 1:{
        if (astable1.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds1,astable1);
        }
        break;
      }
      case 2:{
        if (astable2.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds2,astable2);
        }
        break;
      }
      case 3:{
        if (astable3.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds3,astable3);
        }
        break;
      }
      case 4:{
        if (astable4.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds4,astable4);
        }
        break;
      }
      case 5:{
        if (astable5.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds5,astable5);
        }
        break;
      }
      case 6:{
        if (astable6.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds6,astable6);
        }
        break;
      }
      case 7:{
        if (astable7.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds7,astable7);
        }
        break;
      }
      case 8:{
        if (astable8.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds8,astable8);
        }
        break;
      }
      case 9:{
        if (astable9.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds9,astable9);
        }
        break;
      }
      case 10:{
        if (astable10.getSelectedRow() == -1) //相应表格未进行选择
          JOptionPane.showMessageDialog(this, "请选择要修改的数据!", "输入错误",
                                        JOptionPane.ERROR_MESSAGE);
        else{
          del(ds10,astable10);
        }
        break;
      }
    }
  }
  private void del(ASDatastore dsk,ASTable astable){
    try {
      OperData od = new OperData();
      int row = astable.getSelectedRow();
      int kc_id = dsk.getItemInteger(row,"kc_id").intValue();
      String msg[]  = od.DelZYSZInfo(zy_id,kc_id);
      if (!msg[0].equals("true"))
        JOptionPane.showMessageDialog(this, msg[1], "错误",
                                      JOptionPane.ERROR_MESSAGE);
      else {
        dsk.removeRow(row);
        astable.ASTableRepant();
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }
}