<span style="font-size:14px;"><select id="findIncentivefee" resultType="Incentivefee" parameterType="map">
select
contractcode,
devname,
city,
projectname,
sendloandate,
sendmoneysum
from T_ACCT_INCENTIVEFEE where 1=1
<if test="startTime!=null">
and <![CDATA[sendloandate>=to_date(#{startTime}, 'yyyy-mm-dd') ]]>
</if>
<if test="endTime!=null">
and <![CDATA[sendloandate<=to_date(#{endTime}, 'yyyy-mm-dd') ]]>
</if>
</select></span>
从页面获取参数个数和值,存放到hashmap中,传到sqlmap.xml文件中, 再进行日期转换.
mybatis查询日期范围的记录数
最新推荐文章于 2024-05-27 15:37:03 发布