ordersituation.java

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

package GraphicsUI;

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

public class OrderSituation {

	JInternalFrame jif;

	MainFrame mf;

	Connection conn;

	Statement stmt;

	ResultSet rs;

	Vector column;

	Vector info;

	JTable jt;

	ResultSetMetaData rsmd;

	JScrollPane js;

	String[] head = { "姓名", "证件类型", "证件号", "机舱类型", "机票类型", "航班号" };

	public OrderSituation(MainFrame m) {
		mf = m;
		jt = new JTable();
		jt.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
		jt.setSelectionBackground(Color.RED);
		jt.setCursor(new Cursor(12));
		js = new JScrollPane(jt);
		jif = new JInternalFrame("订票情况", false, true, false, true);
		jif.add(js, BorderLayout.CENTER);
		try {
			// int t = 0;
			conn = DriverManager.getConnection(
					"jdbc:microsoft:sqlserver://localhost:1433", "sa", "");
			stmt = conn.createStatement();
			rs = stmt.executeQuery("select * from ordersituation");
			rsmd = rs.getMetaData();
			int ColNum = rsmd.getColumnCount();
			System.out.println(ColNum);
			column = new Vector();
			for (int i = 0; i < head.length; i++) {
				column.add(head[i]);
				System.out.println(head[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();// 更新
			rs.close();
			stmt.close();
			conn.close();
			jif.setVisible(true);
		} catch (SQLException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}
	}
}