del_reader.java

简易图书管理样板 其他功能仿照即可 小弟能力有限

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
class del_reader extends JFrame implements ActionListener
{
	JLabel _ID;
	JTextField ID;
	JButton del_true;
	JButton del_false;
	Connection con1;
	Statement sql;
	ResultSet rs;
	del_reader()
	{
		super("删除读者");
		Toolkit tool=getToolkit();
		Dimension dim=tool.getScreenSize();
		setBounds(dim.width/2-125,dim.height/2-50,250,100);
		//setSize(250,100);
		//setBounds(540,300,250,100);
		setResizable(false);
		setVisible(true);
		FlowLayout con=new FlowLayout();
		setLayout(con);
		_ID=new JLabel("读者编号：");
		ID=new JTextField(10);
		del_true=new JButton("删除");
		del_true.addActionListener(this);
		del_false=new JButton("取消");
		del_false.addActionListener(this);
		add(_ID);
		add(ID);
		add(del_true);
		add(del_false);
		validate();
		
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==del_true)
		{
		try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}
		catch(ClassNotFoundException e1)
		{
			System.out.println(""+e1);
		}
		
		try{ con1=DriverManager.getConnection("jdbc:odbc:book","admin","111111");
			sql=con1.createStatement();
			rs=sql.executeQuery("delete *from reader where number='"+ID.getText()+"'");
			while(rs.next())
			{
				String number=rs.getString(1);
				String name=rs.getString(2);
				String date=rs.getString(3);
				String type=rs.getString(4);
				System.out.print(" "+number+" "+name+" "+date+" "+type);
				System.out.println();
				//msg.setText(number+"  "+name+"  "+date+"  "+type+"\n");
			}
			con1.close();
			}
			catch(SQLException e2)
			{
				System.out.println(e2);
			}
			JOptionPane.showMessageDialog(null,"删除成功!");
			this.dispose();
	
	     }
	     if(e.getSource()==del_false)this.dispose();
	}
}