package BJXX;import com.zdsoft.gui.*; //引入本包中的類，因為我們要用到的ASTable類(表格)、ASPanel類(面板)、ASTableView類(圖視)  都位于本包中import com.zdsoft.datacenter.ASDatacenter; //引入本包中的類，因為我們要用到的ASDatacenter類(數據中心，//用來連接相應數據庫及執行各種數據庫操作)位于本包中import com.zdsoft.datastore.ASDatastore; //引入本包中的類，因為我們要用到的ASDatastore類(數據倉庫)位于本包中import javax.swing.*;import java.awt.*;import java.awt.event.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2005</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class Class_Info_Show    extends ASPanel {  JPanel jPanel1 = new JPanel();  JPanel jPanel2 = new JPanel();  JPanel jPanel3 = new JPanel();  JLabel jLabel1 = new JLabel();  JToggleButton jToggleButton1 = new JToggleButton();  JToggleButton jToggleButton2 = new JToggleButton();  JScrollPane jScrollPane1 = new JScrollPane();  ASTable jTable1; //= new JTable();  ASDatastore ds;  JToggleButton jToggleButton3 = new JToggleButton();  public Class_Info_Show() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  private void jbInit() throws Exception {    //ASTable中顯示相應表數據的步驟：    //(1)創建數據中心對象    ASDatacenter dc = new ASDatacenter();    //(2)連接數據庫    dc.connect();    //(3)構造查詢語句    String sql = "select * from bj_info";    //(4)調用數據中心對象dc中的retrieve方法，執行查詢，得到一個數據結果集(ASDatastore類的一個具體對象)。本數據結果集    //中保存了根據查詢條件得到的所有數據.    ds = dc.retrieve(sql);    //(5)構造表格的顯示標題.    String[] liab = new String[3];    liab[0] = "班級編號";    liab[1] = "班級名稱";    liab[2] = "班主任";    //(6)將表格標題設置到結果集。注意：設置表格標題時，字符串數組的長度與相應數據結果集的    //列數應一樣。否則程序運行時會報錯.    ds.setTitleLable(liab);    //(7)用結果集構造視圖    ASTableView tv = new ASTableView(ds);    //(8)用創建好的視圖對象構造表格    jTable1 = new ASTable(tv);    //(9)關閉數據庫連接    dc.disconnect();    jLabel1.setFont(new java.awt.Font("Serif", 0, 15));    jLabel1.setText("班級信息維護");    jToggleButton1.setText("刪除");    jToggleButton1.addActionListener(new Class_Info_Show_jToggleButton1_actionAdapter(this));    jToggleButton2.setText("增加");    jToggleButton2.addActionListener(new Class_Info_Show_jToggleButton2_actionAdapter(this));    jToggleButton3.setText("修改");    jToggleButton3.addActionListener(new Class_Info_Show_jToggleButton3_actionAdapter(this));    jScrollPane1.setPreferredSize(new Dimension(500, 350));    this.setMinimumSize(new Dimension(185, 105));    this.setPreferredSize(new Dimension(600, 600));    this.add(jPanel1, BorderLayout.CENTER);    jPanel1.add(jScrollPane1, null);    jScrollPane1.getViewport().add(jTable1, null);    this.add(jPanel2, BorderLayout.SOUTH);    jPanel2.add(jToggleButton2, null);    jPanel2.add(jToggleButton1, null);    jPanel2.add(jToggleButton3, null);    this.add(jPanel3,  BorderLayout.NORTH);    jPanel3.add(jLabel1, null);  }  void jToggleButton1_actionPerformed(ActionEvent e) {    int i = jTable1.getSelectedRow();     if(i==-1){       JOptionPane.showMessageDialog(this, "請選擇要刪除的數據!", "提示信息",                                     JOptionPane.ERROR_MESSAGE);     }     else{       try {         int id = ds.getItemInteger(i,"id").intValue();         String sql = "delete bj_info where id="+id;         ASDatacenter dc = new ASDatacenter();         dc.connect();         String[] msg = dc.update(sql);         if(msg[0].equals("true")){           ds.removeRow(i);         jTable1.ASTableRepant();         }         else{}         dc.disconnect();       }       catch (Exception ex) {       }     }   }  void jToggleButton2_actionPerformed(ActionEvent e) {  }  }class Class_Info_Show_jToggleButton1_actionAdapter implements java.awt.event.ActionListener {  Class_Info_Show adaptee;  Class_Info_Show_jToggleButton1_actionAdapter(Class_Info_Show adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jToggleButton1_actionPerformed(e);  }}class Class_Info_Show_jToggleButton3_actionAdapter implements java.awt.event.ActionListener {  Class_Info_Show adaptee;  Class_Info_Show_jToggleButton3_actionAdapter(Class_Info_Show adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {//    adaptee.jToggleButton3_actionPerformed(e);  }}class Class_Info_Show_jToggleButton2_actionAdapter implements java.awt.event.ActionListener {  Class_Info_Show adaptee;  Class_Info_Show_jToggleButton2_actionAdapter(Class_Info_Show adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jToggleButton2_actionPerformed(e);  }}