delreaderfrm.java

这个学期完成的图书管理系统

import java.util.*;
import java.awt.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
class  Delreaderfrm extends JFrame implements ActionListener
{
	JLabel l_studentnumber;
	JTextField t_studentnumber;
	JButton b_delreader,b_back;
	JPanel pan1,pan2,pan3;
	
	NetConn sql;
	Statement sqll;
	
	Delreaderfrm()
	{
		
		l_studentnumber=new JLabel("输入你要删除的读者的学号：");
		t_studentnumber=new JTextField("",20);
		b_delreader=new JButton("删除");
		b_back=new JButton("返回");
		b_delreader.addActionListener(this);
		b_back.addActionListener(this);
		pan1=new JPanel();pan2=new JPanel();pan3=new JPanel();
	    pan1.add(l_studentnumber);pan2.add(t_studentnumber);pan3.add(b_delreader);pan3.add(b_back);
	    setLayout(new GridLayout(3,1));
	    add(pan1);add(pan2);add(pan3);
		setBounds(400,300,300,350);
		
		sql=new NetConn();
		
		
	}
	public void actionPerformed(ActionEvent ed)
	{
		if(ed.getSource()==b_delreader)
		{
			try
			{
			sqll=sql.connect();
			sqll.executeUpdate("delete from reader where studentnumber="+"'"+t_studentnumber.getText()+"'");
			l_studentnumber.setText("读者删除成功");
			}
			catch(SQLException e6)
			{}
		}
		else if(ed.getSource()==b_back)
		{
			dispose();
		}
	}
}