Dynamic SQL definition, an xml node with root <xsql>
Dynamic SQL definition, an xml node with root <xsql>
As simple as an static SQL:
def xsql = "SELECT * FROM mytable WHERE id = #{{id}}"
Or using dynamic tags:
def xsql = <xsql> SELECT * FROM mytable <where> <if test="name != null"> name like #{{name}} </if> </where> <xsql>
Vendor ID
Vendor ID
This is a driver hint that will attempt to cause the driver to return results in batches of rows numbering in size equal to this setting.
This is a driver hint that will attempt to cause the driver to return results in batches of rows numbering in size equal to this setting. Default is unset (driver dependent).
Setting this to true will cause the cache to be flushed whenever this statement is called.
Setting this to true will cause the cache to be flushed whenever this statement is called. Default: false for select statements.
Fully qualified identifier of the statement.
Fully qualified identifier of the statement. Autogenerated by the configuration space.
Scripting driver
Scripting driver
Returns the Class of the input parameter.
Returns the Class of the input parameter.
A reference to an external resultMap.
A reference to an external resultMap. Result maps are the most powerful feature of MyBatis, and with a good understanding of them, many difficult mapping cases can be solved.
Any one of FORWARD_ONLY|SCROLL_SENSITIVE|SCROLL_INSENSITIVE.
Any one of FORWARD_ONLY|SCROLL_SENSITIVE|SCROLL_INSENSITIVE. Default FORWARD_ONLY.
Any one of STATEMENT, PREPARED or CALLABLE.
Any one of STATEMENT, PREPARED or CALLABLE. This causes MyBatis to use Statement, PreparedStatement or CallableStatement respectively. Default: PREPARED.
This sets the maximum time the driver will wait for the database to return from a request, before throwing an exception.
This sets the maximum time the driver will wait for the database to return from a request, before throwing an exception. Default is unset (driver dependent).
Setting this to true will cause the results of this statement to be cached.
Setting this to true will cause the results of this statement to be cached. Default: true for select statements.
Query for a Map of objects with RowBounds and one input parameter.
Details
This class defines a function: ((Param, RowBounds) => Map[ResultKey, ResultValue])
Sample code
input parameter type
map Key type
map Value type