mybatis xml书写In list

In MyBatis, you can use the <foreach> tag to iterate over a list in the XML configuration file. Here is an example:

<select id="getUsersByIds" resultType="User">
  SELECT * FROM users WHERE id IN
  <foreach item="item" collection="ids" open="(" separator="," close=")">
    #{item}
  </foreach>
</select>

In this example, we have a <select> statement that retrieves users based on their IDs. The ids parameter is a list of IDs that we want to filter on. The <foreach> tag loops over the ids list and generates the necessary SQL syntax for the IN clause.

The attributes of the <foreach> tag are as follows:

• collection: The name of the parameter that contains the list.
• item: The name of the variable to represent each item in the list.
• open: The string to be included before the first item.
• separator: The string to be included between each item.
• close: The string to be included after the last item.

Inside the <foreach> tag, you can reference the current item using #{item}.

Note that the resultType attribute is set to User, which specifies the type of the result. You can change it to the appropriate type for your scenario.

This is just one example of how to use the <foreach> tag in MyBatis XML configuration. You can also use it for other scenarios where you need to iterate over a list in your SQL queries