mybatis 传入不同类型参数

1.传入数组【jsonArray】

dao：
List<User> query(@Param("insIdArray") JsonArray insIdArray);

xml:
<select id="query" resultType="com.ruyi.entity.User">
    select id,name,user_id from user 
    <where>
        <if test = "insIdArray != null and insIdArray.size() > 0">
            id in
                <foreach collection = "insIdArray" open = "(" close = ")" separator = "," item = "institutionId">
                    #{institutionId}
                </foreach>
        </if>
    </where>
</select>

2.传入集合【List】【参考：https://blog.csdn.net/weixin_38137028/article/details/88245042】

dao：
Integer<User> insertUser(@Param("list") List list);

xml:
<insert id="insertUser" paramterType = "java.util.List">
    insert into user
        (skip_id,user_id)
    values
        <foreach collection = "list" item = "user" index = "index" separator = ",">
            (#{user.skipId},#{user.userId})
        </foreach>
</insert>