selectflight.java

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

package GraphicsUI;

import java.awt.*;
import java.sql.*;
import java.util.Enumeration;
import java.util.Vector;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;

public class SelectFlight implements ActionListener {

	JInternalFrame jif;

	JPanel p;

	JButton btn;

	JButton btn2;

	Vector id = new Vector();

	JComboBox jcb;

	MainFrame mf;

	JTable jt;

	JScrollPane js;

	Connection conn;

	Statement stmt;

	PreparedStatement ps;

	ResultSetMetaData rsmd;

	ResultSet rs;

	Vector column;

	// String
	String[] head = { "航线号", "始发机场", "抵达机场", "起飞时间", "抵达时间", "航空公司", "机型",
			"是否直达", "飞行周期", "路径" };

	Vector info;

	// JFrame jf;

	public SelectFlight(MainFrame m) {
		mf = m;
		try {
			// int t = 0;
			conn = DriverManager.getConnection(
					"jdbc:microsoft:sqlserver://localhost:1433", "sa", "");
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select distinct flyno from flights");
			while (rs.next()) {
				id.add(rs.getString(1));
				System.out.println(rs.getString(1));
			}
			rs.close();
		} catch (SQLException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}
		// jf = new JFrame();
		jif = new JInternalFrame("查看航线", false, true, false, true);
		jt = new JTable();
		jt.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
		js = new JScrollPane(jt);
		jif.add(js, BorderLayout.CENTER);
		p = new JPanel();
		p.setLayout(new FlowLayout());
		jcb = new JComboBox(id);
		btn = new JButton("查看此航班航线");
		btn2 = new JButton("查看所有航线");
		btn2.addActionListener(this);
		p.add(jcb);
		p.add(btn);
		p.add(btn2);
		jif.add(p, BorderLayout.NORTH);
		jif.setVisible(true);
		btn.addActionListener(this);
		// 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() == btn) {
			try {
				rs.close();
				stmt.close();
				System.out.println("this event is OK");
				String sql = "select * from flights where flyno = '"
						+ jcb.getSelectedItem() + "' ";
				stmt = conn.createStatement();

				System.out.println(jcb.getSelectedItem());//
				rs = stmt.executeQuery(sql);
				rsmd = rs.getMetaData();
				int ColNum = rsmd.getColumnCount();
				System.out.println(ColNum);
				column = new Vector();
				for (int i = 1; i <= head.length; i++) {
					column.add(head[i - 1]);
					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));
						if (j == 8) {
							if (rs.getInt(j) == 0) {
								temp.add("是");
							} else
								temp.add("否");
						} else {
							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));
				}
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		}
		if (e.getSource() == btn2) {
			try {
				rs.close();
				stmt.close();
				System.out.println("this event is OK");
				String sql = "select * from flights";
				stmt = conn.createStatement();

				System.out.println(jcb.getSelectedItem());//
				rs = stmt.executeQuery(sql);
				rsmd = rs.getMetaData();
				int ColNum = rsmd.getColumnCount();
				System.out.println(ColNum);
				column = new Vector();
				for (int i = 1; i <= head.length; i++) {
					column.add(head[i - 1]);
					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));
						if (j == 8) {
							if (rs.getInt(j) == 0) {
								temp.add("是");
							} else
								temp.add("否");
						} else {
							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));
				}
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		}
	}

	// table.setModel(model);
	// table.repaint();
	// table.updateUI();

	// public static void main(String[] args){
	// }

}