usershow.java

教材管理系统

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 jTabuserInfo = 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, 16));
    jLabel1.setText("以下为查询结果：");
    xYLayout1.setWidth(435);
    xYLayout1.setHeight(343);
    // model中加入列名
      model.addColumn("用户名") ;
      model.addColumn("密码") ;
      model.addColumn("所在专业") ;
      model.addColumn("所在院系") ;
      model.addColumn("联系电话") ;
      model.addColumn("专业人数") ;
      model.addColumn("入学时间") ;
      model.addColumn("登录权限") ;

    this.getContentPane().setLayout(xYLayout1);
    jTabuserInfo.setFont(new java.awt.Font("Dialog", 0, 12));
    jScrollPane1.getViewport().setBackground(UIManager.getColor("MenuBar.background"));
    jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 12));
    jBExit.setBackground(UIManager.getColor("InternalFrame.inactiveTitleForeground"));
    jBExit.setFont(new java.awt.Font("Dialog", 0, 16));
    jBExit.setMargin(new Insets(2, 2, 2, 2));
    jBExit.setText("退  出");
    jBExit.addActionListener(new usershow_jBExit_actionAdapter(this));
    this.getContentPane().setBackground(UIManager.getColor("InternalFrame.inactiveTitleForeground"));
    this.getContentPane().add(jScrollPane1,   new XYConstraints(27, 51, 356, 241));
    this.getContentPane().add(jLabel1, new XYConstraints(28, 26, 133, 19));
    this.getContentPane().add(jBExit, new XYConstraints(346, 304, 53, 24));
    jScrollPane1.getViewport().add(jTabuserInfo, null);
  }


  //供查询与排序调用的函数，显示结果列表
  void resultShow(ResultSet rs){
    try{
      rs.beforeFirst(); //移动游标到0的位置
      while (rs.next()) {
        tempvector = new Vector(1, 1);
        tempvector.add(rs.getString("username"));
        tempvector.add(rs.getString("password"));
        tempvector.add(rs.getString("professional"));
        tempvector.add(rs.getString("department"));
        tempvector.add(rs.getString("tel"));
        tempvector.add(rs.getString("pnum"));
        tempvector.add(rs.getString("admissiontime"));
        tempvector.add(rs.getString("power"));


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