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

public class UserLogin
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  MainFrame mainFrame;
  JPanel panel1, panel2;
  JLabel UserLabel, PasswordLabel;
  JTextField UserTextField;
  JPasswordField PasswordTextField;
  JButton YesBtn, CancelBtn;
  Container c;
  ResultSet rs;
  public UserLogin(MainFrame mainFrame) {
    super("用戶登錄");
    this.mainFrame = mainFrame;
    UserLabel = new JLabel("用戶名", JLabel.CENTER);
    PasswordLabel = new JLabel("密碼", JLabel.CENTER);
    UserTextField = new JTextField(10);
    PasswordTextField = new JPasswordField(10);
    YesBtn = new JButton("確定");
    CancelBtn = new JButton("取消");
    YesBtn.addActionListener(this);
    CancelBtn.addActionListener(this);
    panel1 = new JPanel();
    panel1.setLayout(new GridLayout(2, 2));
    panel2 = new JPanel();
    c = getContentPane();
    c.setLayout(new BorderLayout());
    panel1.add(UserLabel);
    panel1.add(UserTextField);
    panel1.add(PasswordLabel);
    panel1.add(PasswordTextField);
    c.add(panel1, BorderLayout.CENTER);
    panel2.add(YesBtn);
    panel2.add(CancelBtn);
    c.add(panel2, BorderLayout.SOUTH);
    setSize(300, 300);
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == CancelBtn) {
      mainFrame.setEnable("else");
      this.dispose();
    }
    else {
      char[] password = PasswordTextField.getPassword();
      String passwordSTR = new String(password);
      if (UserTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "用戶名不可為空!");
        return;
      }
      if (passwordSTR.equals("")) {
        JOptionPane.showMessageDialog(null, "密碼不可為空!");
        return;
      }
      String strSQL;
      strSQL = "select * from usertable where UserName='" +
          UserTextField.getText().trim() + "'and Password='" +
          passwordSTR + "'";
      rs = db.getResult(strSQL);
      boolean isExist = false;
      try {
        isExist = rs.first();
      }
      catch (SQLException sqle) {
        System.out.println(sqle.toString());
      }
      if (!isExist) {
        JOptionPane.showMessageDialog(null, "用戶名不存在或者密碼不正確!");
        mainFrame.setEnable("else");
      }
      else {
        try {
          rs.first();
          mainFrame.setEnable(rs.getString("power").trim());
          db.closeConnection();
          this.dispose();
        }
        catch (SQLException sqle2) {
          System.out.println(sqle2.toString());
        }
      }

    }
  }
}