Mybatis dynamic query

In my project, I ran into the issue that I have to use Sql In statement and the value in the in() is dynamic. With mybatis, we can create dynamic sql foreach.

Here is my case:

1. In the mapper class, I define my method:

@Component("twitterTweetMapper")public interface TweetMapper{public List<Tweet> getTweetsByOrganizationIds(List<Long> organizationIds);}

2. In the mapper.xml file, I define my sql statement.

<select id="getTweetsByOrganizationIds" resultType="org.twitter.model.Tweet">SELECT * FROM TWEETWHERE ORGANIZATIONID in<foreach item="item" index="index" collection="list" open="(" separator="," close=")">#{item}</foreach>ORDER BY TWEETCREATEDATE DESC LIMIT 3</select>

That's all. It's very easy, right?

For more dynamic queries, read the link:

http://loianegroner.com/2011/03/ibatis-mybatis-working-with-dynamic-queries-sql/