stushow.java~13~

这是一个用JAVA编写的学生管理系统

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 stuShow extends JFrame {

  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JButton jBSee = new JButton();
  JButton jBExit = new JButton();

  JScrollPane jScrollPane1 = new JScrollPane();
  Vector tempvector=new Vector(1,1);
  DefaultTableModel model =new DefaultTableModel();
  JTable jTabStuInfo = new JTable(model);


  public stuShow() {
    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);
    jTabStuInfo.setFont(new java.awt.Font("Dialog", 0, 12));
    jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSee.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSee.setMargin(new Insets(2, 2, 2, 2));
    jBSee.setText("查  看");
    jBExit.setFont(new java.awt.Font("Dialog", 0, 12));
    jBExit.setMargin(new Insets(2, 2, 2, 2));
    jBExit.setText("退  出");
    this.getContentPane().add(jScrollPane1,   new XYConstraints(27, 51, 356, 241));
    this.getContentPane().add(jBSee,   new XYConstraints(263, 303, 53, 24));
    this.getContentPane().add(jBExit,   new XYConstraints(330, 303, 53, 24));
    this.getContentPane().add(jLabel1, new XYConstraints(28, 26, 133, 19));
    jScrollPane1.getViewport().add(jTabStuInfo, null);
  }

  //调用此函数就可以生成一个窗体，供排序时用，每次排序时只需
  //调用一次即可，避免了代码的重复
  void createFrame(stuShow shareFrame){
    Dimension dlgSize = shareFrame.getPreferredSize();
    Dimension frmSize = getSize();
    Point loc = getLocation();
    shareFrame.setLocation( 190,130);

    shareFrame.pack();
    shareFrame.show();
  }


  //供查询与排序调用的函数，显示结果列表
  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("Name"));
        tempvector.add(rs.getString("Sex"));
        tempvector.add(rs.getString("Class"));
        tempvector.add(rs.getString("Birthday"));
        tempvector.add(rs.getString("Home"));
        model.addRow(tempvector);
       }
     }
     catch(SQLException ex){
     }
  }
}