mybatis传入数组查询
List<Dept> getDeptsByCompanyIds(@Param("companyIds") String[] companyIds);
<select id="getDeptsByCompanyIds" resultMap="Dept">
select * from t_dept where COMPANY_ID in
<foreach collection="companyIds" item="id" open="(" close=")" separator=",">
#{id}
</foreach>
</select>