gradeshow.java

运行在JDK下的学生成绩管理系统源码.可以查询数据

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);
  }
}