http://www.tutorialspoint.com/mybatis/mybatis_
dynamic_sql.htm Copyright © tutorialspoint.com MYBATIS -
DYNAMIC SQL MYBATIS -
DYNAMIC SQL
Dynamic SQL is a very powerful feature of MyBatis. It enables to write the query using the
dynamic SQL. MyBatis uses a powerful
Dynamic SQL language that can be used within any mapped SQL statement. Following are the OGNL based
Dynamic SQL expressions provided by choose when, otherwise trim where, set foreach The if Statement The most common thing to do in
dynamic SQL is conditionally include a part of a where clause. For example −
MYBATIS Dynamic SQLhttp://www.tutorialspoint.com/mybatis/mybatis_dynamic_sql.htm Copyright © tutorialspoint.com MYBATIS - DYNAMIC SQL MYBATIS - DYNAMIC SQL Dynamic SQL is a very powerful feature of MyBatis. It enables to write the query using the dynamic SQL. MyBatis uses a powerful Dynamic SQL language that can be used within any mapped SQL statement. Following are the OGNL based Dynamic SQL expressions provided by choose when, otherwise trim where, set foreach The if Statement The most common thing to do in dynamic SQL is conditionally include a part of a where clause. For example −