customerqueryclick.java

这是我我完成的java的课程设计,是一个宾馆管理系统

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
/************************************************************/
public class CustomerQueryClick extends DBAccess implements ActionListener 
{
	String sql;
	String frameName;
	CustomerQueryClick(String sql ,String frameName) {
		this.sql=sql;
		this.frameName=frameName;
	}
	/*************************show()*****************************/
	public void show(){
		final JFrame fm=new JFrame(frameName);//创建一个窗口
		fm.setSize(600,250);//大小
		 Dimension screen = Toolkit.getDefaultToolkit().getScreenSize(); 
			fm.setLocation( 
				(screen.width - fm.getWidth()) / 2, 
				(screen.height - fm.getHeight()) / 2);//位置
		fm.setLayout(new BorderLayout());//窗口布局
		final JPanel p1=new JPanel();//创建一个容器
		final JLabel lb1=new JLabel("请输入查询旅客姓名:");//标签
		final JTextField tf=new JTextField(10);//文本框
		final JButton bt1=new JButton("查询");//查询按钮
		p1.setLayout(new FlowLayout());//容器布局
		p1.add(lb1);p1.add(tf);p1.add(bt1);//添加组件
		final JPanel p2=new JPanel();//容器2
		p2.setLayout(new BorderLayout());//容器2布局
		p2.add(p1,"North");
		p2.add(new Query().getTablePane(sql),"Center");//调用文件Query中的getTablePane()方法
		fm.add(p2);
		fm.setVisible(true);
		fm.setResizable(false);
		fm.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				fm.dispose();
			}
		});
/*********************实现对查询按钮的监听*******************************************/
		bt1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				System.out.println("3");
				String temp=sql;
				if(tf.getText().trim().equalsIgnoreCase(""))
				{
					p2.removeAll();
					p2.add(new Query().getTablePane(sql),"Center");
					p2.add(p1,"North");
					fm.add(p2);
					fm.setVisible(true);
				}
				else
				{
					System.out.println("3");
					temp=temp+" AND 姓名='"+tf.getText().trim()+"'";
					p2.removeAll();
					p2.add(new Query().getTablePane(temp),"Center");
					p2.add(p1,"North");
					fm.add(p2);
					fm.setVisible(true);
				}
			}		
		});
	}
	public void actionPerformed(ActionEvent arg0) {
		show();
	}
}