find.java

图书浏览软件

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;


public class find extends JFrame
{
	JLabel[] lab = new JLabel[3];
	JTextField[] tf = new JTextField[3];
	JButton[] button = new JButton[4];
	Font newfont1 = new Font("newfont",Font.PLAIN,13);
	showtable tab;
	DataBaseLink dbl;
	
	public find(showtable table)
	{
		setTitle("查找图书");
		JPanel pane = new JPanel();
		setContentPane(pane);
		pane.setLayout(null);
		setSize(310,240);
		setResizable(false);
		
		
		String[] s = {"按书名查找","按作者查找","按类别查找"};
	    for(int i = 0;i<3;i++)
	    {
	    	lab[i] = new JLabel(s[i]);
	    	lab[i].setBounds(20,30+i*40,100,20);
	    	lab[i].setFont(newfont1);
	    	pane.add(lab[i]);
	    	
	    	tf[i] = new JTextField();
	    	tf[i].setBounds(100,30+i*40,100,20);
	    	tf[i].setFont(newfont1);
	    	pane.add(tf[i]);
	    	
	    	button[i] = new JButton("查找");
	    	button[i].setBounds(220,29+i*40,60,22);
	    	button[i].setFont(newfont1);
	    	pane.add(button[i]);
	    }
	    
	        button[3] = new JButton("显示所有图书");
	    	button[3].setBounds(90,155,120,22);
	    	button[3].setFont(newfont1);
	    	pane.add(button[3]);
	    	
	   DataBaseLinkinit(); 	
	   buttonAction();	
	   tab = table;
	}
	
	
	public void DataBaseLinkinit()
	{
		dbl = new DataBaseLink("JDBC:ODBC:Driver={MicroSoft Access Driver (*.mdb)};DBQ=../数据信息/数据信息.mdb");
	}
	
	public void buttonAction()
	{
		button[0].addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				dbl.lookupbyshuming(tf[0].getText(),tab);
			}});
			
		button[1].addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				dbl.lookupbyauthor(tf[1].getText(),tab);
			}});
			
		button[2].addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				dbl.lookupbyclass(tf[2].getText(),tab);
			}});
			
		button[3].addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				dbl.alltushu(tab);
			}});
	}
}