コード例 #1
0
  @Override
  public void update(Lavagem entity) {
    Connection conexao = ConnectionManager.get();

    PreparedStatement ps;
    try {
      ps =
          conexao.prepareStatement(
              "INSERT INTO lavagem SET tipo=?, horaInicio=?, horaSaida=?, preco=?, idcliente=?, idfuncionario=?"
                  + " WHERE idlavagem=?");

      ps.setInt(1, entity.getTipo());
      ps.setString(2, entity.getHoraEntrada() + "");
      ps.setString(3, entity.getHoraSaida() + "");
      ps.setDouble(4, entity.getValor());
      ps.setInt(5, entity.getCliente().getId());
      ps.setInt(6, entity.getFuncionario().getId());

      ps.execute();
      ps.close();

    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }