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