<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.mybatis.mapper.UserMapper"><selectid="queryNamesByIds"resultType="java.lang.String">
SELECT
name
from user
WHERE id in
<foreachcollection="userIds"item="id"open="("close=")"separator=",">
#{id}
</foreach></select></mapper>