package xscjgl;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JMenuBar;
import javax.swing.JMenu;
import javax.swing.JMenuItem;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import com.borland.dx.sql.dataset.QueryDescriptor;
import com.borland.dx.sql.dataset.Load;
import java.sql.ResultSet;
import javax.swing.JOptionPane;

/**
 * <p>Title: java xscjgl</p>
 *
 * <p>Description:學生查成績，管理員輸成績、管理。二種權限的學生成績管理系統 </p>
 *
 * <p>Copyright: lixing (c) 2006</p>
 *
 *
 * @author 04級計算機教育班 黎興
 * @version 1.0
 */
public class main extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    public String userNumber;
    public String passWord;
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenu1 = new JMenu();
    JMenu jMenu2 = new JMenu();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenu jMenu3 = new JMenu();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem5 = new JMenuItem();
    JMenuItem jMenuItem6 = new JMenuItem();
    public main() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(borderLayout1);
        this.setJMenuBar(jMenuBar1);
        this.setSize(new Dimension(500,400));
        jMenu1.setText("系統管理");
        jMenu2.setText("系統查詢");
        jMenuItem1.setText("信息查詢");
        jMenuItem1.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                jMenuItem1_actionPerformed(e);
            }
        });
        jMenu3.setText("成績管理");
        jMenuItem2.setText("成績錄入");
        jMenuItem2.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                jMenuItem2_actionPerformed(e);
            }
        });
        jMenuItem3.setText("成績查詢");
        jMenuItem3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(ActionEvent e) {
                jMenuItem3_actionPerformed(e);
            }
        });

        jMenuItem4.setText("修改密碼");
        jMenuItem4.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                jMenuItem4_actionPerformed(e);
            }
        });
        jMenuItem5.setText("重新登陸");
        jMenuItem5.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                jMenuItem5_actionPerformed(e);
            }
        });
        jMenuItem6.setText("退出系統");
        jMenuItem6.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                jMenuItem6_actionPerformed(e);
            }
        });
        jMenuBar1.add(jMenu1);
        jMenuBar1.add(jMenu2);
        jMenuBar1.add(jMenu3);
        jMenu2.add(jMenuItem1);
        jMenu3.add(jMenuItem2);
        jMenu3.add(jMenuItem3);
        jMenu1.add(jMenuItem4);
        jMenu1.add(jMenuItem5);
        jMenu1.add(jMenuItem6);
    }

    public static void main(String[] args) {
        main mianFrame = new main();
        mianFrame.setVisible(true);
        mianFrame.setLocationRelativeTo(null);

    }

    public void jMenuItem3_actionPerformed(ActionEvent e) {
        Query_Grade_Frame queryGrade = new Query_Grade_Frame();
        queryGrade.setVisible(true);
        queryGrade.setLocationRelativeTo(null);
        queryGrade.SNO = userNumber;
         //改變queryDataSet1執行結果
         try {
             queryGrade.queryDataSet1.close();
             queryGrade.queryDataSet1.setQuery(new QueryDescriptor(queryGrade.
                     database1,
                     "select * from gradeQuery where Sno='"+userNumber+"'", null, true,
                     Load.ALL));
             queryGrade.queryDataSet1.refresh();
             Grade_CountInformation countInformation = new
                     Grade_CountInformation();
             countInformation.setCountInformation(userNumber);
             //總分
             queryGrade.jTextField1.setText(String.valueOf(countInformation.getCountSum()));
             //平均分
             queryGrade.jTextField2.setText(String.valueOf(countInformation.getCountAvg()));

         } catch (Exception ex) {
             System.out.print(ex.getMessage());
         }

    }

    public void jMenuItem2_actionPerformed(ActionEvent e) {
        inputGrade inputgrade = new inputGrade();
        inputgrade.setVisible(true);
        inputgrade.setLocationRelativeTo(null);
        inputgrade.setSize(new Dimension(425,390));

        Jdbcconn conn = new Jdbcconn();
        String strsql="select * from Course";
        try {
            conn.OpenConn("tqti", "tqti", "111111");
            ResultSet cs= conn.getResults(strsql);
            cs.beforeFirst();
            while(cs.next()){
             inputgrade.jComboBox1.addItem(cs.getString("Cname"));
           }
        } catch (Exception ex) {
            JOptionPane.showMessageDialog(null, "catch first");
        } //end try catch

    }

    public void jMenuItem1_actionPerformed(ActionEvent e) {
        search search = new search();
        search.setVisible(true);
        search.setLocationRelativeTo(null);
        search.setSize(new Dimension(455,355));
    }

    public void jMenuItem5_actionPerformed(ActionEvent e) {
        login Login_Frame = new login();
        Login_Frame.setVisible(true);
        Login_Frame.setLocationRelativeTo(null);

    }

    public void jMenuItem6_actionPerformed(ActionEvent e) {
        System.exit(0);
    }

    public void jMenuItem4_actionPerformed(ActionEvent e) {
        PasswordEdit_Frame passwordFrame = new PasswordEdit_Frame();
        passwordFrame.setVisible(true);
        passwordFrame.setTitle("修改用戶密碼");
        //將用戶名傳給passwordFrame
        passwordFrame.BeforeUno=userNumber;
        // Center the window,窗體居中
        passwordFrame.setLocationRelativeTo(null);
        passwordFrame.setSize(new Dimension(400,400));

    }
}