deleteuser.java

这是一个用java语言开发的运动员成绩统计系统

package com.userManager;
import com.DBManager.MyDB;
import com.MainFrame;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.Box;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;

/**
 * @author  Laiger
 */
public class DeleteUser extends JFrame implements ActionListener {
	
	JPanel p=new JPanel();
	JLabel userID=new JLabel("帐号");
	JLabel password=new JLabel("密码");
	JTextField t_userID=new JTextField(10);
	JPasswordField t_pass=new JPasswordField(10);
	JButton confirm=new JButton("确定");
	JButton cancel=new JButton("取消");
	Box base;
	Box box1;
	Box box2;

	private MyDB db=new MyDB();
	
	private MainFrame m;
	public DeleteUser(MainFrame m){
		super("Delete User ");
		this.m=m;
		this.setBounds(300,300,250,200);
		this.setVisible(true);
		 this.setResizable(false);
		t_pass.setEchoChar('*');
		confirm.addActionListener(this);
		cancel.addActionListener(this);
		box1=Box.createVerticalBox();
		box2=Box.createVerticalBox();
		base=Box.createHorizontalBox();
		box1.add(userID);
		box1.add(Box.createVerticalStrut(5));
		box1.add(password);
		box1.add(Box.createVerticalStrut(50));
		box1.add(confirm);
		box2.add(t_userID);
		box2.add(t_pass);
		box2.add(Box.createVerticalStrut(45));
		box2.add(cancel);
		base.add(box1);
		base.add(Box.createHorizontalStrut(20));
		base.add(box2);
		p.add(base);
		add(p);
		
		this.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				dispose();
			}
		});
		
	}
	public void actionPerformed(ActionEvent e) {
		if(e.getSource()==confirm)
		{
		  if(t_userID.getText().trim().equals(""))
		  {
		   JOptionPane.showMessageDialog(this, "帐号不可为空！");
		   return;
		  }
		  if(t_pass.getPassword().toString().trim().equals(""))
		  {
			  JOptionPane.showMessageDialog(this, "密码不可为空！");
			   return;
		  }
		  String strSQL;
		  String s=new String(t_pass.getPassword());
		    s.trim();
		  strSQL="select * from User where userID='"+t_userID.getText().trim()+"' and Password='"+s+"'";
		  boolean isExit=false;
		  
		 db.connectDB();
		  if(db.rowCount(strSQL)<1){
			  JOptionPane.showMessageDialog(this, "用户名不存在或者密码不正确");
		  }
		  else
		  {
			strSQL="delete from User where userID='"+t_userID.getText().trim()+"'and Password='"+s+"'";
			if(db.executeUpdate(strSQL))
			{
				JOptionPane.showMessageDialog(this, "删除成功！");
				db.close();
				this.dispose();
			}
			else {
				JOptionPane.showMessageDialog(this, "删除失败，请重新操作！");
			}
		  }
		  
		}
		else if(e.getSource()==cancel)
		{
			m.setVisible(true);m.setVisible(true);
		  this.dispose();
		  
		}
		
	}
	
	
	

}