mybatis

mapper中的接口参数为map类型

Map map = new HashMap();
map.put("state", 1);                //1启用
map.put("ids", ids);

<update id="updateState" parameterType="map">
        update factory_c set state=#{state}
        where FACTORY_ID in
        <foreach collection="ids" item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
</update>

mapper中的接口参数为数组类型

<delete id="delete" parameterType="string">
        delete from factory_c
        where FACTORY_ID in
        <foreach collection="array" item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
</delete>