flightlist.java~1~

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

package flight.manage;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import java.sql.*;
import flight.assist.DataBaseManager;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;

public class Show
    extends JPanel
    implements ActionListener {
  DataBaseManager dbManager = DataBaseManager.getInstance();

  private JTextField jtf = new JTextField(10);
  private JPasswordField password = new JPasswordField(10);
  private JLabel label1 = new JLabel("账号");
  private JLabel label2 = new JLabel("密码");
  private JButton button = new JButton("查看");
  private JTable table = null;
  private DefaultTableModel defaultModel = null;
  private JScrollPane pan;

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

    pan = new JScrollPane(table);
    JPanel p1 = new JPanel();
    p1.setBorder(new TitledBorder("输入有效认证"));
    p1.add(label1);
    p1.add(jtf);
    p1.add(label2);
    p1.add(password);

    JPanel p2 = new JPanel();
    p2.setBorder(new TitledBorder("操作"));
    p2.add(button);

    this.setLayout(new BorderLayout());
    this.add(p1, BorderLayout.NORTH);
    this.add(pan, BorderLayout.CENTER);
    this.add(p2, BorderLayout.SOUTH);

    button.addActionListener(this);
  }

  public void actionPerformed(ActionEvent e) {
    if (! (jtf.getText().equals("0303") &&
           new String(password.getPassword()).trim().equals("0303")))
      JOptionPane.showMessageDialog(null, "账号或密码不对", "错误",
                                    JOptionPane.ERROR_MESSAGE);
    else {

      //首先要删除table中的数据先：
      int rowCount = defaultModel.getRowCount() - 1; //取得table中的数据行；
      int j = rowCount;
      for (int i = 0; i <= rowCount; i++) {
        defaultModel.removeRow(j); //删除rowCount行的数据；
        defaultModel.setRowCount(j); //重新设置行数；
        j = j - 1;
      }
      String sql = "select * from flight";
      ResultSet rs = dbManager.getResult(sql);
      try {
        while (rs.next()) {
          Vector data = new Vector();
          data.addElement(rs.getString(1));
          data.addElement(rs.getString(2));
          data.addElement(rs.getString(3));
          data.addElement(rs.getString(4));
          data.addElement(rs.getString(5));
          data.addElement(rs.getString(6));
          data.addElement(rs.getString(7));
          data.addElement(rs.getString(8));
          data.addElement(rs.getString(9));
          data.addElement(rs.getString(10));
          defaultModel.addRow(data);
        }
        table.revalidate();
      }
      catch (SQLException sqle) {
        System.out.println(sqle.toString());
      }
      catch (Exception ex) {
        System.out.println(ex.toString());
      }

    }
  }
}