Package br.com.moonjava.flight.jdbc

Examples of br.com.moonjava.flight.jdbc.SqlStatementWrapper

33
34
35
36
37
38
39
40
41
42
43
*
*/
public class VooDAO implements Voo.Jdbc {

  private SqlStatement query() {
    return new SqlStatementWrapper()
        .prepare()

        .with("select *")
        .with("from FLIGHT.VOO as VOO")

View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
  @Override
  public boolean criar(Voo voo) {
    boolean executed = false;
    if (voo != null) {
      Aeronave aeronave = voo.getAeronave();
      executed = new SqlStatementWrapper()
          .prepare()

          .with("insert into FLIGHT.VOO")
          .with("(AERONAVE_ID, CODIGO, ORIGEM, DESTINO, ESCALA,")
          .with("DATA_PARTIDA, DATA_CHEGADA, STATUS, ASSENTO_LIVRE, PRECO)")
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
  @Override
  public boolean atualizar(Voo voo) {
    boolean executed = false;
    if (voo != null) {
      executed = new SqlStatementWrapper()
          .prepare()

          .with("update FLIGHT.VOO set")
          .with("DATA_PARTIDA = ?,", voo.getDataDePartida())
          .with("DATA_CHEGADA = ?,", voo.getDataDeChegada())
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
    return executed;
  }

  @Override
  public void deletar(int id) {
    new SqlStatementWrapper()
        .prepare()

        .with("delete from FLIGHT.VOO")
        .with("where ID = ?", id)
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
        .andExecute();
  }

  @Override
  public void deletarPorAeronaveId(int id) {
    new SqlStatementWrapper()
        .prepare()

        .with("delete from FLIGHT.VOO")
        .with("where AERONAVE_ID = ?", id)
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
        .andExecute();
  }

  @Override
  public void controlarStatus(int id, Status status) {
    new SqlStatementWrapper()
        .prepare()

        .with("update FLIGHT.VOO set")
        .with("STATUS = ?", status.ordinal())
View Full Code Here
183
184
185
186
187
188
189
190
191
192
193
        .andExecute();
  }

  @Override
  public void incrementarAssento(int id) {
    new SqlStatementWrapper()
        .prepare()

        .with("update FLIGHT.VOO set")
        .with("ASSENTO_LIVRE = (ASSENTO_LIVRE+1)")
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
        .andExecute();
  }

  @Override
  public void decrementarAssento(int id) {
    new SqlStatementWrapper()
        .prepare()

        .with("update FLIGHT.VOO set")
        .with("ASSENTO_LIVRE = (ASSENTO_LIVRE-1)")
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
*
*/
public class AeronaveDAO implements Aeronave.Jdbc {

  private SqlStatement query() {
    return new SqlStatementWrapper()
        .prepare()

        .with("select *")
        .with("from FLIGHT.AERONAVE as AERONAVE")

View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
        .load(new AeronaveLoader());
  }

  @Override
  public void criar(Aeronave aeronave) {
    new SqlStatementWrapper()
        .prepare()

        .with("insert into FLIGHT.AERONAVE")
        .with("(NOME, CODIGO, QTD_ASSENTO, MAPA)")
        .with("values (")
View Full Code Here
TOP

Related Classes of br.com.moonjava.flight.jdbc.SqlStatementWrapper

  • br.com.moonjava.flight.dao.base.AeronaveDAO
  • br.com.moonjava.flight.dao.base.PassagemDAO
  • br.com.moonjava.flight.dao.base.PessoaFisicaDAO
  • br.com.moonjava.flight.dao.base.ReembolsoDAO
  • br.com.moonjava.flight.dao.base.UsuarioDAO
  • br.com.moonjava.flight.dao.base.VooDAO
  • br.com.moonjava.flight.util.GerarCodigo
  • java.sql.ResultSet
    • 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.