org.apache.ibatis.binding.BindingException: Mapper method 'com... has an unsupported return type

场景：

service中间调用dao层方法时，出现以下错误，但是sql执行修改数据成功，并没有回滚问题：

十月 31, 2017 2:53:39 下午 org.apache.catalina.core.StandardWrapperValve invoke严重: Servlet.service() for servlet [bigaoread] in context with path [] threw exception [Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Mapper method 'com.bigaoread.platform.dao.beautifulreader.v2.YzActivecontrolMapper.updateActiveId' has an unsupported return type: class com.bigaoread.platform.model.beautifulreader.v2.YzActivecontrol] with root causeorg.apache.ibatis.binding.BindingException: Mapper method 'com.bigaoread.platform.dao.beautifulreader.v2.YzActivecontrolMapper.updateActiveId' has an unsupported return type: class com.bigaoread.platform.model.beautifulreader.v2.YzActivecontrolat org.apache.ibatis.binding.MapperMethod.rowCountResult(MapperMethod.java:91)at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:54)at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)at com.sun.proxy.$Proxy41.updateActiveId(Unknown Source)

原因：这个是因为dao层的sql执行成功后，返回的类型出现问题。

代码：

service层：

public Map<String, Object> updateActiveId(String newActiveId, String oldActiveId) {Map<String, Object> resultMap = new HashMap<>();if(subscribeQrcodeService.isExistActiveId(Long.parseLong(newActiveId))) {resultMap.put("status", 1);return resultMap;}if(!(null == this.get(Long.parseLong(newActiveId)))) {resultMap.put("status", 1);return resultMap;}Map<String, Object> updateIdMap = new HashMap<>();updateIdMap.put("newActiveId", Long.parseLong(newActiveId));updateIdMap.put("oldActiveId", Long.parseLong(oldActiveId));yzActivecontrolMapper.updateActiveId(updateIdMap);resultMap.put("status", 0);return resultMap;}

dao层：

YzActivecontrol updateActiveId(Map<String, Object> updateIdMap);

mapper.xml：

    <update id="updateActiveId" parameterType="Map">    UPDATE <include refid="tableName"/>    SET id = #{newActiveId}    WHERE id = #{oldActiveId}    </update>

解决：

mapper文件中的update,delete,insert语句是不需要设置返回类型的，它们都是默认返回一个int，所以应该修改dao层接口的方法：

Integer updateActiveId(Map<String, Object> updateIdMap);

或者

void updateActiveId(Map<String, Object> updateIdMap);