Mybatis常见错误

同一sql映射文件中id重复

Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.jianglei.mapper.UserMapper.selectByIds

两个sql语句的id重复了，就会报这个错

       <!-- 按code码得到一个对象-->  
<select id="getByCode" resultType="Geography"  
    parameterType="java.lang.String">  
    select * from Geography where code = ${code}  
</select>  

<!-- 按地名getByName得到一个对象-->  
<select id="getByCode" resultType="Geography"  
    parameterType="java.lang.String">  
    select * from Geography where fullName = ${fullName}  
</select>