Flow/DeleteAcc.java at master · 14jqhuang/Flow · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
package login;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

public class DeleteAcc extends JPanel implements ActionListener
{
	JPanel panel1,panel2,panel3;
	JLabel deAcc,label;
	JTextField deText;
	JButton deBu,debuall;
	DataBaseconnection dbc=new DataBaseconnection();
	ResultSet res;
	public DeleteAcc()
	{
		panel1= new JPanel();
		panel2= new JPanel();
		panel3= new JPanel();
		panel1.setPreferredSize(new Dimension(500,200));
		panel2.setPreferredSize(new Dimension(300,100));
		panel3.setPreferredSize(new Dimension(300,100));

		label=new JLabel(new ImageIcon("E:/images/qq1.gif"));
		deAcc=new JLabel("请输入您要删除的账号名 ：",JLabel.RIGHT);
		deText=new JTextField(10);
		deBu=new JButton("确定");
		debuall=new JButton("删除所有");
		panel1.add(label);
		panel2.add(deAcc);panel2.add(deText);panel2.add(deBu);
		panel3.add(debuall);
		//注册监听器
		deBu.addActionListener(this);
		debuall.addActionListener(this);
		add(panel1,BorderLayout.NORTH);add(panel2,BorderLayout.CENTER);
		add(panel3,BorderLayout.SOUTH);
		setVisible(true);
		setSize(100,100);
	}
	public void actionPerformed(ActionEvent e)
	{
		if (e.getActionCommand()=="确定")
		{
			res=dbc.executeQuery("select * from stuacc where account='"+deText.getText()+"'");
			try
			{
				if (res.next())
				{
					dbc.executeUpdate("delete from stuacc where account='"+deText.getText()+"'");
					JOptionPane.showMessageDialog(null,"删除成功","Successful",JOptionPane.OK_OPTION);
					deText.setText("");
				}

				else
				{
					JOptionPane.showMessageDialog(null,"Sorry!暂无该账号的信息，请确认好后重新输入","Wrong Usernumber",JOptionPane.ERROR_MESSAGE);
				}
				}
			catch (SQLException e1)
			{
				e1.printStackTrace();
			}
		}

		else if (e.getSource()==debuall)
		{
			dbc.executeUpdate("delete from stuacc");
			JOptionPane.showMessageDialog(null, "Deleted All");
		}
	}
}