borrowlist.java

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

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class BorrowList extends Frame implements ActionListener
{ 
	Label l1,message,title;
	TextField t1;
	Button 确定,打印,退出;
	ScrollPane scrollpane;
	Panel p1,p2,p3;
	Pe2 panel[];
	Connection con;
    Statement sql;
    ResultSet rs;
	String s1,s2,s3,s4,s5,s6,s7;
	BorrowList()	
    {
		super("借阅者借书(未还)信息查询窗口");
		setBounds(5,30,780,550);
		title=new Label("   读者编号             读者姓名             书籍标识               书籍名称          出借日期               备注 ");
		title.setBackground(Color.orange);
		l1=new Label("输入读者的编号：");
		message=new Label("                           ");
		t1=new TextField(20);
		确定=new Button("确定");
		打印=new Button("打印");
		退出=new Button("退出");
		确定.addActionListener(this);
		打印.addActionListener(this);
	    退出.addActionListener(this);
		打印.setEnabled(false);
		scrollpane=new ScrollPane(ScrollPane.SCROLLBARS_AS_NEEDED);
		p1=new Panel();
		p2=new Panel();
		p2.setLayout(new GridLayout(101,1));
	    p2.add(title);
		panel=new Pe2[1000];
		for(int i=1;i<1000;i++)
		{
			panel[i]=new Pe2();
		}
		p3=new Panel();
		p1.add(l1);p1.add(t1);p1.add(确定);p1.add(message);
		p3.add(打印);p3.add(退出);
		scrollpane.add(p2);
		add(p1,"North");
		add(p3,"South");
		setVisible(true);
		validate();
		try
	    {
	        Class.forName("com.ms.jdbc.odbc.JdbcOdbcDriver");
	    }
        catch(ClassNotFoundException e1)
	    {
	        message.setText("无法建立数据源！");
	    }
        try
		{
			con=DriverManager.getConnection("jdbc:odbc:book","","");
			sql=con.createStatement();
		}
		catch(SQLException e2)
		{
			message.setText("没有找到数据表！");
		}
	    addWindowListener(new WindowAdapter(){public void windowClosing(WindowEvent e)
		    {
			  setVisible(false);
			  dispose();
		}});
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==确定)
		{
			panel[1].text[1].setText("");
			int i=0;
			String reader_num=t1.getText().trim();
			reader_num="'"+reader_num+"'";
			try
			{
				rs=sql.executeQuery("SELECT * FROM 读者信息表 WHERE 读者编号="+reader_num);
				while(rs.next()&&i<1000)
				{
				
					s1=rs.getString(1);
	                s2=rs.getString(2);
		            s3=rs.getString(3);
	                s4=rs.getString(4);
					s5=rs.getString(5);
					s6=rs.getString(6);
					s7=rs.getString(7);
					if((s6.trim().equals(""))&&(!(s5.trim().equals(""))))
					{	
    					i++;
	    				panel[i].text[1].setText(s1);
		    			panel[i].text[2].setText(s2);
			    		panel[i].text[3].setText(s3);
				    	panel[i].text[4].setText(s4);
				    	panel[i].text[5].setText(s5);
			    		panel[i].text[6].setText(s6);
				    	p2.add(panel[i]);
					}
					
				}
				if((panel[1].text[1].getText().trim()).length()==0)
				{
					Color c1=message.getBackground();
					message.setBackground(Color.red);
					message.setText("该读者没有借书或读者编号有误！");
					try
					{
						Thread.sleep(5000);
					}
					catch(InterruptedException ee){}
					message.setBackground(c1);
					message.setText("");
					t1.setText("");
					打印.setEnabled(false);
				}
				else
				{
					scrollpane.add(p2);
					add(scrollpane,"Center");
					打印.setEnabled(true);
					validate();
				}
			}
			catch(SQLException e3){}			
		}
		if(e.getSource()==打印)
		{
			PrintJob p=null;
			Graphics g=null;
        	title.setBackground(Color.white);
			p=getToolkit().getPrintJob(this,"ok",null);
			g=p.getGraphics();
			p2.printAll(g);
			g.dispose();
			p.end();
    		title.setBackground(Color.orange);
		}
		if(e.getSource()==退出)
		{
			try
			{
				con.close();
			}catch(SQLException e4){}
			setVisible(false);
			dispose();
		}
	}
}