1,查询数据记录(查询表中某字段integral所在的数据小于传来的参数consumintegral的所有记录)
<select id="myshops4" parameterClass="int" resultMap="exchangemap">
<![CDATA[
select * from exchange_goods where integral < #consumeIntegral# order by addtime desc limit 4
]]>
</select>
参考文档:http://yjhexy.iteye.com/blog/465150