booklist.java

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

import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class BookList extends Frame implements ActionListener
{ 
	Label message,title;
	Button 打印,退出;
	ScrollPane scrollpane;
	Panel p1,p2,p3;
	Pe panel[];
	Connection con;
    Statement sql;
    ResultSet rs;
	boolean b;
	long count=0;
	BookList()	
    {
		super("书籍信息列表窗口");
		setBounds(5,30,780,550);
		title=new Label(" 标识             书名           出版社           作者         出版社地址       出版日期       价格            是否借出");
		title.setBackground(Color.orange);
		message=new Label("                     ");
		打印=new Button("打印");
		退出=new Button("退出");
		打印.addActionListener(this);
	    退出.addActionListener(this);
		打印.setEnabled(false);
		scrollpane=new ScrollPane(ScrollPane.SCROLLBARS_AS_NEEDED);
		p1=new Panel();
		p2=new Panel();
		p2.setLayout(new GridLayout(1001,1));
	    p2.add(title);
		panel=new Pe[1001];
		for(int i=1;i<1000;i++)
		{
			panel[i]=new Pe();
		}
		p3=new Panel();
	    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("没有找到数据表！");
		}
		
		panel[1].text[1].setText("");
		int i=0;
		try
		{
			count=0;
			rs=sql.executeQuery("SELECT *FROM 书籍信息表 ORDER BY 书名");
			while(rs.next())
			{
				count++;
			}
			rs=sql.executeQuery("SELECT * FROM 书籍信息表 ORDER BY 书名");			
			while(rs.next()&&i<=count)
			{
				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("");
				打印.setEnabled(false);
			}
			else
			{
				scrollpane.add(p2);
				add(scrollpane,"Center");
				打印.setEnabled(true);
				validate();
			}
		}
		catch(SQLException e3){}
	    addWindowListener(new WindowAdapter(){public void windowClosing(WindowEvent e)
		    {
			  setVisible(false);
			  dispose();
		}});
	}
	public void actionPerformed(ActionEvent e)
	{
		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();
		}
	}
}