Print Records from FindAll() in CrudRepository

Question

I am extending CrudRepository in my Repository class. I want to print the records in my table using the findAll method. So far, I have written a test class, and I can see the result query is correct. How can I print the individual records in the table?

Here is a snippet of my code: Repository Class

public interface RepositoryAda extends CrudRepository{


}

Service Class

@Service
public class Service{

@Autowired private RepositoryAda repository;

@Transactional
public List selectRecords(){
  return  (List) repository.findAll();
 }

}

Test Case:

@Test
public void getAllRecords() {
    service.selectRecords();
}

How can I print the individual records from the table to a console?

Also what do you mean print them to a table? Do you just want to print the records to the console in a tabular format? Or do you not know how to traverse an `Iterable`? — Paul Samsotha, May 29 '14 at 14:29

Paul Samsotha · Answer 1 · 2014-05-29T15:09:47.200

9

I prefer to use Google's Guava when using the repository interfaces. You can turn findAll() Iterable into a List<Type> with one line.

public RecordRepository extends CrudRepository<Record, Long> {}

public class RecordServiceImple implements RecordService {
    RecordRepository recordRepository;

    public List<Record> selectRecord() {
        return Lists.newArrayList(recordRepository.findAll()); // Guava library 
        // or just simply cast it. 
        // return (List<Record>)recordRepository.findAll();
    }
}

Then just loop through the list

for (Record record : records) {
    System.out.println(record);
}

Just overrive the toString() in your Record class, or whatever your class name is, to tabular formatting using String.format()

edited May 29 '14 at 15:09

answered May 29 '14 at 14:50

Paul Samsotha

205,037
37
486
720

Which import is Lists coming from? Based on this line: return Lists.newArrayList(recordRepository.findAll()); – user1324418 May 29 '14 at 15:00
It's from the Guava library. See the link – Paul Samsotha May 29 '14 at 15:00
3

Is there another way to do this without using Guava library? – user1324418 May 29 '14 at 15:02
8

Yeah, just cast it `return (List)recordRepository.findAll();` – Paul Samsotha May 29 '14 at 15:07

Print Records from FindAll() in CrudRepository

1 Answers1