package studentms;import com.borland.jbcl.layout.*;import java.awt.*;import java.sql.*;import javax.swing.*;import javax.swing.table.*;import java.util.*;import java.awt.event.*;public class gradeShow extends JFrame {  XYLayout xYLayout1 = new XYLayout();  JLabel jLabel1 = new JLabel();  JButton jBExit = new JButton();  JScrollPane jScrollPane1 = new JScrollPane();  Vector tempvector=new Vector(1,1);  DefaultTableModel model =new DefaultTableModel();  JTable jTabGradeInfo = new JTable(model);  public gradeShow() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  private void jbInit() throws Exception {    jLabel1.setFont(new java.awt.Font("Dialog", 0, 14));    jLabel1.setText("以下為查詢結果：");    xYLayout1.setWidth(409);    xYLayout1.setHeight(337);    // model中加入列名      model.addColumn("學號") ;      model.addColumn("總分") ;      model.addColumn("語文") ;      model.addColumn("數學") ;      model.addColumn("英語") ;      model.addColumn("綜合") ;    this.getContentPane().setLayout(xYLayout1);    jTabGradeInfo.setFont(new java.awt.Font("Dialog", 0, 12));    jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 12));    jBExit.setFont(new java.awt.Font("Dialog", 0, 12));    jBExit.setMargin(new Insets(2, 2, 2, 2));    jBExit.setText("退  出");    jBExit.addActionListener(new gradeShow_jBExit_actionAdapter(this));    this.getContentPane().add(jScrollPane1,   new XYConstraints(27, 51, 356, 241));    this.getContentPane().add(jBExit,   new XYConstraints(330, 303, 53, 24));    this.getContentPane().add(jLabel1, new XYConstraints(28, 26, 133, 19));    jScrollPane1.getViewport().add(jTabGradeInfo, null);  } //調用此函數就可以生成一個窗體，供排序時用，每次排序時只需 //調用一次即可，避免了代碼的重復 void createFrame(gradeShow shareFrame){   shareFrame.setLocation( 190,130);   shareFrame.pack();   shareFrame.show();   shareFrame.jLabel1 .setText("以下為排序結果：");   jLabel1.setFont(new java.awt.Font("Dialog", 0, 14)); }  //供查詢調用的函數，顯示結果列表  void resultShow(ResultSet rs){    try{      rs.beforeFirst(); //移動游標到0的位置      while (rs.next()) {        tempvector = new Vector(1, 1);        tempvector.add(rs.getString("Num"));        tempvector.add(rs.getString("Total"));        tempvector.add(rs.getString("Chinese"));        tempvector.add(rs.getString("Math"));        tempvector.add(rs.getString("English"));        tempvector.add(rs.getString("Composite"));        model.addRow(tempvector);       }     }     catch(SQLException ex){     }  }  void jBExit_actionPerformed(ActionEvent e) {   this.dispose() ;  }}class gradeShow_jBExit_actionAdapter implements java.awt.event.ActionListener {  gradeShow adaptee;  gradeShow_jBExit_actionAdapter(gradeShow adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.jBExit_actionPerformed(e);  }}