resulttable.java

航班查询与订票系统 用Java与sqlserver2000来编写一个航班查询与订票系统

package flight.query;

import javax.swing.JFrame;
import javax.swing.table.DefaultTableModel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import java.awt.GridLayout;
/**
 * 显示查询结果的表格
 */
public class ResultTable
    extends JFrame {
  JTable table;
  JTable table2;
  JScrollPane pane;
  JScrollPane pane2;
  /**
   *以单表方式显示查询结果（用于单程查询）
   */
  public ResultTable(String title, ResultSet rs) {
    this.setSize(700, 400);

    String[] name = {
        "航班号", "公司", "起飞地", "目的地", "起飞时间", "到达时间", "儿童票价", "成人票价", "折扣", "退票率","班期"};
    String[][] data = new String[0][0];
    DefaultTableModel defaultModel = new DefaultTableModel(data, name);
    table = new JTable(defaultModel);
    pane = new JScrollPane(table);
    this.getContentPane().add(pane);

    try {
      while (rs.next()) {
        Vector vector = new Vector();
        vector.addElement(rs.getString(1));
        vector.addElement(rs.getString(2));
        vector.addElement(rs.getString(3));
        vector.addElement(rs.getString(4));
        vector.addElement(rs.getString(5));
        vector.addElement(rs.getString(6));
        vector.addElement(rs.getString(7));
        vector.addElement(rs.getString(8));
        vector.addElement(rs.getString(9));
        vector.addElement(rs.getString(10));
        vector.addElement(rs.getString(12));
        defaultModel.addRow(vector);
      }
      table.revalidate();
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
    catch (Exception ex) {
      System.out.println(ex.toString());
    }
    this.setTitle(title);
  }

  /**
   *以双表方式显示查询结果（用于双程查询和联程查询）
   */
  public ResultTable(String title, DefaultTableModel model1,
                     DefaultTableModel model2) {
    this.setSize(700, 400);
    this.getContentPane().setLayout(new GridLayout(2, 1));
    table = new JTable(model1);
    table2 = new JTable(model2);
    pane = new JScrollPane(table);
    this.getContentPane().add(pane);
    pane2 = new JScrollPane(table2);
    this.getContentPane().add(pane2);

    this.setTitle(title);
  }

}