在DeptMapper.java中写入
<select id="zidingyimingzi" resultType="dept">//id名自定义
select deptno,dname,loc,ziduanming
where deptn in
<foreach collection="myMap.values" item="mingzisuibianqi" open="(" close=")" separator=","></foreach>
#{deptno}
</select>
在DeptMapper.java做接口的绑定
public List zidingyimingzi(@param("myMap")Map map);//使用注解告诉MyBati框架当前SQL语句中的名字，即myMap=map
测试类
public void test(){
DeptMapper dao = session.getMapper(Deptmapper.class);
Map map = new HashMap();
map.put("key1",41);
map.put("key2",42);
List<Dept> deptList= dao.zidingyimingzi(map);
}
!!!map比list更加的灵活;;;