package testsystem;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class DelFrom extends JFrame {
    public DelFrom() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jButton1.setBounds(new Rectangle(142, 199, 97, 36));
        jButton1.setText("刪除");
        jButton1.addActionListener(new DelFrom_jButton1_actionAdapter(this));
        this.getContentPane().add(jButton1);
        jLabel2.setForeground(Color.red);
        jLabel2.setText("刪除用戶后如想恢復請在“添加用戶”里添加！");
        jLabel2.setBounds(new Rectangle(65, 133, 252, 37));
        jLabel1.setText("請輸入要刪除的用戶名：");
        jLabel1.setBounds(new Rectangle(125, 33, 132, 35));
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jt1);
        this.getContentPane().add(jLabel2);
        jt1.setBounds(new Rectangle(97, 81, 192, 34));
    }

    public static void main(String[] args) {
        DelFrom delfrom = new DelFrom();
    }

    JButton jButton1 = new JButton();
    JTextField jt1 = new JTextField();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    public void jButton1_actionPerformed(ActionEvent e) {
          String Name=jt1.getText().trim();
          Connection con=null;
          Statement s1=null;
          ResultSet rs=null;
          try
          {
              con=DBcon.link();
              s1=con.createStatement();
              rs=s1.executeQuery("select * from Login where Name='"+Name+"'");
              if(rs.next())
              {
                  JOptionPane.showMessageDialog(null,"用戶存在可以刪除！");
                  s1.executeUpdate("delete from Login where Name='"+Name+"'");
                  JOptionPane.showMessageDialog(null,"刪除成功！");
              }
              else
              {
                  JOptionPane.showMessageDialog(null,"沒有這個用戶，請重新輸入！","提示",JOptionPane.ERROR_MESSAGE);
                  jt1.setText("");
                  jt1.requestFocus();
              }
          }
          catch(SQLException ce)
          {
              ce.getMessage();
          }
    }
}


class DelFrom_jButton1_actionAdapter implements ActionListener {
    private DelFrom adaptee;
    DelFrom_jButton1_actionAdapter(DelFrom adaptee) {
        this.adaptee = adaptee;
    }

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