package studentms;

import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.math.*;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class gradeInfo extends JFrame {
  XYLayout xYLayout1 = new XYLayout();
  XYLayout xYLayout2 = new XYLayout();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  XYLayout xYLayout3 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JTextField jTNum = new JTextField();
  JTextField jTTotal = new JTextField();
  JTextField jTChinese = new JTextField();
  JTextField jTMath = new JTextField();
  JTextField jTEnglish = new JTextField();
  JTextField jTComposite = new JTextField();
  JButton jBCancel = new JButton();
  JButton jBDelete = new JButton();
  JButton jBModify = new JButton();
  JButton jBSave = new JButton();
  JButton jBAdd = new JButton();
  JButton jBSee = new JButton();
  JButton jBSearch = new JButton();
  JButton jBSum = new JButton();
  JButton jBPeople = new JButton();
  JButton jBExit = new JButton();

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

  public gradeInfo() {
    try {
      jbInit();
    }

    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    this.getContentPane().setLayout(xYLayout2);
    jPanel1.setLayout(xYLayout3);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel1.setText("學號：");
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel2.setText("總分：");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel3.setText("語文：");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel4.setText("數學：");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel5.setText("外語：");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel6.setText("綜合：");
    xYLayout2.setWidth(382);
    xYLayout2.setHeight(260);
    jTNum.setFont(new java.awt.Font("Dialog", 0, 12));
    jTNum.setText("");
    jTChinese.setFont(new java.awt.Font("Dialog", 0, 12));
    jTChinese.setText("");
    jTEnglish.setFont(new java.awt.Font("Dialog", 0, 12));
    jTEnglish.setText("");
    jTComposite.setFont(new java.awt.Font("Dialog", 0, 12));
    jTComposite.setText("");
    jTMath.setFont(new java.awt.Font("Dialog", 0, 12));
    jTMath.setText("");
    jTTotal.setEnabled(false);
    jTTotal.setFont(new java.awt.Font("Dialog", 0, 12));
    jTTotal.setText("");
    jBCancel.setFont(new java.awt.Font("Dialog", 0, 12));
    jBCancel.setMargin(new Insets(2, 2, 2, 2));
    jBCancel.setText("取消");
    jBCancel.addActionListener(new gradeInfo_jBCancel_actionAdapter(this));
    jBDelete.setFont(new java.awt.Font("Dialog", 0, 12));
    jBDelete.setActionCommand("");
    jBDelete.setMargin(new Insets(2, 2, 2, 2));
    jBDelete.setText("刪除");
    jBDelete.addActionListener(new gradeInfo_jBDelete_actionAdapter(this));
    jBModify.setFont(new java.awt.Font("Dialog", 0, 12));
    jBModify.setMargin(new Insets(2, 2, 2, 2));
    jBModify.setText("修改");
    jBModify.addActionListener(new gradeInfo_jBModify_actionAdapter(this));
    jBSave.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSave.setMargin(new Insets(2, 2, 2, 2));
    jBSave.setText("保存");
    jBSave.addActionListener(new gradeInfo_jBSave_actionAdapter(this));
    jBAdd.setFont(new java.awt.Font("Dialog", 0, 12));
    jBAdd.setMargin(new Insets(2, 2, 2, 2));
    jBAdd.setText("新增");
    jBAdd.addActionListener(new gradeInfo_jBAdd_actionAdapter(this));
    this.setTitle("成績管理");
    jBSee.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSee.setMargin(new Insets(2, 2, 2, 2));
    jBSee.setText("查看資料");
    jBSee.addActionListener(new gradeInfo_jBSee_actionAdapter(this));
    jBSearch.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSearch.setMargin(new Insets(2, 2, 2, 2));
    jBSearch.setText("查  詢");
    jBSearch.addActionListener(new gradeInfo_jBSearch_actionAdapter(this));
    jBSum.setFont(new java.awt.Font("Dialog", 0, 12));
    jBSum.setMargin(new Insets(2, 2, 2, 2));
    jBSum.setText("成績統計");
    jBSum.addActionListener(new gradeInfo_jBSum_actionAdapter(this));
    jBPeople.setFont(new java.awt.Font("Dialog", 0, 12));
    jBPeople.setMargin(new Insets(2, 2, 2, 2));
    jBPeople.setText("人員管理");
    jBPeople.addActionListener(new gradeInfo_jBPeople_actionAdapter(this));
    jBExit.setFont(new java.awt.Font("Dialog", 0, 12));
    jBExit.setMargin(new Insets(2, 2, 2, 2));
    jBExit.setText("退出");
    jBExit.addActionListener(new gradeInfo_jBExit_actionAdapter(this));
    jPanel1.add(jPanel2,  new XYConstraints(149, 5, -1, -1));
    jPanel1.add(jTComposite, new XYConstraints(226, 152, 72, 20));
    jPanel1.add(jLabel5, new XYConstraints(25, 152, 39, 19));
    jPanel1.add(jTEnglish, new XYConstraints(75, 152, 72, 20));
    jPanel1.add(jLabel6, new XYConstraints(175, 152, 41, -1));
    jPanel1.add(jBSee, new XYConstraints(94, 16, 65, 23));
    jPanel1.add(jBSearch, new XYConstraints(21, 16, 65, 23));
    jPanel1.add(jBSum, new XYConstraints(167, 16, 65, 23));
    jPanel1.add(jBPeople, new XYConstraints(240, 16, 65, 23));
    jPanel1.add(jTMath, new XYConstraints(226, 110, 72, 20));
    jPanel1.add(jLabel3, new XYConstraints(25, 110, -1, 22));
    jPanel1.add(jTChinese, new XYConstraints(75, 110, 72, 20));
    jPanel1.add(jLabel4, new XYConstraints(175, 110, 42, 17));
    jPanel1.add(jTTotal, new XYConstraints(225, 67, 72, 20));
    jPanel1.add(jLabel1, new XYConstraints(24, 67, 43, 23));
    jPanel1.add(jTNum, new XYConstraints(74, 67, 72, 20));
    jPanel1.add(jLabel2, new XYConstraints(174, 67, 40, 20));
    jPanel1.add(jBCancel, new XYConstraints(217, 199, 43, 23));
    jPanel1.add(jBAdd, new XYConstraints(18, 199, 43, 23));
    jPanel1.add(jBModify, new XYConstraints(68, 199, 43, 23));
    jPanel1.add(jBDelete, new XYConstraints(119, 199, 43, 23));
    jPanel1.add(jBSave, new XYConstraints(168, 199, 43, 23));
    jPanel1.add(jBExit, new XYConstraints(268, 199, 43, 23));
    this.getContentPane().add(jPanel1,  new XYConstraints(25, 14, 348, 238));
    nullSet();
  }

  //設置文本框是否可編輯
  void setAbled(boolean logic){
    jTNum.setEnabled(logic);
    jTChinese.setEnabled(logic);
    jTMath.setEnabled(logic);
    jTEnglish.setEnabled(logic);
    jTComposite.setEnabled(logic);
  }

  //設置按鈕的狀態
  void setButton(boolean add,boolean xiugai,boolean del,boolean save,boolean cancel){
    jBAdd.setEnabled(add);
    jBModify.setEnabled(xiugai);
    jBDelete.setEnabled(del);
    jBSave.setEnabled(save);
    jBCancel.setEnabled(cancel);
  }

  //將文本框清空
  void setNull(){
    jTNum.setText(null);
    jTTotal.setText(null);
    jTChinese.setText(null);
    jTMath.setText(null);
    jTEnglish.setText(null);
    jTComposite.setText(null);
  }

  //設置操作類型
  void setExeType(String type){
    exeType=type;
  }

  //點擊添加按鈕
  void jBAdd_actionPerformed(ActionEvent e) {
    setExeType("addnew");
    this.setAbled(true);
    this.setButton(false,false,false,true,true);
    setNull();
  }

  //點擊取消按鈕
  void jBCancel_actionPerformed(ActionEvent e) {
    this.setAbled(false);
    if(exeType=="addnew"){
      this.setNull() ;
    }
    this.setButton(true,true,true,false,false);
    nullSet();
  }

  //顯示人員信息
  void seeInfo(){
      stuInfo result=new stuInfo();
      Dimension dlgSize = this.getPreferredSize();
      Dimension frmSize = getSize();
      Point loc = getLocation();
      result.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
      result.pack();
      result.show() ;
      result.setAbled(false);
      result.setButton(true,true,true,false,false);
      try{
        result.jTNum.setText(rs.getString("Num"));
        result.jTName.setText(rs.getString("Name"));
        result.jTSex.setText(rs.getString("Sex"));
        result.jTHome.setText(rs.getString("Home"));
        result.jTClass.setText(rs.getString("Class"));
        result.jTEthnic.setText(rs.getString("Ethnic"));
        result.jTBirth.setText(rs.getString("Birthday"));
      }
      catch(SQLException ex){
      }
  }
  void nullSet(){
    if(jTNum.getText().equals("")){
         jBModify.setEnabled(false);
         jBDelete.setEnabled(false);
         jBSee.setEnabled(false);
    }
    else{
         jBModify.setEnabled(true);
         jBDelete.setEnabled(true);
         jBSee.setEnabled(true);
    }
  }


  //點擊保存按鈕
  void jBSave_actionPerformed(ActionEvent e) {
        int total;
        String sql;
        if(exeType=="addnew"){
          if (jTNum.getText().toString().equals("")) {
            JOptionPane.showMessageDialog(null, "學號不能為空");
          }
          else if(jTChinese.getText().toString().equals("")){
             JOptionPane.showMessageDialog(null, "語文成績不能為空");
          }
          else if(jTMath.getText().toString().equals("")){
             JOptionPane.showMessageDialog(null, "數學成績不能為空");