specialityproject_list.java~2~

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

package specialityproject;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.zdsoft.gui.*;
import javax.swing.border.*;
import com.zdsoft.datacenter.*;
import com.zdsoft.datastore.*;
import com.zdsoft.gui.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class SpecialityProject_list extends ASPanel {
  private BorderLayout borderLayout1 = new BorderLayout();
  private TitledBorder titledBorder1;
  private TitledBorder titledBorder2;
  private TitledBorder titledBorder3;
  ASDatacenter dc;

  ASDatastore ds;

  //本系统规定只能对1---10个课程类型进行分类
  ASDatastore ds1;
  ASTableView asTableView1;
  ASTable astable1;
  private JScrollPane jScrollPane1;
  private JPanel jPanel1;

  ASDatastore ds2;
  ASTableView asTableView2;
  ASTable astable2;
  private JScrollPane jScrollPane2;
  private JPanel jPanel2;

  ASDatastore ds3;
  ASTableView asTableView3;
  ASTable astable3;
  private JScrollPane jScrollPane3;
  private JPanel jPanel3;

  ASDatastore ds4;
  ASTableView asTableView4;
  ASTable astable4;
  private JScrollPane jScrollPane4;
  private JPanel jPanel4;

  ASDatastore ds5;
  ASTableView asTableView5;
  ASTable astable5;
  private JScrollPane jScrollPane5;
  private JPanel jPanel5;

  ASDatastore ds6;
  ASTableView asTableView6;
  ASTable astable6;
  private JScrollPane jScrollPane6;
  private JPanel jPanel6;

  ASDatastore ds7;
  ASTableView asTableView7;
  ASTable astable7;
  private JScrollPane jScrollPane7;
  private JPanel jPanel7;

  ASDatastore ds8;
  ASTableView asTableView8;
  ASTable astable8;
  private JScrollPane jScrollPane8;
  private JPanel jPanel8;

  ASDatastore ds9;
  ASTableView asTableView9;
  ASTable astable9;
  private JScrollPane jScrollPane9;
  private JPanel jPanel9;

  ASDatastore ds10;
  ASTableView asTableView10;
  ASTable astable10;
  private JScrollPane jScrollPane10;
  private JPanel jPanel10;

  private JPanel jPanel11;
  private JPanel jPanel13;
  private JPanel jPanel12;
  private JPanel jPanel14;
  private JPanel jPanel15;
  private JPanel jPanel16;
  private JPanel jPanel17;
  private JPanel jPanel18;
  private JPanel jPanel20;
  private JPanel jPanel19;


  private TitledBorder titledBorder4;
  private TitledBorder titledBorder5;
  private TitledBorder titledBorder6;
  private BorderLayout borderLayout2 = new BorderLayout();
  private JButton jButton1 = new JButton();
  private JButton jButton2 = new JButton();
  private TitledBorder titledBorder7;
  private JLabel jLabel1 = new JLabel();
  private TitledBorder titledBorder8;
  private TitledBorder titledBorder9;
  private JButton jButton3 = new JButton();
  private BorderLayout borderLayout3 = new BorderLayout();
  private ASComboBox select_zy = new ASComboBox("zy_id","zy_name","zy_dm","1=1");
  int zy_id = select_zy.getSelectvalue();
  private JTabbedPane jTabbedPane1 = new JTabbedPane();
  private JLabel jLabel2 = new JLabel();

  public SpecialityProject_list() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void init(){
    jTabbedPane1.setFont(new java.awt.Font("Serif", 0, 12));
    try {
      OperData od = new OperData();
      ds = od.getKCLXcount();
      int kclx_id;
      String kclx_name;
      int indexall = ds.getRowCount();
      for(int i = 0;i<indexall;i++){
        kclx_id = ds.getItemInteger(i,"kclx_id").intValue();
        kclx_name= ds.getItemString(i,"kclx_name");
        switch (kclx_id){
          case 1:{
            jPanel1 = new JPanel();
            jScrollPane1 = new JScrollPane();
            jScrollPane1.setPreferredSize(new Dimension(760, 400));
            jTabbedPane1.add(jPanel1, kclx_name+"    ");
            jPanel1.add(jScrollPane1, null);
            ds1 = od.getZYKCByKCLX(zy_id,kclx_id);
            asTableView1 = new ASTableView(ds1);
            astable1 = new ASTable(asTableView1,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
            jScrollPane1.getViewport().add(astable1, null);
            break;
          }
        case 2:{
          jPanel2 = new JPanel();
          jScrollPane2 = new JScrollPane();
          jScrollPane2.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel2, kclx_name+"    ");
          jPanel2.add(jScrollPane2, null);
          ds2 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView2 = new ASTableView(ds2);
          astable2 = new ASTable(asTableView2,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane2.getViewport().add(astable2, null);
          break;
        }
        case 3:{
          jPanel3 = new JPanel();
          jScrollPane3 = new JScrollPane();
          jScrollPane3.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel3, kclx_name+"    ");
          jPanel3.add(jScrollPane3, null);
          ds3 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView3 = new ASTableView(ds3);
          astable3 = new ASTable(asTableView3,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane3.getViewport().add(astable3, null);
          break;
        }
        case 4:{
          jPanel4 = new JPanel();
          jScrollPane4 = new JScrollPane();
          jScrollPane4.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel4, kclx_name+"    ");
          jPanel4.add(jScrollPane4, null);
          ds4 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView4 = new ASTableView(ds4);
          astable4 = new ASTable(asTableView4,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane4.getViewport().add(astable4, null);
          break;
        }
        case 5:{
          jPanel5 = new JPanel();
          jScrollPane5 = new JScrollPane();
          jScrollPane5.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel5, kclx_name+"    ");
          jPanel5.add(jScrollPane5, null);
          ds5 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView5 = new ASTableView(ds5);
          astable5 = new ASTable(asTableView5,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane5.getViewport().add(astable5, null);
          break;
        }
        case 6:{
          jPanel6 = new JPanel();
          jScrollPane6 = new JScrollPane();
          jScrollPane6.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel6, kclx_name+"    ");
          jPanel6.add(jScrollPane6, null);
          ds6 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView6 = new ASTableView(ds6);
          astable6 = new ASTable(asTableView6,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane6.getViewport().add(astable6, null);
          break;
        }
        case 7:{
          jPanel7 = new JPanel();
          jScrollPane7 = new JScrollPane();
          jScrollPane7.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel7, kclx_name+"    ");
          jPanel7.add(jScrollPane7, null);
          ds7 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView7 = new ASTableView(ds7);
          astable7 = new ASTable(asTableView7,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane7.getViewport().add(astable7, null);
          break;
        }
        case 8:{
          jPanel8 = new JPanel();
          jScrollPane8 = new JScrollPane();
          jScrollPane8.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel8, kclx_name+"    ");
          jPanel8.add(jScrollPane8, null);
          ds8 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView8 = new ASTableView(ds8);
          astable8 = new ASTable(asTableView8,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane8.getViewport().add(astable8, null);
          break;
        }
        case 9:{
          jPanel9 = new JPanel();
          jScrollPane9 = new JScrollPane();
          jScrollPane9.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel9, kclx_name+"    ");
          jPanel9.add(jScrollPane9, null);
          ds9 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView9 = new ASTableView(ds9);
          astable9 = new ASTable(asTableView9,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane9.getViewport().add(astable9, null);
          break;
        }
        case 10:{
          jPanel10 = new JPanel();
          jScrollPane10 = new JScrollPane();
          jScrollPane10.setPreferredSize(new Dimension(760, 400));
          jTabbedPane1.add(jPanel10, kclx_name+"    ");
          jPanel10.add(jScrollPane10, null);
          ds10 = od.getZYKCByKCLX(zy_id,kclx_id);
          asTableView10 = new ASTableView(ds10);
          astable10 = new ASTable(asTableView10,new String[]{"kslx_id","kclx_id","kc_id","zy_id"});
          jScrollPane10.getViewport().add(astable10, null);
          break;
        }
        }
      }
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }
  private void jbInit() throws Exception  {
    init();
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder("");
    titledBorder5 = new TitledBorder("");
    titledBorder6 = new TitledBorder("");
    titledBorder7 = new TitledBorder("");
    titledBorder8 = new TitledBorder("");
    titledBorder9 = new TitledBorder("");
    this.setLayout(borderLayout1);
    jPanel13 = new JPanel();
    jPanel13.setLayout(borderLayout2);
    jButton1.setFont(new java.awt.Font("Serif", 0, 12));
    jButton1.setText("删除");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }