package supermarket;
import DB.*;
import java.awt.BorderLayout;
import java.awt.Dimension;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import javax.swing.JButton;
import javax.swing.ImageIcon;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.*;
import java.io.*;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;
import java.sql.ResultSet;
import java.sql.*;
import java.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class LandFrm
    extends JDialog {
  JPanel contentPane;
  JLabel lbltitle = new JLabel();
  JLabel lblname = new JLabel();
  JLabel lblpsw = new JLabel();
  JTextField txtname = new JTextField();
  JPasswordField txtpsw = new JPasswordField();
  JButton btndenglu = new JButton();
  JButton btnquexiao = new JButton();
  JButton btnjiangp = new JButton();
  MainFrm frm=null;
  JButton btnxiugai = new JButton();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JPanel jPanel3 = new JPanel();
  public LandFrm(MainFrm frm) {
    try {
      this.frm = frm;
      if(frm!=null){
       setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      }
      jbInit();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  public LandFrm() { //默認構造方法
    try {
     // setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
    }
    catch (Exception ex) {
    }
  }

  /**
   * Component initialization.
   *
   * @throws java.lang.Exception
   */
  private void jbInit() throws Exception {
    contentPane = (JPanel) getContentPane();
    contentPane.setLayout(null);
    setSize(new Dimension(400, 247));
    this.addWindowListener(new LandFrm_this_windowAdapter(this));
    setTitle("登陸");
    lbltitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 30));
    lbltitle.setForeground(SystemColor.menuText);
    lbltitle.setText("先鋒超市管理系統");
    lbltitle.setBounds(new Rectangle(65, 0, 270, 51));
    lblname.setFont(new java.awt.Font("新細明體", Font.BOLD, 20));
    lblname.setForeground(SystemColor.windowBorder);
    lblname.setText("用戶名:");
    lblname.setBounds(new Rectangle(40, 19, 72, 16));
    lblpsw.setFont(new java.awt.Font("新細明體", Font.BOLD, 20));
    lblpsw.setForeground(SystemColor.controlText);
    lblpsw.setText("密   碼:");
    lblpsw.setBounds(new Rectangle(40, 71, 72, 16));
    txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtname.setText("");
    txtname.setBounds(new Rectangle(155, 17, 178, 21));
    txtname.addKeyListener(new LandFrm_txtname_keyAdapter(this));
    txtpsw.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    txtpsw.setText("");
    txtpsw.setBounds(new Rectangle(155, 69, 178, 21));
    txtpsw.addKeyListener(new LandFrm_txtpsw_keyAdapter(this));
    txtpsw.addActionListener(new LandFrm_txtpsw_actionAdapter(this));
    btndenglu.setBounds(new Rectangle(28, 179, 114, 25));
    btndenglu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btndenglu.setText("登陸");
    btndenglu.addKeyListener(new LandFrm_jButton1_keyAdapter(this));
    btndenglu.addActionListener(new LandFrm_jButton1_actionAdapter(this));
    btnquexiao.setBounds(new Rectangle(144, 179, 114, 25));
    btnquexiao.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnquexiao.setText("取消");
    btnquexiao.addActionListener(new LandFrm_jButton2_actionAdapter(this));
    btnjiangp.setBounds(new Rectangle(352, 70, 25, 21));
    btnjiangp.setText(".....");
    btnjiangp.addActionListener(new LandFrm_btnjiangp_actionAdapter(this));
    contentPane.setBackground(SystemColor.scrollbar);
    btnxiugai.setBounds(new Rectangle(260, 179, 114, 25));
    btnxiugai.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btnxiugai.setText("修改密碼");
    btnxiugai.addActionListener(new LandFrm_btnxiugai_actionAdapter(this));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(0, 2, 393, 49));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(0, 52, 393, 115));
    jPanel2.setLayout(null);
    jLabel1.setForeground(Color.red);
    jLabel1.setText("*");
    jLabel1.setBounds(new Rectangle(334, 16, 51, 23));
    jLabel2.setForeground(Color.red);
    jLabel2.setText("*");
    jLabel2.setBounds(new Rectangle(334, 68, 21, 23));
    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setBounds(new Rectangle(0, 166, 393, 53));
    jPanel3.setLayout(null);
    contentPane.add(jPanel2);
    jPanel2.add(lblname);
    jPanel2.add(txtname);
    jPanel2.add(txtpsw);
    jPanel2.add(lblpsw);
    jPanel2.add(jLabel1);
    jPanel2.add(jLabel2);
    jPanel2.add(btnjiangp);
    contentPane.add(lbltitle, null);
    contentPane.add(jPanel1);
    contentPane.add(btnquexiao);
    contentPane.add(btnxiugai);
    contentPane.add(btndenglu);
    contentPane.add(jPanel3);
    this.setResizable(false); //固定窗口大小
    this.setModal(true);

    //背景圖
  /*
    ImageIcon img2 = new ImageIcon("img/denglu.jpg");
    btndenglu.setIcon(img2);*/
  }

  public void jButton2_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  public void jButton1_actionPerformed(ActionEvent e) {
    //登錄
    String name = txtname.getText().trim(); //獲取用戶名
    String mima = String.valueOf(txtpsw.getPassword()); //獲取密碼
    if (name.equals("") || mima.equals("")) {
      JOptionPane.showMessageDialog(null, "用戶或密碼不能為空", "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
    int i = 0;
    Link lk = new Link();
    lk.connection();
    String sql = "select purview from usertitle where username='" + name +
        "' and password='" + mima + "'";
    ResultSet rs = lk.Select(sql); //調用
    try {
      if (rs.next()) {
        i = rs.getInt(1); //存數據庫中用戶表的權限
      }
      else {
        JOptionPane.showMessageDialog(null, "非法的用戶名", "錯誤",
                                      JOptionPane.ERROR_MESSAGE);
      }
    }
    catch (HeadlessException ex) {
      JOptionPane.showMessageDialog(null, "非法的用戶名", "錯誤",
                                      JOptionPane.ERROR_MESSAGE);
    }
    catch (SQLException ex) {
      JOptionPane.showMessageDialog(null, "非法的用戶名", "錯誤",
                                      JOptionPane.ERROR_MESSAGE);
    }
    try {
      rs.close();
    }
    catch (SQLException ex1) {
    }
    lk.close();//用戶驗證，判斷權限
    if (i == 1 || i == 2 || i == 3) {
      if(frm==null){
        MainFrm obj=new MainFrm(i);
        obj.setLocation(100, 100);
        obj.show();
      }
      else{
      frm.setData(i);
    }
      this.dispose();
    }

  }

  public void btnjiangp_actionPerformed(ActionEvent e) {
    try {
      Runtime.getRuntime().exec("osk");//調用屏幕鍵盤
    }
    catch (IOException ex) {
    }
  }

  public void btndenglu_keyPressed(KeyEvent e) {

  }

  public void btnxiugai_actionPerformed(ActionEvent e) {
Password pw=new Password();
    pw.setSize(400, 350); //彈出窗口大小
    pw.setLocation(300, 200); //彈出窗口位置
    pw.show();

  }



  public void txtpsw_keyPressed(KeyEvent e) {
//回車鍵
      if((int)e.getKeyChar()==10)
      {
      jButton1_actionPerformed(null);
      }
  }

  public void txtname_keyPressed(KeyEvent e) {
    if((int)e.getKeyChar()==10)
    {
    jButton1_actionPerformed(null);
      }
  }

  public void this_windowClosing(WindowEvent e) {
System.exit(0);//退出
  }

}

class LandFrm_this_windowAdapter
    extends WindowAdapter {
  private LandFrm adaptee;
  LandFrm_this_windowAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void windowClosing(WindowEvent e) {
    adaptee.this_windowClosing(e);
  }
}

class LandFrm_txtpsw_keyAdapter
    extends KeyAdapter {
  private LandFrm adaptee;
  LandFrm_txtpsw_keyAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtpsw_keyPressed(e);
  }
}

class LandFrm_txtpsw_actionAdapter
    implements ActionListener {
  private LandFrm adaptee;
  LandFrm_txtpsw_actionAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
  }
}

class LandFrm_btnxiugai_actionAdapter
    implements ActionListener {
  private LandFrm adaptee;
  LandFrm_btnxiugai_actionAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

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

class LandFrm_btnjiangp_actionAdapter
    implements ActionListener {
  private LandFrm adaptee;
  LandFrm_btnjiangp_actionAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

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

class LandFrm_jButton1_actionAdapter
    implements ActionListener {
  private LandFrm adaptee;
  LandFrm_jButton1_actionAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

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

class LandFrm_txtname_keyAdapter
    extends KeyAdapter {
  private LandFrm adaptee;
  LandFrm_txtname_keyAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtname_keyPressed(e);
  }
}

class LandFrm_jButton1_keyAdapter
    extends KeyAdapter {
  private LandFrm adaptee;
  LandFrm_jButton1_keyAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

}

class LandFrm_jButton2_actionAdapter
    implements ActionListener {
  private LandFrm adaptee;
  LandFrm_jButton2_actionAdapter(LandFrm adaptee) {
    this.adaptee = adaptee;
  }

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