queryflight.java

航空航天订票系统 是数据库的课程设计 单机版

package GraphicsUI;

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.Vector;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;

public class QueryFlight implements ActionListener {

	JFrame jf;

	JInternalFrame jif;

	JLabel initl;

	JLabel targetl;

	JTextField initt;

	JTextField targett;

	JLabel stimel;

	JTextField stimet;

	JLabel ttimel;

	JTextField ttimet;

	JLabel idl;

	JTextField idt;

	JTable jt;

	JPanel westup;

	JPanel westdown;

	JPanel west;

	JPanel w1;

	JPanel w2;

	JPanel w3;

	JPanel w4;

	JPanel w5;

	JScrollPane js;

	JButton clear;

	JButton select;

	JPanel two; // 预留容器空间,为OrderOperation的继承做准备。

	MainFrame mf;

	Connection conn;

	Statement stmt;

	ResultSet rs;

	ResultSetMetaData rsmd;

	Vector column;

	Vector info;

	public QueryFlight(MainFrame m) {
		mf = m;
		jt = new JTable();
		js = new JScrollPane(jt);
		// JInternalFrame(String title, boolean resizable, boolean closable,
		// boolean maximizable)
		jif = new JInternalFrame("航班查询", false, true, false, true);
		clear = new JButton("清空条件");
		clear.addActionListener(this);
		select = new JButton("查询航班");
		select.addActionListener(this);
		initl = new JLabel("出发城市:");
		targetl = new JLabel("目的城市:");
		initt = new JTextField(10);
		targett = new JTextField(10);
		stimel = new JLabel("出发时间:");
		stimet = new JTextField(10);
		ttimel = new JLabel("抵达时间:");
		ttimet = new JTextField(10);
		idl = new JLabel("航班代号:");
		idt = new JTextField(10);
		w1 = new JPanel();
		w1.setLayout(new FlowLayout());
		w2 = new JPanel();
		w2.setLayout(new FlowLayout());
		w3 = new JPanel();
		w3.setLayout(new FlowLayout());
		w4 = new JPanel();
		w4.setLayout(new FlowLayout());
		w5 = new JPanel();
		w5.setLayout(new FlowLayout());
		w1.add(initl);
		w1.add(initt);
		w2.add(targetl);
		w2.add(targett);
		w3.add(stimel);
		w3.add(stimet);
		w4.add(ttimel);
		w4.add(ttimet);
		w5.add(idl);
		w5.add(idt);
		westup = new JPanel();
		westup.setLayout(new GridLayout(5, 1));
		westup.add(w1);
		westup.add(w2);
		westup.add(w3);
		westup.add(w4);
		westup.add(w5);
		westdown = new JPanel();
		westdown.setLayout(new FlowLayout());
		westdown.add(select);
		westdown.add(clear);
		two = new JPanel();
		two.setLayout(new GridLayout(2, 1));
		two.add(westdown);
		west = new JPanel();
		west.setLayout(new GridLayout(2, 1));
		west.add(westup);
		west.add(two);
		jif.add(west, BorderLayout.WEST);
		jif.setVisible(true);
		jif.add(js, BorderLayout.CENTER);
		// mf.mf.add(jif, BorderLayout.CENTER);
		jt.setCursor(new Cursor(12));
		jt.setSelectionForeground(Color.RED);
	}

	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		if (e.getSource() == clear) {
			initt.setText("");
			targett.setText("");
			stimet.setText("");
			ttimet.setText("");
			idt.setText("");
		}
		if (e.getSource() == select) {
			try {
				// int t = 0;
				conn = DriverManager.getConnection(
						"jdbc:microsoft:sqlserver://localhost:1433", "sa", "");
				stmt = conn.createStatement();
				String str = initt.getText().trim() + "-"
						+ targett.getText().trim();
				// if (str.equals("-") && stimet.equals(""))stimet.getText();
				// System.out.println("yes");
				if (str.equals("-") && stimet.getText().equals("")
						&& ttimet.getText().equals("")
						&& idt.getText().equals("")) {
					rs = stmt.executeQuery("select * from customer");

				} else if (initt.getText().equals("")
						&& !targett.getText().equals("")) {
					rs = stmt
							.executeQuery("select * from customer where 路径 like '%"
									+ targett.getText().trim() + "'");
				} else if (!initt.getText().equals("")
						&& targett.getText().equals("")) {
					rs = stmt
							.executeQuery("select * from customer where 路径 like '"
									+ str + "%'");
				} else if (!stimet.getText().equals("")
						&& !ttimet.getText().equals("")) {
					rs = stmt.executeQuery("select * from customer where 路径='"
							+ str + "' and 出发时间='" + stimet.getText().trim()
							+ "' and 抵达时间='" + ttimet.getText().trim() + "'"
							+ "or 航班号 ='" + idt.getText().trim() + "'");
				} else {
					rs = stmt.executeQuery("select * from customer where 路径='"
							+ str + "' or 出发时间='" + stimet.getText().trim()
							+ "' or 抵达时间='" + ttimet.getText().trim() + "'"
							+ "or 航班号 ='" + idt.getText().trim() + "'");
				}
				rsmd = rs.getMetaData();
				int ColNum = rsmd.getColumnCount();
				System.out.println(ColNum);
				column = new Vector();
				for (int i = 1; i <= ColNum; i++) {
					column.add(rsmd.getColumnName(i));
					System.out.println(rsmd.getColumnName(i));
				}
				info = new Vector();
				while (rs.next()) {
					Vector temp = new Vector();
					for (int j = 1; j <= ColNum; j++) {
						System.out.println(rs.getObject(j));
						String t = rs.getObject(j).toString();
						temp.add(t.trim());// 去空格
					}
					info.add(temp);
				}
				DefaultTableModel tm = new DefaultTableModel(info, column);
				jt.setModel(tm);
				jt.repaint();
				jt.updateUI();// 更新
				while (rs.next()) {
					System.out.println(rs.getString(1));
				}
				rs.close();
				stmt.close();
				conn.close();
			} catch (SQLException e1) {
				// TODO 自动生成 catch 块
				e1.printStackTrace();
			}
		}

	}
}