Using the APIs
3 articlesChoose an API for each task and organize DAOs and dynamic conditions.
- One Mapper: Combining Builders, Annotations and XML
Use one order Mapper with a builder default method, an annotated short query and an XML report query.
- Dynamic SQL: Rules and XML Compared
Dynamic SQL can be expressed with XML tags or written directly in SQL using dbVisitor rules. Both approaches require clear semantics for condition activation, parameter binding, and empty collections. This article covers common rule patterns and explains which forms are not interchangeable.
- SQL Rules: Combining AND/OR Conditions
Use dbVisitor's AND/OR rules to build complex nested SQL conditions in one line.