问题一、Parameter Maps collection does not contain value for
Caused by: java.lang.IllegalArgumentException: Parameter Maps collection does not contain value for com.hman.water.model.RiverCollectorCgDataInfo
at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:888)
at org.apache.ibatis.session.Configuration.getParameterMap(Configuration.java:660)
at org.apache.ibatis.builder.MapperBuilderAssistant.getStatementParameterMap(MapperBuilderAssistant.java:318)
... 42 more
parameterMap用错了,我写的是
<select id="selectLateCollectCgDataByIp" parameterMap="com.hman.water.model.RiverCollectorCgDataInfo" resultMap="BaseResultMap">
SELECT
...
</select>
应该改成
<select id="selectLateCollectCgDataByIp" parameterType="com.hman.water.model.RiverCollectorCgDataInfo" resultMap="BaseResultMap">
SELECT
...
</select>
问题二、The content of elements must consist of well-formed character data or markup.
我这边是由于使用了“<、>”符号导致的
正确的使用方法应该是
<![CDATA[
SELECT
id, ip, cg_value, savetime
FROM
river_collector_cg_data_info
where ip = #{ip,jdbcType=NVARCHAR}
and savetime <= #{endTime,jdbcType=TIMESTAMP}
and savetime >= #{startTime,jdbcType=TIMESTAMP}
ORDER BY savetime desc
]]>
用下面的符号括起来
<![CDATA[
...
]]>