package stumng;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;

public class stuQueryId extends JFrame {
  DBConnManager dbconnmanager = new DBConnManager();
  BorderLayout borderLayout1 = new BorderLayout();
  JPanel jPanel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTable jTable1 = new JTable();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();

  private String sstu_id;
  private int astu_id;
  private boolean flag = false;

  public stuQueryId() {
    try {
      jbInit();
      //設置frame的大小
      this.setSize(600, 400);
      //得到當前屏幕大小
      Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
      //得到frame的大小
      Dimension frameSize = this.getSize();
      if (frameSize.height > screenSize.height) {
        frameSize.height = screenSize.height;
      }
      if (frameSize.width > screenSize.width) {
        frameSize.width = screenSize.width;
      }
      this.setTitle("查詢學生信息");
      //設置frame在屏幕上顯示的位置
      this.setLocation( (screenSize.width - frameSize.width) / 2,
                       (screenSize.height - frameSize.height) / 2);

    }
    catch(Exception ex) {
      ex.printStackTrace();
    }

    //按學號查詢該學生的基本信息
    jButton1.addActionListener(new ActionListener()
   {
     public void actionPerformed(ActionEvent e)
     {
       Vector result = new Vector();
       Vector resultdate = new Vector();
       Vector headline = new Vector();
       String aclass = "";
       String aname = "";
       headline.add("學號");
       headline.add("姓名");
       headline.add("班級");
       headline.add("性別");
       headline.add("出生日期");
       headline.add("民族");
       headline.add("籍貫");

       jTable1 = new JTable();
       jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); //滾動條設置左右滾
       jScrollPane1.getViewport().add(jTable1, null); //在滾動條中放入表

       sstu_id = jTextField1.getText();
       flag = dbconnmanager.checkStuid(sstu_id);
        if(sstu_id.equals(""))
        {
          JOptionPane.showMessageDialog(null, "請輸入學號為不能為空");
        }
        else if( flag == false )
        {
           JOptionPane.showMessageDialog(null, "學號只能是0－9數字");
        }
       else {
         astu_id = Integer.parseInt(sstu_id);
         result = dbconnmanager.stuinfQuery( astu_id, aclass, aname );
         if( result.size() == 0 )JOptionPane.showMessageDialog( null,"該學生不存在");
         else
         {
           for (int i = 0; i < result.size()/7; i++) {
             Vector temp = new Vector();
             for (int j = 0; j <= 6; j++) {
               String str = (String)result.elementAt(j + i * 7);
               temp.add(str);
             }
             resultdate.add(temp);
           }
           jTable1 = new JTable(resultdate, headline);
           jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); //滾動條設置左右滾
           jScrollPane1.getViewport().add(jTable1, null); //在滾動條中放入表
         }
       }
     }
   });

    //退出frame
    jButton2.addActionListener(new ActionListener()
   {
     public void actionPerformed(ActionEvent e)
     {
       jButton2_actionPerformed(e);
     }
   });

  }

  void jbInit() throws Exception {
    this.getContentPane().setLayout(borderLayout1);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setText("請輸入學號");
    jTextField1.setOpaque(false);
    jTextField1.setPreferredSize(new Dimension(100, 21));
    jTextField1.setSelectionStart(21);
    jTextField1.setText("");
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("提交");
    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton2.setText("退出");
    this.getContentPane().add(jPanel1, BorderLayout.NORTH);
    jPanel1.add(jLabel1, null);
    jPanel1.add(jTextField1, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jButton2, null);
    this.getContentPane().add(jScrollPane1, BorderLayout.CENTER);
  }
  void jButton2_actionPerformed(ActionEvent e)
   {
     jTable1 = new JTable();
     jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); //滾動條設置左右滾
     jScrollPane1.getViewport().add(jTable1, null); //在滾動條中放入表

     this.dispose();
     dbconnmanager.closeConns();
   }
 }