borrow.java

用JAVA做的图书借阅信息系统

import java.util.Date;
import java.text.SimpleDateFormat;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class Borrow extends FrameClass implements ActionListener
{ 
	Label l1,l2,l3,l4,l5;
	TextField t1,t2,t3,t4,t5;
	Button 清空,确定,退出;
	Panel p1,p2,p3;
	Connection con;
    Statement sql1,sql2;
    ResultSet rs1,rs2,rs3;
	Date date=new Date();
	SimpleDateFormat date_format=new SimpleDateFormat("yyyy年MM月dd日");
	String sdate=date_format.format(date);
	boolean b,flag1,flag2,found;
	String reader_name,reader_num,book_num,book_name,borrow_date,return_date,notice;
	String s1,s2,s3,s4,s5,s6,s7,book_name1,reader_num1;
	Borrow()	
    {
		super("图书借阅窗口");
		setBounds(150,130,500,300);
		l1=new Label("借阅者编号：");
		l2=new Label("借阅者姓名：");
		l3=new Label("要借阅书名：");
		l4=new Label("  借阅日期：");
		l5=new Label("      备注：");
		t1=new TextField(" ",20);
		t2=new TextField(" ",20);
		t3=new TextField(" ",20);
		t4=new TextField(" ",20);
		t5=new TextField(" ",20);
		清空=new Button("清空");
		确定=new Button("确定");
		退出=new Button("退出");
		l2.setVisible(false);
		t2.setVisible(false);
		t4.setText(sdate);
		清空.addActionListener(this);
		确定.addActionListener(this);
	    退出.addActionListener(this);
	    add(l1);add(l2);add(l3);add(l4);add(l5);
		add(t1);add(t2);add(t3);add(t4);add(t5);
		add(清空);add(确定);add(退出);
		message.setBounds(160,40,230,25);
		l1.setBounds(90,80,80,25);t1.setBounds(180,80,200,25);
		l2.setBounds(90,110,80,25);t2.setBounds(180,110,200,25);
		l3.setBounds(90,140,80,25);t3.setBounds(180,140,200,25);
		l4.setBounds(90,170,80,25);t4.setBounds(180,170,200,25);
		l5.setBounds(90,200,80,25);t5.setBounds(180,200,200,25);	
		清空.setBounds(170,230,50,25);确定.setBounds(220,230,50,25);退出.setBounds(270,230,50,25);
		setVisible(true);
		validate();
		try
	    {
	        Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
	    }
        catch(ClassNotFoundException e1)
	    {
			setMessage("无法连接到数据库！",5000);
			this.dispose();
	    }
        try
		{
			con=DriverManager.getConnection("jdbc:odbc:book","","");
			sql1=con.createStatement();
			sql2=con.createStatement();
		}
		catch(SQLException e2)
		{
			setMessage("没有找到数据库！",3000);
			this.dispose();
		}
	    addWindowListener(new WindowAdapter(){public void windowClosing(WindowEvent e)
		    {
			  setVisible(false);
			  dispose();
		}});
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==确定)
		{
			reader_num=t1.getText().trim();
			book_name=t3.getText().trim();
			borrow_date=t4.getText().trim();
			return_date=" ";
			notice=t5.getText();
			if(notice.trim().equals(""))
			{
				notice=" ";
			}
			reader_num1="'"+reader_num+"'";
			book_name1="'"+book_name+"'";
			//按书名在书库中查找
			try
			{
				flag1=false;
				flag2=false;
				rs1=sql1.executeQuery("SELECT *FROM 书籍信息表 WHERE 书名="+book_name1);
				while(rs1.next())
     			{//找到了
	    			flag1=true;
		    		b=rs1.getBoolean("借出");
					book_num=rs1.getString("标识");
			    	if(b==false)
				    {
			     		flag2=true;
				    	break;
     				}
	    		}
			}
			catch(SQLException e3){}
			//没有找到
	    	if(flag1==false)
		    {
				setMessage("没有你要借的书！",3000);
	    	}
			//找到但已被借出
    		if(flag2==false)
	    	{
				setMessage("你要借的书都已被借出！",3000);
    		}
	    	if((flag1==true)&&(flag2==true))
    		{	
				try
				{
					found=false;
					rs2=sql2.executeQuery("SELECT *FROM 读者信息表 WHERE 读者编号="+reader_num1);
					while(rs2.next())
					{//找到了,不是新读者，办理借阅手续
						l2.setVisible(true);
				        t2.setVisible(true);
						found=true;
						reader_num=rs2.getString("读者编号");
						reader_name=rs2.getString("读者姓名");
						t2.setText(reader_name);
						t2.setEditable(false);
						validate();
						s1="'"+reader_num+"'";
						s2="'"+reader_name+"'";
						s3="'"+book_num+"'";
						s4="'"+book_name+"'";
						s5="'"+borrow_date+"'";
						s6="'"+return_date+"'";
						s7="'"+notice+"'";
						sql2.executeUpdate("INSERT INTO 读者信息表 VALUES("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+","+s7+")");
						setMessage("借阅手续办理完毕！",3000);
		            	t1.setText(" ");
			            t2.setText(" ");
			            l2.setVisible(false);
			            t2.setVisible(false);
			            t3.setText(" ");
			            t4.setText(sdate);
	            		t5.setText(" ");
						mark();
						break;
	    			}
					if(found==false)
					{
						setMessage("这是一个新读者，请先进行‘读者登记’！",5000);
					}
				}
				catch(SQLException e4){}
		    }
		}
		if(e.getSource()==清空)
		{
			t1.setText(" ");
			t2.setText(" ");
			l2.setVisible(false);
			t2.setVisible(false);
			t3.setText(" ");
			t4.setText(sdate);
			t5.setText(" ");
		}
		if(e.getSource()==退出)
		{
			try
			{
				con.close();
			}
			catch(SQLException e4){}
			setVisible(false);
			dispose();
		}
	}
	public void mark()
	{
		try
		{
			book_num="'"+book_num+"'";
			rs1=sql1.executeQuery("SELECT *FROM 书籍信息表 WHERE 标识="+book_num);
			while(rs1.next())
			{
				sql1.executeUpdate("UPDATE 书籍信息表 SET 借出=true WHERE 标识="+book_num);
			}
		}
		catch(SQLException e6){	}
	}
}