paixu.java

图书浏览软件

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


public class paixu 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);
	DataBaseLink dbl;
	showtable tab;
	
	public paixu(showtable table)
	{
		setTitle("图书排序");
		JPanel pane = new JPanel();
		setContentPane(pane);
		pane.setLayout(null);
		setSize(200,200);
		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]);
	    	
	    	
	    	button[i] = new JButton("排序");
	    	button[i].setBounds(110,29+i*40,60,22);
	    	button[i].setFont(newfont1);
	    	pane.add(button[i]);
	    } 
	    
	    buttonAction(); 
	    DataBaseLinkinit();	
	    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.alltushu(tab);
			}});
			
		button[1].addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				dbl.alltushubyauthor(tab);
			}});
			
		button[2].addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e)
			{
				dbl.alltushubyclass(tab);
			}});
	}
}