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

public class StuOperate extends JFrame{
	boolean login = false;
    JPanel contentPane;
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenuFile = new JMenu();
    JMenuItem jMenuFileExit = new JMenuItem();
    JMenu jMenuHelp = new JMenu();
    JMenuItem jMenuHelpAbout = new JMenuItem();
    Label label1 = new Label();
    Label label2 = new Label();
    TextField textField1 = new TextField();
    TextField textField2 = new TextField();
    Button button1 = new Button();
    Label label3 = new Label();
    Button button2 = new Button();
    Button button3 = new Button();
    Button button4 = new Button();
    //Button button5 = new Button();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem5 = new JMenuItem();
    Label label4 = new Label();

  //Construct the frame
    public StuOperate(){
    	enableEvents(AWTEvent.WINDOW_EVENT_MASK);
        try{
        	Init();
        }catch(Exception e){e.printStackTrace();}
    }

  //Component initialization
    private void Init()throws Exception{
    	contentPane = (JPanel)this.getContentPane();
        contentPane.setLayout(null);
        this.setForeground(Color.black);
        this.setResizable(false);
        this.setSize(new Dimension(400, 300));
        this.setTitle("學生學籍管理系統");
        jMenuFile.setVerifyInputWhenFocusTarget(true);
        jMenuFile.setActionCommand("文件");
        jMenuFile.setText("文件");
        jMenuFileExit.setText("退出");
        jMenuFileExit.addActionListener(new StuOperate_ActionAdapter(this));
        jMenuHelp.setText("幫助");
        jMenuHelpAbout.setText("關于");
        jMenuHelpAbout.addActionListener(new StuOperate_ActionAdapter(this));
        contentPane.setEnabled(false);
        contentPane.setOpaque(true);
        contentPane.setPreferredSize(new Dimension(1, 1));
        contentPane.setRequestFocusEnabled(true);
        jMenuBar1.setEnabled(true);
        jMenuBar1.setBorderPainted(true);
    //  jButton2.setFont(new java.awt.Font("Dialog", 1, 11));
        /*label1.setFont(new java.awt.Font("Dialog", 1, 15));
        label1.setText("用  戶:");
        label1.setBounds(new Rectangle(123, 25, 49, 16));
        label2.setBounds(new Rectangle(123, 62, 49, 16));
        label2.setText("密  碼:");
        label2.setFont(new java.awt.Font("Dialog", 1, 15));
        textField1.setText("");
        textField1.setBounds(new Rectangle(192, 24, 62, 18));
        textField2.setBounds(new Rectangle(192, 61, 62, 18));
        textField2.setEchoChar('*');
        textField2.setText("");
        button1.setFont(new java.awt.Font("Dialog", 1, 15));
        button1.setLabel("進入系統");*/
        button1.setBounds(new Rectangle(150, 104, 101, 22));
        button1.addActionListener(new StuOperate_ActionAdapter(this));
        label3.setFont(new java.awt.Font("Dialog", 1, 15));
        label3.setForeground(Color.blue);
        label3.setText("請選擇操作項");
        label3.setVisible(false);
        label3.setBounds(new Rectangle(158, 92, 84, 16));
        button2.setFont(new java.awt.Font("Dialog", 1, 15));
        button2.setLabel("添加信息");
        button2.setVisible(false);
        button2.setBounds(new Rectangle(74, 136, 97, 33));
        button3.setBounds(new Rectangle(226, 136, 97, 33));
        button3.setLabel("修改信息");
        button3.setVisible(false);
        button3.setFont(new java.awt.Font("Dialog", 1, 15));
        button4.setBounds(new Rectangle(74, 185, 97, 33));
        button4.setLabel("信息查詢");
        button4.setVisible(false);
        button4.setFont(new java.awt.Font("Dialog", 1, 15));
        /*button5.setBounds(new Rectangle(226, 185, 97, 33));
        button5.setLabel("刪除信息");
        button5.setVisible(false);
        button5.setFont(new java.awt.Font("Dialog", 1, 15));*/
        jMenuItem1.setText("添加信息");
        jMenuItem2.setText("信息查詢");
        jMenuItem3.setText("修改信息");
        //jMenuItem4.setText("刪除信息");
        jMenuItem5.setText("幫助");
        label4.setFont(new java.awt.Font("Dialog", 1, 30));
        label4.setText("學生學籍管理系統");
        label4.setVisible(false);
        label4.setBounds(new Rectangle(70, 37, 261, 33));
        jMenuFile.add(jMenuItem1);
        jMenuItem1.setEnabled(false);
        jMenuItem1.addActionListener(new StuOperate_ActionAdapter(this));
        jMenuItem2.setEnabled(false);
        jMenuFile.add(jMenuItem2);
        jMenuItem2.addActionListener(new StuOperate_ActionAdapter(this));
        jMenuItem3.setEnabled(false);
        jMenuFile.add(jMenuItem3);
        jMenuItem3.addActionListener(new StuOperate_ActionAdapter(this));
        jMenuItem4.setEnabled(false);
        jMenuFile.add(jMenuItem4);
        jMenuItem4.addActionListener(new StuOperate_ActionAdapter(this));
        jMenuFile.add(jMenuFileExit);
        jMenuHelp.add(jMenuItem5);
        jMenuHelp.add(jMenuHelpAbout);
        jMenuBar1.add(jMenuFile);
        jMenuBar1.add(jMenuHelp);
        contentPane.add(label1, null);
        contentPane.add(label2, null);
        contentPane.add(textField1, null);
        contentPane.add(textField2, null);
        contentPane.add(label3, null);
        contentPane.add(button2, null);
        button2.addActionListener(new StuOperate_ActionAdapter(this));
        //contentPane.add(button4, null);
        //button4.addActionListener(new MainFrame_ActionAdapter(this));
        contentPane.add(button3, null);
        button3.addActionListener(new StuOperate_ActionAdapter(this));
        //contentPane.add(button5, null);
        //button5.addActionListener(new StuOperate_ActionAdapter(this));
        contentPane.add(button1, null);
        contentPane.add(label4, null);
        this.setJMenuBar(jMenuBar1);
    }

  //File | Exit action performed
    public void jMenuFileExit_actionPerformed(ActionEvent e){
    	System.exit(0);
    }

  //Help | About action performed
    public void jMenuHelpAbout_actionPerformed(ActionEvent e){}

  //Overridden so we can exit when window is closed
    protected void processWindowEvent(WindowEvent e){
    	super.processWindowEvent(e);
        if (e.getID() == WindowEvent.WINDOW_CLOSING){
        	jMenuFileExit_actionPerformed(null);
        }
    }

    void button1_actionPerformed(ActionEvent e){
    	String user = textField1.getText().trim();
        String pass = textField2.getText().trim();
        try{
        	String strurl =
                 "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/student.mdb";
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection conn = DriverManager.getConnection(strurl);
            Statement stmt = conn.createStatement();
            /*if (user.equals("")|| pass.equals(""))
            JOptionPane.showMessageDialog(null, "用戶名或密碼不能為空", "警告",
                                      JOptionPane.WARNING_MESSAGE);
            else {
            	ResultSet rs = stmt.executeQuery("select * from admin where username='" +
                                             user + "' AND password='" + pass + "'");
                if(rs.next()){
                	//JOptionPane.showMessageDialog(null, "登陸成功");
                    login = true;
                    label1.setVisible(false);
                    textField1.setVisible(false);
                    label2.setVisible(false);
                    textField2.setVisible(false);
                    button1.setVisible(false);
                    label3.setVisible(true);
                    label4.setVisible(true);
                    button2.setVisible(true);
                    button3.setVisible(true);
                    //button4.setVisible(true);
                    button5.setVisible(true);
                    jMenuItem1.setEnabled(true);
                    jMenuItem2.setEnabled(true);
                    jMenuItem3.setEnabled(true);
                    jMenuItem4.setEnabled(true);
                }
                else
                   JOptionPane.showMessageDialog(null, "登陸失敗", "警告",
                                        JOptionPane.WARNING_MESSAGE);
            }*/
        }catch(Exception eg){eg.printStackTrace();}
    }
}

class StuOperate_ActionAdapter implements ActionListener{
	StuOperate adaptee;

    StuOperate_ActionAdapter(StuOperate adaptee){
    	this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e){
    	if (e.getSource() == adaptee.jMenuFileExit)
        adaptee.jMenuFileExit_actionPerformed(e);
        else if(e.getSource() == adaptee.jMenuItem1||e.getSource()==adaptee.button2){
        	Add add = new Add();
            add.setSize(400, 300);
            add.setVisible(true);
        }
        else if(e.getSource() == adaptee.jMenuItem3||e.getSource()==adaptee.button3){
        	Change change= new Change();
            change.setSize(400, 300);
            change.setVisible(true);
        }
        else if(e.getSource()==adaptee.jMenuItem2||e.getSource()==adaptee.button4){
        	Search search = new Search();
            search.setSize(400, 300);
            search.setVisible(true);
        }
        /*else if(e.getSource()==adaptee.jMenuItem4||e.getSource()==adaptee.button5){
        	Delet del= new Delet();
            delet.setSize(400, 300);
            delet.setVisible(true);
        }*/
        else if(e.getSource()==adaptee.jMenuHelpAbout)adaptee.jMenuHelpAbout_actionPerformed(e);
        else if (e.getSource() == adaptee.button1)
            adaptee.button1_actionPerformed(e);
    }
}