querypanel.java

飞机订票系统（含界面

package AirT;

import java.awt.BorderLayout;
import java.awt.Choice;
import java.awt.Color;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
//import javax.swing.ProgressMonitorInputStream;
import javax.swing.ScrollPaneConstants;

class QueryPanel extends JPanel implements ActionListener{

	/**
	 * 
	 */
	private static final long serialVersionUID = 4387565320772840391L;
	String [] date = {"9-11","9-12","9-13","9-14","9-15"}; 
	String[] title = {"公司","航班号","日期","起飞时间","抵达时间",
			"起飞城市","降落城市","票价","折扣","数量","满员"};
	String [][]data = new String[20][11];
	JTextField tf1 = new JTextField(5),
			tf2 = new JTextField(5);
	
	JLabel lb1 = new JLabel("起飞城市:"),
		lb2 = new JLabel("抵达城市:"),
		lb3 = new JLabel("航程日期:"),
		lb4 = new JLabel("点击查询:");
	JLabel picture,pictureb;
	
	JPanel pn1 = new JPanel(),
		pn2 = new JPanel(),
		pn3 = new JPanel(),
		pn4 = new JPanel();

	JButton bt = new JButton("查询");

	JTable tab;// = new JTable(new MyTableModel());
	//JScrollPane sp = new JScrollPane(tab);
	Choice cbx = new Choice();
	int v = ScrollPaneConstants. VERTICAL_SCROLLBAR_AS_NEEDED;
	int h = ScrollPaneConstants. HORIZONTAL_SCROLLBAR_AS_NEEDED;
	
	public QueryPanel() {
		ImageIcon bp = new ImageIcon("img\\we.gif"),
			ba = new ImageIcon("img\\ba.gif");
		pn1.setLayout(new GridLayout(2,4));
		picture = new JLabel(bp);
		pictureb = new JLabel(ba);
		add(pn1,"West");
		//pn1.setBackground(Color.WHITE);
		pn1.add(lb1);
		pn1.add(tf1);
		pn1.add(lb2);
		pn1.add(tf2);
		pn1.add(lb3);
		for (int n = 0; n < date.length; n++) {
			cbx.addItem(date[n]);
		}
		pn1.add(cbx);
		pn1.add(lb4);
		pn1.add(bt);
		add(pn3,"East");
		pn3.setBackground(Color.LIGHT_GRAY);
		pn4.add(pictureb);
		add(pn4,"Center");
		pn3.add(picture);
		add(pn2,"South");
		//pn2.setBackground(Color.WHITE);
		tab = new JTable(data,title);
		JScrollPane sp = new JScrollPane(tab, v, h);
		pn2.add(sp,BorderLayout.CENTER);
		bt.addActionListener(this);
	}
	public void actionPerformed(ActionEvent e)
	{
		int m = 0;
		try 
		{
			Class.forName("org.gjt.mm.mysql.Driver");
			java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/airt",
					"root","123");
			java.sql.Statement stmt = conn.createStatement();
			String sql = "select company,sysboml,flydate,uptime,downtime,upcity,downcity,fare,agio,ticketnum,memberful from plane where flydate='" +cbx.getSelectedItem()+"'";
				sql +=	"and upcity= '" + tf1.getText() + "'";
				sql += "and downcity = '" + tf2.getText() + "'";
			java.sql.ResultSet rs = stmt.executeQuery( sql );
			while (rs.next())
			{
				String [] datas = {rs.getString("company"),rs.getString("sysboml"),
						rs.getString("flydate"),rs.getString("uptime"),
						rs.getString("downtime"),rs.getString("upcity"),
						rs.getString("downcity"),rs.getString("fare"),
						rs.getString("agio"),rs.getString("ticketnum"),
						rs.getString("memberful")};
			
				for (int i = 0; i < 11; i++) {
					data[m][i] = datas[i];
				}
				m++;
			}
			for (int n=0; n<m; n++)
			{
				for (int j=0; j<11; j++)
				{
					System.out.print(" "+data[n][j]);
				}
				System.out.println("");
			}
		}
		catch (Exception s)
		{
			s.printStackTrace();
		}
	}
}