ReembolsoDAO.java

/*
 * Copyright 2012 MoonJava LTDA.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package br.com.moonjava.flight.dao.base;

import br.com.moonjava.flight.jdbc.SqlStatementWrapper;
import br.com.moonjava.flight.model.base.Passagem;
import br.com.moonjava.flight.model.base.Reembolso;

/**
 * @version 1.0, Aug 13, 2012
 * @contact miqueias@moonjava.com.br
 * 
 */
public class ReembolsoDAO implements Reembolso.Jdbc {

  @Override
  public boolean criar(Reembolso reembolso) {
    Passagem passagem = reembolso.getPassagem();
    boolean executed = new SqlStatementWrapper()
        .prepare()

        .with("insert into FLIGHT.REEMBOLSO")
        .with("(ID, PASSAGEM_ID, TITULAR, CPF, BANCO, AGENCIA, CONTA, VALOR)")

        .with("values (")
        .with("?,", reembolso.getId())
        .with("?,", passagem.getId())
        .with("?,", reembolso.getTitular())
        .with("?,", reembolso.getCpf().getDigito())
        .with("?,", reembolso.getBanco())
        .with("?,", reembolso.getAgencia())
        .with("?,", reembolso.getConta())
        .with("?)", reembolso.getValor())

        .andExecute();
    return executed;
  }

}