Using Dynamic SQL - iBATIS in Action - page 185

try {
Connection conn =
ConnectionPool.getConnection("MyConnectionPool");
PreparedStatement ps = null;
ResultSet rs = null;

Gets JDBC
resources

List valueList = new ArrayList();

StringBuffer sql = new StringBuffer("");
sql.append("SELECT * ");
sql.append("FROM Category ");
if(categorySearchCriteria.getCategoryIds() != null
&& categorySearchCriteria.getCategoryIds().size() > 0) {
Iterator categoryIdIt =
categorySearchCriteria.getCategoryIds().iterator();
sql.append("WHERE ");
sql.append("categoryId IN (");
if(categoryIdIt.hasNext()) {
Object value = categoryIdIt.next();
valueList.add(value);
sql.append("?");
}
while(categoryIdIt.hasNext()) {
Object value = categoryIdIt.next();
valueList.add(value);
sql.append(",?");
}
sql.append(") ");
}
if(categorySearchCriteria.getFirstLetter() != null
&&
!categorySearchCriteria.getFirstLetter().trim().equals(""))
{
if(valueList.size() != 0) {
sql.append("AND ");
}
sql.append("name LIKE (?)");
valueList.add(categorySearchCriteria.getFirstLetter()
+ "%");

Starts building
SQL query

Starts building
dynamic part

Don't forget
the AND!