bookreturn.java

java 开发的图书管理系统~~~。可以实现很多功能

package bookmanager;
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("还书人编号");
		nametex=new JTextField("");
		booknamelbl=new JLabel("书编号");
		booknametex=new JTextField("");
		datelbl=new JLabel("日期");
		datetex=new JTextField("");
		detaillbl=new JLabel("备注");
		detailtex=new JTextField("");
		cleanbtn=new JButton("清除");
		surebtn=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(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==cleanbtn)
		{
			nametex.setText("");
			booknametex.setText("");
			detailtex.setText("");
			datetex.setText("");
		}
		if(source==cancelbtn)
		{
			this.dispose();
		}
		if(source==surebtn)
		{
			String bookid=booknametex.getText().trim();
			
			String userid=nametex.getText().trim();
			
			String returndate=datetex.getText().trim();
			String detail=detailtex.getText().trim();
			//判断条件是否齐全
			if((bookid.equals(""))||(userid.equals(""))||(returndate.equals("")))
			{
				JOptionPane.showMessageDialog(null,"前三项不能为空");
				return;
			}
			Long intbookid=new Long(bookid);
			Long intuserid=new Long(userid);
			//判断输入信息是否有效
			String sql;
			sql=("select * from borrow where userid="+intuserid+" and bookid="+intbookid );
			rs=db.getResult(sql);
			boolean isexist=false;
			try
			{
			//把游标指向结果集的第一行，如果没有数据则返回false
			isexist=rs.first();		
			}
			catch(SQLException w)
			{
				System.out.println(w);
			}
				//判断结果是否正确
				if(!isexist)
				{
					JOptionPane.showMessageDialog(null,"没有相关资料");
					nametex.setText("");
					booknametex.setText("");
					return;
				}
				try
				{
					namelbl.setText("用户名");
					booknamelbl.setText("书名");
					borrowid=Long.valueOf(rs.getString(1));
					booknametex.setText(rs.getString(3));
					nametex.setText(rs.getString(2));
					detailtex.setText(rs.getString(6));
				}
				catch(SQLException e2)
				{
					System.out.println(e2);
				}		
			int confirm=JOptionPane.showConfirmDialog(null,"确认信息,如果备注有信息请处理好相干工作","还书确认",JOptionPane.YES_NO_OPTION);
			if(confirm==JOptionPane.YES_OPTION)
			{
				sql=("update borrow set returndate='"+returndate+ "',comment='"+detail+" 'where id="+borrowid);
				System.out.println(sql);
				boolean success=db.executeSql(sql);
				if(!success)
				{
					JOptionPane.showMessageDialog(null,"不成功，请重试");
				}
				else
				{
					JOptionPane.showMessageDialog(null,"成功");
					this.dispose();
				}
				
			}
			else
			{
				this.dispose();
				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 surebtn;
	private JButton cancelbtn;
	private GridLayout gl;
	private GridLayout gl2;
	private DBManager db=new DBManager();
	private ResultSet rs;
	//借阅表的ID
	private Long borrowid=new Long(0);
}