package testsystem;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JTextField;
import java.awt.Rectangle;
import javax.swing.JPasswordField;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;

public class LoginFrom extends JFrame {
    JPanel contentPane;
    JTextField name = new JTextField();
    JPasswordField psw = new JPasswordField();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JLabel jLabel1 = new JLabel();
    TestSystemFrom MianFrom =new TestSystemFrom();
    TestSystemFrom MianFrom1 =new TestSystemFrom();
    JLabel name1 = new JLabel();
    JLabel psw1 = new JLabel();
    public LoginFrom() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        this.setResizable(false);
        setSize(new Dimension(384, 286));
        setTitle("登陸窗口");
        name.setBounds(new Rectangle(113, 60, 233, 29));
        psw.setBounds(new Rectangle(112, 110, 232, 28));
        jButton1.setBounds(new Rectangle(94, 189, 80, 31));
        jButton1.setText("確定");
        jButton1.addActionListener(new LoginFrom_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(245, 191, 80, 30));
        jButton2.setText("退出");
        jButton2.addActionListener(new LoginFrom_jButton2_actionAdapter(this));
        jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel1.setText("開 始 登 陸");
        jLabel1.setFont(new java.awt.Font("隸書", Font.BOLD, 20));
        jLabel1.setBounds(new Rectangle(115, 12, 167, 28));
        name1.setHorizontalAlignment(SwingConstants.CENTER);
        name1.setText("用戶名：");
        name1.setBounds(new Rectangle(25, 58, 89, 31));
        psw1.setHorizontalAlignment(SwingConstants.CENTER);
        psw1.setText("密 碼：");
        psw1.setBounds(new Rectangle(25, 108, 88, 29));
        contentPane.setBackground(new Color(29, 183, 255));
        contentPane.add(jButton1);
        contentPane.add(jButton2);
        contentPane.add(jLabel1);
        contentPane.add(name1);
        contentPane.add(psw1);
        contentPane.add(psw);
        contentPane.add(name);
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        int p=JOptionPane.showConfirmDialog(null,"您確認要退出嗎？","提示",JOptionPane.YES_NO_OPTION);
        if(p==0)
        {
            System.exit(0);
        }
        else
        {
            return;
        }
    }

    public void jButton1_actionPerformed(ActionEvent e) {
          String Name=name.getText().trim();
          String pwd=new String(psw.getPassword()).trim();
          Connection con=null;
          Statement s=null;
          ResultSet rs=null;

          if(Name.length()!=0&&pwd.length()!=0)
          {
              try
          {
              con=DBcon.link();
              s=con.createStatement();
              rs=s.executeQuery("select * from Login where Name='"+Name+"'");
              if(rs.next())
              {
                  String ming=rs.getString("Name");
                  String Psw=rs.getString("PassWord");
                 // int num=rs.getInt("ID");
                  String shenfen=rs.getString("Grade");
                  if(Name.equals(ming)&&pwd.equals(Psw)&&shenfen.equals("教師"))
                  {
                      JOptionPane.showMessageDialog(null,"登陸成功！您的身份是教師！");
                      MianFrom.setBounds(new Rectangle(190, 120, 700, 570));
                      MianFrom.kaoshi.setEnabled(false);
                      MianFrom.jMenuItem5.setEnabled(false);
                      MianFrom.jMenuItem6.setEnabled(false);
                      this.setVisible(false);
                      MianFrom.show();
                  }
                  else if(Name.equals(ming)&&pwd.equals(Psw)&&shenfen.equals("學生"))
                  {
                      JOptionPane.showMessageDialog(null,"登陸成功！您的身份是學生！");
                       MianFrom1.setBounds(190,120,700,570);
                       MianFrom1.jiaoshi.setEnabled(false);
                       MianFrom1.jm1.setEnabled(false);
                       MianFrom1.jm2.setEnabled(false);
                       MianFrom1.jm3.setEnabled(false);
                       MianFrom1.jm4.setEnabled(false);
                       this.setVisible(false);
                       MianFrom1.show();
                  }
                  else
                  {
                       JOptionPane.showMessageDialog(null,"用戶名或密碼錯誤或不是軟件用戶！");
                  }
              }
              else
              {
                  JOptionPane.showMessageDialog(null,"該用戶不存在！","錯誤",JOptionPane.ERROR_MESSAGE);
              }
          }
          catch(SQLException co)
          {
              JOptionPane.showMessageDialog(null,"連接出錯！"+co.getMessage());
          }

          }
          else
          {
              JOptionPane.showMessageDialog(null,"請輸入用戶名和密碼！");
          }
    }
}


class LoginFrom_jButton1_actionAdapter implements ActionListener {
    private LoginFrom adaptee;
    LoginFrom_jButton1_actionAdapter(LoginFrom adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}


class LoginFrom_jButton2_actionAdapter implements ActionListener {
    private LoginFrom adaptee;
    LoginFrom_jButton2_actionAdapter(LoginFrom adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton2_actionPerformed(e);
    }
}