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 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("出生日期") ;
      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 stuShow_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 stuShow_jBExit_actionAdapter implements java.awt.event.ActionListener {
  stuShow adaptee;

  stuShow_jBExit_actionAdapter(stuShow adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBExit_actionPerformed(e);
  }
}