liveBook · Manning

Database result set

As explained in Data-Oriented Programming: Reduce software complexity

A JDBC result set is an object that provides access to the tabular rows returned by a JDBC database query.

A JDBC result set provides access to rows returned by a database query. Treat it as a data-oriented boundary: extract column labels and values, then pass the resulting data onward without prematurely binding concrete types. section 10.1

From rows to maps

A conversion utility reads metadata, advances through each row, retrieves every column as an Object, and produces a List<Map<String, Object>>. A book search can then serialize those maps as JSON; concrete types matter at serialization time. section 10.1

How Data-Oriented Programming: Reduce software complexity covers it

How deep it goes
Shows metadata-driven iteration and Object-valued extraction, stopping short of detailed JDBC lifecycle or resource-management treatment.
Examples
Uses a book-search query, returned book rows, JSON-shaped maps, and a JDBC conversion utility.
What you can do after
Build it from scratch as a metadata-driven conversion from JDBC rows to maps suitable for downstream serialization.
How it connects
Connects JDBC with SQL queries, lists of maps, late binding, and JSON serialization.

Also explained in

Compare how 4 books explain database result set →

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Data-Oriented Programming: Reduce software complexity. The section links point to the parts of the book it draws on.