client.java~1~

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

  int adultnumber = 0;
  int childnumber = 0;
  int ticketnumber = 0;

  public void actionPerformed(ActionEvent e) {

    int len1 = jbtname.getText().trim().length();
    int len2 = jbtid.getText().trim().length();
    int len3 = jbtadultticketnumber.getText().trim().length();
    int len4 = jbtchildticketnumber.getText().trim().length();
    int len5 = jbttelephone.getText().trim().length();

    if (e.getSource() == handin) {
      string[12] = jbtname.getText().trim();
      string[13] = jbtid.getText().trim();

      int i = 0; // leftticket for single
      int j = 0; // leftticket for double and multiple
      if (len1 == 0 || len2 == 0 || len3 == 0 || len4 == 0 || len5 == 0) {
        String str = getstring(len1, len2, len3, len4, len5);
        JOptionPane.showMessageDialog(this, str, "错误信息！",
                                      JOptionPane.ERROR_MESSAGE);

      }
      else {
        adultnumber = Integer.parseInt(jbtadultticketnumber.getText().trim());
        childnumber = Integer.parseInt(jbtchildticketnumber.getText().trim());

        string[14] = String.valueOf(adultnumber);
        string[15] = String.valueOf(childnumber);

        ticketnumber = adultnumber + childnumber;
        ////single
        if (string[5].toString().trim().equals("单程")) {
          i = seatinformation.dingPiao(string[4], string[3], ticketnumber);

          if (i != -2) {
            if (i == -1) {
              float adultfare = 0;
              float childfare = 0;
              float piaojia = 0;
              try {
                Connection con = DriverManager.getConnection(
                    "jdbc:odbc:flight", "sa", "");
                Statement stmt = con.createStatement();
                ResultSet rs = stmt.executeQuery(
                    "select adultFare,childFare from flight where flight='" +
                    string[4] + "'");
                while (rs.next()) {
                  adultfare = rs.getFloat(1);
                  childfare = rs.getFloat(2);
                }

              }
              catch (Exception ex) {
              }
              piaojia = adultnumber * adultfare + childnumber * childfare;
              String dingdan = string[3] + string[4] +
                  String.valueOf( (int) (100 * Math.random()));
              string[16] = dingdan;
              string[21] = "" + piaojia;
              JOptionPane.showMessageDialog(this,
                                            "   恭喜！提交成功\n你的定单号是" + dingdan +
                                            "\n" + "你应付价钱为" + piaojia,
                                            "客户信息",
                                            JOptionPane.INFORMATION_MESSAGE);
              Hangkong.clientFrame.setVisible(false);
              Hangkong.clientFrame.dispose();
              Hangkong.frame.setVisible(true);
              writeToFile writetofile = new writeToFile(string);
            }
            else {
              JOptionPane.showMessageDialog(this,
                                            "非常抱歉！只有" + i + "张航班票剩余\n请您重新选择票数",
                                            "客户信息",
                                            JOptionPane.INFORMATION_MESSAGE);
              jbtadultticketnumber.setText(" ");
              jbtchildticketnumber.setText(" ");
            }
          }
          else {
            JOptionPane.showMessageDialog(null, "对不起，今天没有这个航班",
                                          "客户信息", JOptionPane.ERROR_MESSAGE);
          }
        }
        //double
        else { //if(string[5].toString().trim().equals("往返")||string[5].toString().trim().equals("往返"))
          i = seatinformation.dingPiao(string[4], string[3], ticketnumber);
          j = seatinformation.dingPiao(string[11], string[10], ticketnumber);

          if (i == -2)
            JOptionPane.showMessageDialog(null, "对不起，今天没有第一个航班",
                                          "客户信息", JOptionPane.ERROR_MESSAGE);
          else if (j == -2)
            JOptionPane.showMessageDialog(null, "对不起，今天没有第二个航班",
                                          "客户信息", JOptionPane.ERROR_MESSAGE);
          else {
            if (i == -1 && j == -1) {
              float adultfare = 0;
              float childfare = 0;
              float piaojia = 0;
              try {
                Connection con = DriverManager.getConnection(
                    "jdbc:odbc:flight", "sa", "");
                Statement stmt = con.createStatement();
                ResultSet rs = stmt.executeQuery(
                    "select adultFare,childFare from flight where flight='" +
                    string[4] + "'");
                while (rs.next()) {
                  adultfare = rs.getFloat(1);
                  childfare = rs.getFloat(2);
                }

              }
              catch (Exception ex) {
              }
              piaojia = adultnumber * adultfare + childnumber * childfare;
              try {
                Connection con = DriverManager.getConnection(
                    "jdbc:odbc:flight", "sa", "");
                Statement stmt = con.createStatement();
                ResultSet rs = stmt.executeQuery(
                    "select adultFare,childFare from flight where flight='" +
                    string[11] + "'");
                while (rs.next()) {
                  adultfare = rs.getFloat(1);
                  childfare = rs.getFloat(2);
                }

              }
              catch (Exception ex) {
              }
              piaojia = piaojia + adultnumber * adultfare +
                  childnumber * childfare;
              String dingdan = string[3] + string[4] +
                  String.valueOf( (int) (100 * Math.random()));
              string[16] = dingdan;
              string[21] = "" + piaojia;
              JOptionPane.showMessageDialog(this,
                                            "   恭喜！提交成功\n你的定单号是" + dingdan +
                                            "\n" + "你应付价钱为" + piaojia,
                                            "客户信息",
                                            JOptionPane.INFORMATION_MESSAGE);
              Hangkong.clientFrame.setVisible(false);
              Hangkong.clientFrame.dispose();
              Hangkong.frame.setVisible(true);

              writeToFile writetofile = new writeToFile(string);

            }

            else {
              if (i != -1) {
                JOptionPane.showMessageDialog(this,
                                              "非常抱歉！只有" + i +
                                              "张第一航班票剩余\n请您重新选择票数",
                                              "客户信息",
                                              JOptionPane.INFORMATION_MESSAGE);
                jbtadultticketnumber.setText(" ");
                jbtchildticketnumber.setText(" ");
              }
              else {
                if (j != -1) {
                  JOptionPane.showMessageDialog(this,
                                                "非常抱歉！只有" + j +
                                                "张返回航班票剩余\n请您重新选择票数",
                                                "客户信息",
                                                JOptionPane.INFORMATION_MESSAGE);
                  jbtadultticketnumber.setText(" ");
                  jbtchildticketnumber.setText(" ");
                }
              }
            }
          }

        }
        //multiple

      }
    }
    if (e.getSource() == rewrite) {
      jbtname.setText("");
      jbtid.setText("");
      jbtadultticketnumber.setText("");
      jbtchildticketnumber.setText("");
      jbttelephone.setText("");
      jbtqq.setText("");
      jbtemail.setText("");
      jbtps.setText("");
    }
    if (e.getSource() == return1) {
      Hangkong.clientFrame.setVisible(false);
      Hangkong.clientFrame.dispose();
      Hangkong.frame.setVisible(true);
    }

  }

  public String getstring(int i, int j, int r, int s, int l) {
    if (i == 0)
      return "姓名不能为空！";
    else if (j == 0)
      return "证件号不能为空！";
    else if (r == 0)
      return "成人票数不能为空！";
    else if (s == 0)
      return "儿童票数不能为空";
    else if (l == 0)
      return "电话号码不能为空";

    return "ERROR!";
  }
}