1.没有在configuration.xml配置对应的sql配置文件
错误:
Error updating database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for ***Mapper.*** Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value
for ***Mapper.***
<mappers>
<mapper resource="esd/db/mapper/ResumeMapper.xml" />
</mappers>
解决方法:
在configuration.xml配置文件中引用对应的sql配置文件
2.同一sql配置文件中id重复
错误:
Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.RuntimeException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for GeographyMapper.getByCode
两个sql语句的id重复了,就会报这个错.
<select id="getByMeeting" resultType="BaseResultMap"
parameterType="java.lang.String">
select * from Meeting where code = ${code}
</select>
<select id="getByMeeting" resultType="BaseResultMap"
parameterType="java.lang.String">
select * from Meeting where fullName = ${fullName}
</select>
解决方法:
修改其中的一个id就ok了.
3. mybatis中:大于丶小于丶等于丶&&等替换符
原符号: < <= > >= & ' "
替换符号: < <= > >= & ' "
例:sql语句如下
<if test="deMeetingStart != null && deMeetingOver != null">
create_time >= #{deMeetingStart} and create_time <= #{deMeetingOver }
</if>