O'Reilly logo

iBatis in Action by Larry Meadors, Brandon Goodin, Clinton Begin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required