Arguments

dbVisitor provides multiple ways to pass arguments. This section explains how to use them.

Guide

• Positional Arguments: use ? placeholders in SQL and supply values in order. Java arrays are zero-based; JDBC PreparedStatement parameter indexes start at 1.
• Named Arguments: use :name, &name, or #{...} to name arguments in SQL.
• SQL Text Substitution: use ${...} to fetch named arguments and inject the result into SQL text.
• Rule-Based Arguments: use @{...} with the Rule mechanism to elegantly handle common dynamic SQL scenarios.
• Interface-based Arguments: customize argument setting via interfaces for special scenarios.

Additional Notes

• Argument Options: when using #{...} or SqlArg for arguments, you can specify extra options.
• Escaping Parameter Markers: output literal ?, :, and & without binding arguments.