search.java

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

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class Search extends Frame implements ActionListener
{ 
	Label l1,message,title;
	TextField t1;
	Button 确定,打印,退出;
	ScrollPane scrollpane;
	Panel p1,p2,p3;
	Pe panel[];
	Connection con;
    Statement sql;
    ResultSet rs;
	boolean b;
	Search()	
    {
		super("书籍信息查询窗口");
		setBounds(5,30,780,550);
		title=new Label(" 标识             书名           出版社           作者         出版社地址       出版日期       价格            是否借出");
		title.setBackground(Color.orange);
		l1=new Label("输入要查找的书名：");
		message=new Label("                     ");
		t1=new TextField(30);
		确定=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 Pe[1000];
		for(int i=1;i<1000;i++)
		{
			panel[i]=new Pe();
		}
		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 bookname=t1.getText().trim();
			bookname="'"+bookname+"'";
			try
			{
				rs=sql.executeQuery("SELECT * FROM 书籍信息表 WHERE 书名="+bookname);
				while(rs.next()&&i<1000)
				{
					i++;
					panel[i].text[1].setText(rs.getString(1));
					panel[i].text[2].setText(rs.getString(2));
					panel[i].text[3].setText(rs.getString(3));
					panel[i].text[4].setText(rs.getString(4));
					panel[i].text[5].setText(rs.getString(5));
					panel[i].text[6].setText(rs.getString(6));
					panel[i].text[7].setText(String.valueOf(rs.getFloat(7)));
					b=rs.getBoolean(8);
					if(b==true)
					{
						panel[i].text[8].setText("已经借出");
					}
					else
					{
						panel[i].text[8].setText("没有借出");
					}						
					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(3000);
					}
					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();
		}
	}
}