userdel.java

图书馆管理系统：该系统的开发主要包括用户登陆

import javax.swing.*;
import java.awt.event.*;
import java.awt.GridLayout;
import java.sql.*;

public class userDel extends JFrame implements ActionListener
{
	public userDel()
	{
		setTitle("删除用户");
		setSize(200,200);
		gl=new GridLayout(3,2,20,20);
		JPanel panel=new JPanel();
		panel.setLayout(gl);
		userid=new JLabel("用户ID");
		useridtex=new JTextField("");
		userlbl=new JLabel("用户名");
		usertex=new JTextField("");
		addbtn=new JButton("确认");
		cancelbtn=new JButton("取消");
		panel.add(userid);
		panel.add(useridtex);
		panel.add(userlbl);
		panel.add(usertex);
		panel.add(addbtn);
		panel.add(cancelbtn);
		getContentPane().add(panel);
		addbtn.addActionListener(this);
		cancelbtn.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==addbtn)
		{
			String userid=new String(useridtex.getText()).trim();
			if(userid.equals(""))
			{
			JOptionPane.showMessageDialog(null,"读者ID不能为空!");
			return;
			}
			String user=new String(usertex.getText()).trim();
			if(userid.equals(""))
			{
			JOptionPane.showMessageDialog(null,"用户名不能为空!");
			return;
			}
    	int confirm=JOptionPane.showConfirmDialog(null,"是否删除?","删除确认",JOptionPane.YES_NO_OPTION);
		if(confirm==JOptionPane.YES_OPTION)
		{
			String strsql,sql;
			strsql=("delete from 读者权限表 where 用户名='"+user+"' ");
			sql=("delete from 借阅证表 where 读者ID='"+userid+"' ");
			System.out.println(strsql);
			boolean success=db.executeSql(strsql)&db.executeSql(sql);
			if(!success)
			{
				JOptionPane.showMessageDialog(null,"修改不成功，请重试");
			}
			else
			{
				JOptionPane.showMessageDialog(null,"修改成功");
				this.dispose();
			}
				
		}
		else
		{
			this.dispose();
			return;
		}
	}
		if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
	
	}
	private JLabel userlbl;
	private JTextField usertex;
	private JLabel userid;
	private JTextField useridtex;
	private JButton addbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private DBManager db=new DBManager();
	private ResultSet rs;
}