<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>