Check Non-Empty List in MyBatis

1 year ago
Olivia Parker
1 minute

In MyBatis, you can determine if a List is not empty using dynamic SQL. Here is a simple example:

<select id="selectByList" parameterType="java.util.List" resultType="YourResultType">
    SELECT * FROM your_table
    WHERE id IN
    <foreach collection="list" item="item" open="(" close=")" separator=",">
        #{item}
    </foreach>
</select>

In this example, we are utilizing the foreach tag to iterate through the incoming List. If the List is not empty, a query operation will be executed. If the List is empty, no operation will be performed. This way, we achieve the functionality of checking if the List is not empty.

bannerAds