Package edu.spbstu.hoteldb.interfaces

Examples of edu.spbstu.hoteldb.interfaces.SQLQuery

40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
    String lang = ((ChoiceBox<String>) args.get(5)).getValue();
    if ((email.compareTo("") == 0) || (pass.compareTo("") == 0)
        || (name.compareTo("") == 0)) {
      textArea.appendText("Login, password and name are required to complete registration.");
    } else {
      SQLQuery nuu = new NewUserUpdate(connect, textArea);
      List<Object> args = new LinkedList<Object>();
      args.add(login); args.add(email); args.add(pass); args.add(name); args.add(country); args.add(lang);
      try {
        nuu.prepareQuery(args);
        nuu.doQuery();
        main.setPanel(PanelType.LoginPanel, null);       
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    connect = connection;
  }

  @Override
  public void handle(ActionEvent arg0) {
    SQLQuery query = new SearchRoomQuery(connect, results);
    LinkedList<Object> args = new LinkedList<Object>();
    Integer pc = Integer.MAX_VALUE;
    Integer cost = Integer.MAX_VALUE;
    try {
      pc = Integer.parseInt(tfpcount.getText());
    } catch (NumberFormatException e) {
      // ignore
    }
    try {
      cost = Integer.parseInt(tfcost.getText());
    } catch (NumberFormatException e) {
      // ignore
    }
    args.addLast(pc);
    args.addLast(cost);
    args.addLast(new Boolean(chckbxdesc.isSelected()));
    args.addLast(chbbar.getValue());

    try {
      query.prepareQuery(args);
      query.doQuery();
      query.close();
    } catch (SQLException e) {
      results.appendText(e.getMessage() + '\n');
      e.printStackTrace();
    }
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
      return;
    }
   
    arg.add(from.toString()); arg.add(to.toString());
    try {
      SQLQuery query = new HistorySearchQuery(connect, results);
      query.prepareQuery(arg);
      query.doQuery();
      query.close();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
  @Override
  public void handle(ActionEvent event) {
    try {
      Integer id = Integer.parseInt(textField.getText());
      Integer roomnum = Integer.parseInt(textField.getText());
      SQLQuery bu = new BookUpdate(null, textArea);
      List<Object> args = new LinkedList<Object>();
      args.add(id); args.add(roomnum);
      bu.prepareQuery(args);
      bu.doQuery();
    } catch (NumberFormatException e) {
      textArea.appendText("invalid room number");
    } catch (SQLException e) {
      e.printStackTrace();
    }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
41
42
  public void handle(ActionEvent arg0) {
    List<Object> arg = new LinkedList<Object>();
    arg.add(((TextField) args.get(0)).getText());
    arg.add(((TextField) args.get(1)).getText());
    try {
      SQLQuery query = new PersonnelSearchQuery(results, connect);
      query.prepareQuery(arg);
      query.doQuery();
      query.close();
    } catch (SQLException e) {
      results.appendText("invalid query\n");
      e.printStackTrace();
    }
  }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
51
      results.appendText("from date >= to date\n");
      return;
    }
    arg.add(from.toString()); arg.add(to.toString());
    try {
      SQLQuery query = new IncomeCalcQuery(connect, results);
      query.prepareQuery(arg);
      query.doQuery();
      query.close();
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
    args = arg;
  }
 
  @Override
  public void handle(ActionEvent arg0) {
    SQLQuery query = new ClientSearchQuery(results, connect);
    try {
      List<Object> arg = new LinkedList<Object>();
      arg.add(((TextField) args.get(0)).getText());
      arg.add(((TextField) args.get(1)).getText());
      query.prepareQuery(arg);
      query.doQuery();
      query.close();
    } catch (SQLException e) {
      results.appendText("invalid query\n");
      e.printStackTrace();
    }
  }
View Full Code Here
TOP

Related Classes of edu.spbstu.hoteldb.interfaces.SQLQuery

  • edu.spbstu.hoteldb.admin.handler.IncomeCalcEventHandler
  • edu.spbstu.hoteldb.admin.handler.PersonnelSearchEventHandler
  • edu.spbstu.hoteldb.handlers.BookEventHandler
  • edu.spbstu.hoteldb.handlers.ClientSearchEventHandler
  • edu.spbstu.hoteldb.handlers.HistorySearchEventHandler
  • edu.spbstu.hoteldb.handlers.RegisterQueryEventHandler
  • edu.spbstu.hoteldb.handlers.SearchRoomEventHandler
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.