Ibatis 查询

Ibatis 查询

Map map = new HashMap();
   map.put("pathdylist", pathdylist);
   map.put("FORGID", forgid);

List<String> codes = getPathDyDAOImpl().queryPathdy(map);

sqlmap里这样写

<select id="queryPathdy" parameterClass="java.util.Map" resultClass="String">
       select t.pathcode from cp_base_pathdy t
       where t.pathcode in
       <iterate property="pathdylist" conjunction="," open="(" close=")">
                 #pathdylist[].PATHCODE#
    </iterate>
       and t.forgid = #FORGID#
  </select>