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.*;
import java.math.*;


public class sumGrade extends JFrame {
   XYLayout xYLayout1 = new XYLayout();
   JLabel jLabel1 = new JLabel();
   JComboBox jCType = new JComboBox();
   JButton jBOK = new JButton();
   JButton jBExit = new JButton();
   JLabel jLabel2 = new JLabel();
   JLabel jLabel3 = new JLabel();
   JLabel jLabel4 = new JLabel();
   JTextField jTMin = new JTextField();
   JTextField jTMax = new JTextField();

   Database DB=new Database();
   ResultSet rs ;
   String sql=new String();

   String sumType=new String();


  public sumGrade() {
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel1.setText("選擇統計選項：");
    xYLayout1.setWidth(310);
    xYLayout1.setHeight(146);
    this.getContentPane().setLayout(xYLayout1);
    jBOK.setFont(new java.awt.Font("Dialog", 0, 12));
    jBOK.setText("確  定");
    jBOK.addActionListener(new sumGrade_jBOK_actionAdapter(this));
    jBExit.setFont(new java.awt.Font("Dialog", 0, 12));
    jBExit.setText("取  消");
    jBExit.addActionListener(new sumGrade_jBExit_actionAdapter(this));
    jCType.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setText("請輸入統計范圍：");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setText("從");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setText("至");
    jTMax.setText("");
    jTMin.setText("");
    this.setTitle("成績統計");
    jCType.addItem("總分");
    jCType.addItem("語文");
    jCType.addItem("數學");
    jCType.addItem("英語");
    jCType.addItem("綜合");
    jCType.setSelectedIndex(-1);
    this.getContentPane().add(jCType,     new XYConstraints(28, 57, 92, 23));
    this.getContentPane().add(jLabel1,  new XYConstraints(29, 26, 94, 21));
    this.getContentPane().add(jBOK,   new XYConstraints(63, 103, 74, 26));
    this.getContentPane().add(jBExit,   new XYConstraints(167, 104, 74, 26));
    this.getContentPane().add(jLabel2,      new XYConstraints(140, 26, 99, -1));
    this.getContentPane().add(jTMin, new XYConstraints(155, 57, 40, 23));
    this.getContentPane().add(jLabel3, new XYConstraints(138, 60, 14, 20));
    this.getContentPane().add(jLabel4, new XYConstraints(203, 59, 15, 19));
    this.getContentPane().add(jTMax, new XYConstraints(225, 57, 40, 23));
  }

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

  //顯示統計結果
 void listShow(){
   gradeShow gradeList=new gradeShow();
   Dimension dlgSize = gradeList.getPreferredSize();
   Dimension frmSize = getSize();
   Point loc = getLocation();
   gradeList.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
   gradeList.pack();
   gradeList.show() ;
   gradeList.resultShow(rs);
 }

 //統計
 void jBOK_actionPerformed(ActionEvent e) {
   sql="select * from gradeTable ";
        //根據選項判斷查詢的類型
         if (jCType.getSelectedIndex() ==0){
           sumType="Total";
         }
         else if(jCType.getSelectedIndex() ==1){
           sumType="Chinese";
         }
         else if(jCType.getSelectedIndex() ==2){
           sumType="Math";
         }
         else if(jCType.getSelectedIndex() ==3){
           sumType="English";
         }
         else if(jCType.getSelectedIndex() ==4){
           sumType="Composite";
         }

        if(jTMin.getText().equals("")&&jTMax.getText().equals("")){
           JOptionPane.showMessageDialog(null, "統計范圍不能為空！");
        }
        else if(jTMin.getText().equals("")){
           sql=sql+"where"+sumType+"<="+Integer.parseInt(jTMax.getText()) ;
        }
        else if(jTMax.getText().equals("")){
          sql=sql+"where "+sumType+">="+Integer.parseInt(jTMin.getText()) ;
        }
        else{
          sql=sql+"where "+sumType+">="+Integer.parseInt(jTMin.getText()) ;
          sql=sql+"and "+sumType+"<="+Integer.parseInt(jTMax.getText()) ;
        }


         rs =DB.getResult(sql);
         try{
              if(rs.first()){            //判斷記錄是否存在
                     listShow();
                     this.dispose() ;
               }
               else{
                    JOptionPane.showMessageDialog(null, "無滿足條件的記錄！");
               }
           }
           catch (SQLException ex) {
                JOptionPane.showMessageDialog(null," failed!");
           }
 }

}

class sumGrade_jBExit_actionAdapter implements java.awt.event.ActionListener {
  sumGrade adaptee;

  sumGrade_jBExit_actionAdapter(sumGrade adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBExit_actionPerformed(e);
  }
}

class sumGrade_jBOK_actionAdapter implements java.awt.event.ActionListener {
  sumGrade adaptee;

  sumGrade_jBOK_actionAdapter(sumGrade adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jBOK_actionPerformed(e);
  }
}