show.java~7~

航班查询与订票系统 用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;

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 {
      String sql = "select * from flight";
      ResultSet rs = dbManager.getResult(sql);
      try {
        while (rs.next()) {

        }
      }
      catch (Exception ex) {
      }
    }
  }
}