CODEWITHSUNDEEP
javams-accessjackcess
Purus
Purus

Reputation: 5799

Reading all rows by using multiple columns in java jackcess

In Java using Jackcess, I have 2 questions on the below code.

  1. In the below code, I have used only the column Active to fetch rows. How can I add multiple columns in same table? Or can I make a join?

  2. The below code fetches only 1 row. Where can I find the logic of reading the entire result set?

The docs of jackcess is not complete on these aspects. Also in making search, all examples were related to jackcess 1 and not for latest version.

Row row = CursorBuilder.findRow(tblTC, Collections.singletonMap("Active", true));

if(row != null) {
    System.out.println(row);
}

Upvotes: 1

Views: 872

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123419

For more complex queries (including JOINs, etc.) you might want to consider using UCanAccess. For more information see a related question here.

Upvotes: 2

Related Questions