iBATIS in Action

Chapter 8. Using Dynamic SQL

This chapter covers

• Introduction to Dynamic SQL
• Simple Dynamic SQL example
• Advanced Dynamic SQL
• Future directions

In chapter 4 we discussed how to write simple static SQL. Static SQL only requires that values be assigned via the property (#...#) or literal ($...$) syntax. Although most of the SQL you will write in iBATIS will likely be static, there are several occasions where it will not remain that simple. For example, you will quickly run into more involved scenarios where you need to iterate over a list of values for an IN statement, provide users with the ability to determine which columns will be displayed, or simply have a changing WHERE criterion based on your parameter object’s state. iBATIS provides ...