public ContatoEmpreiteiraModel obter(ContatoEmpreiteiraModel contatoEmpreiteiraModel) {

    TSDataBaseBrokerIf broker = TSDataBaseBrokerFactory.getDataBaseBrokerIf();

    broker.setPropertySQL("contatoempreiteiradao.obter", contatoEmpreiteiraModel.getId());

    return (ContatoEmpreiteiraModel)
        broker.getObjectBean(
            ContatoEmpreiteiraModel.class, "id", "nome", "email", "telefone", "empreiteira.id");
  }