bookreturn.java

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

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

public class BookReturn extends JFrame implements ActionListener
{
	public BookReturn()
	{
		setTitle("书籍还入");
		setSize(200,200);
		gl=new GridLayout(4,2,20,20);
		gl2=new GridLayout(1,3,20,20);
		JPanel panel=new JPanel();
		JPanel panel2=new JPanel();
		panel.setLayout(gl);
		panel2.setLayout(gl2);
		namelbl=new JLabel("读者ID");
		nametex=new JTextField("");
		booknamelbl=new JLabel("书ID");
		booknametex=new JTextField("");
		datelbl=new JLabel("归还日期");
		datetex=new JTextField("");
		detaillbl=new JLabel("备注");
		detailtex=new JTextField("");
		cleanbtn=new JButton("清除");
		editbtn=new JButton("确定");
		cancelbtn=new JButton("退出");
		panel.add(namelbl);
		panel.add(nametex);
		panel.add(booknamelbl);
		panel.add(booknametex);
		panel.add(datelbl);
		panel.add(datetex);
		panel.add(detaillbl);
		panel.add(detailtex);
		panel2.add(cleanbtn);
		panel2.add(editbtn);
		panel2.add(cancelbtn);
		cleanbtn.addActionListener(this);
		editbtn.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==editbtn)
		{	
			String nameid=new String(nametex.getText()).trim();
			if(nameid.equals(""))
			{
			JOptionPane.showMessageDialog(null,"读者ID不能为空!");
			return;
			}
		String  bookid=new String(booknametex.getText()).trim();
		if(bookid.equals(""))
		{
			JOptionPane.showMessageDialog(null,"书本ID不能为空!");
			return;
		}
		String date=new String(datetex.getText()).trim();
		
		if(date.equals(""))
		{
			JOptionPane.showMessageDialog(null,"归还时间不能为空");
			return;
		}
		String detail=new String(detailtex.getText()).trim();
			if(detail.equals(""))
			{
			detail=" ";
			}
		String strsql;
		strsql=("update 书籍借阅表 set 归还时间='"+date+"',状态='"+detail+"' where 读者ID='"+nameid+"' and 书本ID="+bookid);
		System.out.println(strsql);
		boolean success=db.executeSql(strsql);
	if(!success)
		{
			JOptionPane.showMessageDialog(null,"归还不成功，请重试");
		}
	else
	{
			JOptionPane.showMessageDialog(null,"归还成功");
			this.dispose();
		}
				
		}
	if(source==cancelbtn)
		{
			
			this.dispose();
			return;
		}
		if(source==cleanbtn)
		{
			nametex.setText("");
			booknametex.setText("");
			detailtex.setText("");
			datetex.setText("");
			return;
		}
	}
	private JLabel namelbl;
	private JLabel booknamelbl;
	private JLabel datelbl;
	private JLabel detaillbl;
	private JTextField nametex;
	private JTextField booknametex;
	private JTextField datetex;
	private JTextField detailtex;
	private JButton cleanbtn;
	private JButton editbtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private GridLayout gl2;
	private DBManager db=new DBManager();
	private ResultSet rs;
}