<select id="getselectedcommondityinfos" parameterClass="map" resultClass="map">
  SELECT  *
        FROM commondity_info c
        WHERE comstate_id != 4 
         <isNotNull property="comIds" prepend=" and com_id in ">   
          <iterate property="comIds" conjunction="," close=")" open="(">   
              #comIds[]#   
          </iterate>   
     </isNotNull>
  </select>

在执行的时候报错:

Cause: java.lang.RuntimeException: JavaBeansDataExchange could not instantiate result class.  Cause: java.lang.InstantiationException: java.util.Map; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:

注意:Map作为resultClass時,必須指定具体的实现类,比如java.util.HashMap,否则会报错

Caused by: java.lang.RuntimeException: JavaBeansDataExchange could not instantiate result class.  Cause: java.lang.InstantiationException: java.util.Map

解决办法:

<select id="getselectedcommondityinfos" parameterClass="map" resultClass="java.util.HashMap">
  SELECT  *
        FROM commondity_info c
        WHERE comstate_id != 4 
         <isNotNull property="comIds" prepend=" and com_id in ">   
          <iterate property="comIds" conjunction="," close=")" open="(">   
              #comIds[]#   
          </iterate>   
     </isNotNull>
  </select>