csdel.java

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

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

public class csDel extends JFrame implements ActionListener
{
	public csDel()
	{
		setTitle("删除惩罚信息");
		setSize(200,200);
		gl=new GridLayout(3,2,20,20);
		gl2=new GridLayout(1,3,20,20);
		JPanel panel=new JPanel();
		JPanel panel2=new JPanel();
		panel.setLayout(gl);
		panel2.setLayout(gl2);
		id=new JLabel("惩罚ID");
	 	readerid=new JLabel("读者ID");
        idtex=new JTextField("");
 		readertex=new JTextField("");;
 		surebtn=new JButton("删除");
		cleanbtn=new JButton("清空");
		cancelbtn=new JButton("退出");
		panel.add(id);
		panel.add(idtex);
		panel.add(readerid);
		panel.add(readertex);
		panel2.add(cleanbtn);
		panel2.add(surebtn);
		panel2.add(cancelbtn);
		cleanbtn.addActionListener(this);
		surebtn.addActionListener(this);
		cancelbtn.addActionListener(this);		
		getContentPane().add(panel,BorderLayout.CENTER);
		getContentPane().add(panel2,BorderLayout.SOUTH);
	}
	public void actionPerformed(ActionEvent e)
	{
		Object source=e.getSource();
		if(source==surebtn)
		{	
			String id=new String(idtex.getText()).trim();
			if(id.equals(""))
			{
			JOptionPane.showMessageDialog(null,"惩罚ID不能为空!");
			return;
			}
			String reader=new String(readertex.getText()).trim();
			if(reader.equals(""))
			{
			JOptionPane.showMessageDialog(null,"读者ID不能为空!");
			return;
			}
		int confirm=JOptionPane.showConfirmDialog(null,"是否删除?","删除确认",JOptionPane.YES_NO_OPTION);
		if(confirm==JOptionPane.YES_OPTION)
		{
			String strsql;
			strsql=("delete from 惩罚表 where 惩罚ID='"+id+"' and 读者ID='"+reader+"'");
			System.out.println(strsql);
			boolean success=db.executeSql(strsql);
			if(!success)
			{
				JOptionPane.showMessageDialog(null,"修改不成功，请重试");
			}
			else
			{
				JOptionPane.showMessageDialog(null,"修改成功");
				this.dispose();
			}
				
		}
		else
		{
			this.dispose();
			return;
		}
	}
	if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
	if(source==cleanbtn)
		{
			idtex.setText("");
			readertex.setText("");
			return;
		}
	}
	private JLabel id;
	private JLabel readerid;
	private JTextField idtex;
	private JTextField readertex;
	private JButton surebtn;
	private JButton cleanbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private GridLayout gl2;
	private DBManager db=new DBManager();
	private ResultSet rs;
}