package stumng;

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

public class gradeRank extends JFrame {
  DBConnManager dbconnmanager = new DBConnManager();
  BorderLayout borderLayout1 = new BorderLayout();
  JPanel jPanel1 = new JPanel();
  JComboBox jComboBox1 = new JComboBox();
  TitledBorder titledBorder1;
  JComboBox jComboBox2 = new JComboBox();
  JScrollPane jScrollPane1 = new JScrollPane();
  JComboBox jComboBox3 = new JComboBox();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JTable jTable1 = new JTable();

  private String aclass = "";
  private String aschool = "";
  private String amath = "";
  private String achinese = "";
  private String aenglish = "";
  private String atotal = "";
  private String acomposite = "";
  private String bygrade = "";

  public gradeRank() {
    try {
      jbInit();
      //設置frame的大小
      this.setSize(600, 500);
      //得到當前屏幕大小
      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 )
      {
        //清空
        aclass = "";
        aschool = "";
        amath = "";
        achinese = "";
        aenglish = "";
        atotal = "";
        acomposite = "";
        bygrade = "";
        Vector result = new Vector();
        Vector headline = new Vector();
        Vector resultdate = new Vector();

        aclass = (String) jComboBox2.getSelectedItem();
        if (!aclass.equals("班級號")) {
          aschool = (String)jComboBox2.getSelectedItem();
          aclass = "";
          jComboBox3.setEditable(false);
        }
        else aclass = (String)jComboBox3.getSelectedItem();
        bygrade = (String) jComboBox1.getSelectedItem();
        if( bygrade.equals("總分") )atotal = "總分";
        else if( bygrade.equals("語文成績") )achinese = "語文成績";
        else if(bygrade.equals("數學成績"))amath = "數學成績";
        else if(bygrade.equals("英語成績"))aenglish= "英語成績";
        else if(bygrade.equals("總評"))acomposite= "總評";
        headline.addElement("stu_id");
        headline.addElement(bygrade);
        headline.addElement("class");
        result = dbconnmanager.getRank(aclass, aschool, amath, achinese, aenglish, acomposite, atotal);
        if(result != null)
        {
          for( int i =0; i<result.size()/3; i++  )
          {
            Vector temp = new Vector();
            for( int j =0; j<=2; j++ )
            {
              String str = (String)result.elementAt(j+i*3);
              temp.add(str);
            }
            resultdate.add(temp);
          }
          jTable1 = new JTable(resultdate, headline);
          jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); //滾動條設置左右滾
          jScrollPane1.getViewport().add(jTable1, null); //在滾動條中放入表
        }else JOptionPane.showMessageDialog(null, "記錄為空");
      }
    });
    jButton2.addActionListener(new ActionListener()
    {
      public void actionPerformed( ActionEvent e)
     {
       jButton2_actionPerformed(e);
     }

    }
     );
  }

  void jbInit() throws Exception {
    titledBorder1 = new TitledBorder("");
    this.getContentPane().setLayout(borderLayout1);
    jComboBox1.setFont(new java.awt.Font("Dialog", 0, 13));
    jComboBox1.setAutoscrolls(false);
    jComboBox1.setBorder(BorderFactory.createLoweredBevelBorder());
    jComboBox1.setToolTipText("");
    jComboBox1.setActionCommand("comboBoxChanged");
    jComboBox1.addItem("總分");
    jComboBox1.addItem("數學成績");
    jComboBox1.addItem("語文成績");
    jComboBox1.addItem("英語成績");
    jComboBox1.addItem("總評");
    jComboBox2.setFont(new java.awt.Font("Dialog", 0, 13));
    jComboBox2.setMaximumRowCount(20);
    jComboBox2.addItem("全校");
    jComboBox2.addItem("班級號");
    jComboBox3.setFont(new java.awt.Font("Dialog", 0, 13));
    jComboBox3.addItem("A2241");
    jComboBox3.addItem("A2242");
    jComboBox3.addItem("A2243");
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("提交");
    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton2.setVerifyInputWhenFocusTarget(true);
    jButton2.setText("退出");
    jButton2.setVerticalTextPosition(javax.swing.SwingConstants.CENTER);
    jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 15));
    this.getContentPane().add(jPanel1, BorderLayout.NORTH);
    jPanel1.add(jComboBox2, null);
    jPanel1.add(jComboBox3, null);
    jPanel1.add(jButton1, null);
    jPanel1.add(jButton2, null);
    jTable1.setFont(new java.awt.Font("Dialog", 0, 15));
    this.getContentPane().add(jComboBox1, BorderLayout.SOUTH);
    this.getContentPane().add(jScrollPane1, BorderLayout.CENTER);
  }
  void jButton2_actionPerformed(ActionEvent e)
  {
    this.dispose();
  }
}