bookborrow.java

实现图书借阅管理,运用access数据库

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

public class BookBorrow extends JFrame implements ActionListener
{
	public BookBorrow()
	{
		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();
			Long intbookid=new Long(bookid);
			String userid=nametex.getText().trim();
			Long intuserid=new Long(userid);
			String borrowdate=datetex.getText().trim();
			String detail=detailtex.getText().trim();
			if((bookid.equals(""))||(userid.equals(""))||(borrowdate.equals("")))
			{
				JOptionPane.showMessageDialog(null,"前三项不能为空");
				return;
			}
			String sql=("select * from user where id="+intuserid);
			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("");
				return;
			}
			try
			{
				userid=rs.getString(2);
			}
			catch(SQLException e2)
			{
				System.out.println(e2);
			}
			sql=("select * from book where id="+intbookid);
			rs=db.getResult(sql);
		 	isexist=false;
			try
			{
			//把游标指向结果集的第一行，如果没有数据则返回false
			isexist=rs.first();		
			}
			catch(SQLException w2)
			{
			System.out.println(w2);
			}
			//判断结果是否正确
			if(!isexist)
			{
				JOptionPane.showMessageDialog(null,"书不存在");
				booknametex.setText("");
				return;
			}
			try
			{
				bookid=rs.getString(2);
			}
			catch(SQLException e3)
			{
				System.out.println(e);
			}
			namelbl.setText("用户名");
			booknamelbl.setText("书名");
			nametex.setText(userid);
			booknametex.setText(bookid);
			int confirm=JOptionPane.showConfirmDialog(null,"确认信息?","出借确认",JOptionPane.YES_NO_OPTION);
			if(confirm==JOptionPane.YES_OPTION)
			{
				sql=("insert into borrow (studentname,bookname,borrowdate,returndate,comment,bookid,userid) values('"+userid+"','"+bookid+"','"+borrowdate+"',' ','"+detail+" "+"',"+intbookid+","+intuserid+")");
				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;
}