show.java~4~

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

package flight.manage;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import java.sql.*;

public class Show
    extends JPanel
    implements ActionListener {
  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 JTextArea area = new JTextArea();
  private JScrollPane pan;
  private Connection con;
  private Statement stmt;
  private ResultSet rs;

  public Show() {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (Exception ex) {
    }
    pan = new JScrollPane(area);
    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) {
    try {

      area.setText("");
      if (! (jtf.getText().equals("0303") &&
             new String(password.getPassword()).trim().equals("0303")))
        JOptionPane.showMessageDialog(null, "账号或密码不对", "错误",
                                      JOptionPane.ERROR_MESSAGE);
      else {
        con = DriverManager.getConnection("jdbc:odbc:flight", "sa", "");
        stmt = con.createStatement();
        rs = stmt.executeQuery("select * from flight");
        while (rs.next()) {
          area.append(rs.getString(1));
          area.append(rs.getString(2));
          area.append(rs.getString(3));
          area.append(rs.getString(4));
          area.append(rs.getString(5));
          area.append(rs.getString(6));
          area.append("" + rs.getFloat(7) + "  ");
          area.append("" + rs.getFloat(8) + "  ");
          area.append("" + rs.getFloat(9) + "  ");
          area.append("" + rs.getFloat(10) + "  ");
          area.append("" + rs.getInt(11) + "  ");
          area.append(rs.getString(12));
          area.append(rs.getString(13) + "\n");

        }
      }
    }
    catch (Exception ex) {
    }

  }

  public static void main(String[] args) {
    try {
      UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
    }
    catch (Exception ex) {

    }
    JFrame frame = new JFrame();
    frame.getContentPane().add(new Show());
    frame.setSize(500, 450);

    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame.setVisible(true);
  }
}