usershow.java~1~

来自「教材管理系统」· JAVA~1~ 代码 · 共 104 行

package bookmanager;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
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 usershow 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 jTabStuInfo = new JTable(model);


  public usershow () {
    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("专业人数") ;
      model.addColumn("入学时间") ;

    this.getContentPane().setLayout(xYLayout1);
    jTabStuInfo.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 usershow_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(jTabStuInfo, null);
  }


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

  void jBExit_actionPerformed(ActionEvent e) {
   this.dispose() ;
  }
}

class usershow_jBExit_actionAdapter implements java.awt.event.ActionListener {
 usershow adaptee;

  usershow _jBExit_actionAdapter(usershow adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBExit_actionPerformed(e);
  }
}