Using OGNL expressions and operators in MyBatis

String vs. base data type _parameter

Custom Type (object) property name

Collection

Arrays Array

List List

Map _parameter

Get a piece of data from a collection

Array array[index] base data type array

array[index]. Property name Object data type array

List list[Index]

list[index]. Property name

Map _parameter.key

_parameter.key. Property name

Extracting data from a collection using the foreach tag (traversing the stitching SQL)

<foreach collection= "Array" index= "I" item= "item" separator= "," >

</foreach>

If the array or List,i in collection represents the subscript, if collection is Map,i represents key. Item (or item. Property name) represents the iterated value

Separator represents the delimiter between the iterated elements

Example

  <DeleteID= "Deletebatch"ParameterType= "Java.util.List">Delete from the MESSAGE where ID in (<foreachCollection= "List"Item= "Item"Separator=",">#{item}</foreach>      )  </Delete>

Operator

Java Common operators + 、-、 *,/, = =,! =, | |, && etc.

Unique operator and, or, mod, in, not in

Using OGNL expressions and operators in MyBatis