List<Emp> findEmpByDeptnos(List<Integer> deptnos);

<select id="findEmpByDeptnos" resultType="Emp" parameterType="list">
? ? SELECT * FROM emp e
? ? WHERE e.deptno IN
? ? <foreach collection="list" item="deptno" open="(" separator="," close=")">
? ? ? ? #{deptno}
? ? </foreach>
</select>

List<Emp> findEmpByDeptnos(Integer[] deptnos);

<select id="findEmpByDeptnos" resultType="Emp" parameterType="int">
? ? SELECT * FROM emp e
? ? WHERE e.deptno IN
? ? <foreach collection="array" item="deptno" open="(" separator="," close=")">
? ? ? ? #{deptno}
? ? </foreach>
</select>

List<Emp> findEmpByDeptnos(Map<String,List<Integer>> deptnos);

<select id="findEmpByDeptnos" resultType="Emp" parameterType="map">
? ? SELECT * FROM emp e
? ? WHERE e.deptno IN
? ? <foreach collection="myKey" item="deptno" open="(" separator="," close=")">
? ? ? ? #{deptno}
? ? </foreach>
</select>

public class GeneralAddressQueryParam implements Serializable {

? ? /**
? ? ?* 地名，多級(jí)地名用逗號(hào)分隔
? ? ?*/
? ? private String names;

? ? /**
? ? ?* 多地名查詢條件
? ? ?*/
? ? private List<String> nameList;

? ? public String getNames() {
? ? ? ? return names;
? ? }

? ? public void setNames(String names) {
? ? ? ? this.names = names;
? ? }

? ? public List<String> getNameList() {
? ? ? ? return nameList;
? ? }

? ? public void setNameList(List<String> nameList) {
? ? ? ? this.nameList = nameList;
? ? }
}

List<GeneralAddressFullNameDTO> multiNameQuery(GeneralAddressQueryParam queryParam);

<if test="nameList != null and nameList.size() > 0">
? ? <foreach collection="nameList" item="name">
? ? ?? ?and address like concat('%', #{name}, '%')
? ? </foreach>
</if>

<if test="nameList != null and nameList.size() > 0">
? ? <foreach collection="nameList" item="name" index="index">
? ? ?? ?and address like concat('%', #{nameList[${index}]}, '%')
? ? </foreach>
</if>