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 programmers 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 MyBatis 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 programmers 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 MyBatis 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 −