package supermarket;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import DB.Link;
import java.sql.ResultSet;
import java.sql.*;
import java.beans.PropertyChangeEvent;
import java.beans.PropertyChangeListener;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Deluser
    extends JDialog {
  public Deluser() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    this.setTitle("刪除用戶");
    btncle.setBounds(new Rectangle(176, 57, 71, 33));
    btncle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btncle.setText("取消");
    btncle.addActionListener(new Deluser_btncle_actionAdapter(this));
    jPanel1.setBorder(BorderFactory.createEtchedBorder());
    jPanel1.setBounds(new Rectangle(32, 32, 290, 177));
    jPanel1.setLayout(null);
    jPanel2.setBorder(BorderFactory.createEtchedBorder());
    jPanel2.setBounds(new Rectangle(1, 37, 288, 39));
    jPanel2.setLayout(null);
    jPanel3.setBorder(BorderFactory.createEtchedBorder());
    jPanel3.setBounds(new Rectangle(0, 75, 290, 101));
    jPanel3.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    jLabel1.setText("刪除用戶");
    jLabel1.setBounds(new Rectangle(100, 11, 91, 20));
    btndel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btndel.addActionListener(new Deluser_btndel_actionAdapter(this));
    cmbuser.addPropertyChangeListener(new Deluser_cmbuser_propertyChangeAdapter(this));
    this.getContentPane().add(jPanel1);
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setText("該用戶是:");
    lblname.setBounds(new Rectangle(22, 20, 84, 23));
    cmbuser.setBounds(new Rectangle(82, 7, 125, 24));
    lblpvi.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblpvi.setBounds(new Rectangle(132, 19, 94, 20));
    jPanel1.add(jPanel2);
    jPanel2.add(cmbuser);
    jPanel1.add(jPanel3);
    jPanel3.add(lblname);
    jPanel3.add(lblpvi);
    jPanel3.add(btncle);
    jPanel3.add(btndel);
    jPanel1.add(jLabel1);
    this.setModal(true);
    btndel.setBounds(new Rectangle(37, 57, 71, 33));
    btndel.setText("刪除");
    sel();//調用該方法將用戶名添加到下拉筐中
  }

  JButton btndel = new JButton();
  JButton btncle = new JButton();
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  JLabel lblname = new JLabel();
  JComboBox cmbuser = new JComboBox();
  JLabel lblpvi = new JLabel();
  JLabel jLabel1 = new JLabel();

  public void sel(){//從數據庫中讀取非管理員的用戶添加到下拉筐中
    String sql="select * from usertitle where purview=2 or purview=1";
    Link lk = new Link();
    lk.connection();
    ResultSet rs=lk.Select(sql);
    try {
      if (rs.next()) {
do{
  cmbuser.addItem(rs.getString(1));
}while(rs.next());
      }else{
        JOptionPane.showMessageDialog(null,"數據庫中沒有非管理員用戶");
      }
    }
    catch (SQLException ex) {
    }


    lk.close();
  }
  public void btndel_actionPerformed(ActionEvent e) {//刪除用戶
    if (JOptionPane.showConfirmDialog(null, "確認刪除?", "確認",
                                      JOptionPane.YES_NO_OPTION) == 0) {
      String sql = "delete from usertitle where username='" +
          cmbuser.getSelectedItem().toString() + "'";
      Link lk = new Link();
      lk.connection();
      int it = lk.Update(sql);
      if (it > 0) {
        JOptionPane.showMessageDialog(null, "刪除成功");
      }
      lk.close();
      sel();
    }
    else{
      return;
    }
  }

  public void cmbuser_propertyChange(PropertyChangeEvent evt) {
JOptionPane.showMessageDialog(null,"彈"+evt.toString());
  }

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

class Deluser_cmbuser_propertyChangeAdapter
    implements PropertyChangeListener {
  private Deluser adaptee;
  Deluser_cmbuser_propertyChangeAdapter(Deluser adaptee) {
    this.adaptee = adaptee;
  }

  public void propertyChange(PropertyChangeEvent evt) {
    adaptee.cmbuser_propertyChange(evt);
  }
}

class Deluser_btncle_actionAdapter
    implements ActionListener {
  private Deluser adaptee;
  Deluser_btncle_actionAdapter(Deluser adaptee) {
    this.adaptee = adaptee;
  }

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

class Deluser_btndel_actionAdapter
    implements ActionListener {
  private Deluser adaptee;
  Deluser_btndel_actionAdapter(Deluser adaptee) {
    this.adaptee = adaptee;
  }

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