search

Home  >  Article  >  Database  >  mybatis查询mysql的时间段

mybatis查询mysql的时间段

WBOY
WBOYOriginal
2016-06-07 15:58:302653browse

mapper文件的写法为：（模糊查询，查询时间段） if test=com_name!=null and com_name!=and sc.com_name like CONCAT(CONCAT(%,#{com_name}),%)/ifif test=check_begin_date!=null and check_begin_date!=![CDATA[ and DATE_FORMAT(tcb.check_begin_date, %Y

mapper文件的写法为：（模糊查询，查询时间段）

                <if test="com_name!=null and com_name!=&#39;&#39;">
			and sc.com_name like CONCAT(CONCAT(&#39;%&#39;,#{com_name}),&#39;%&#39;)
		</if>
		<if test="check_begin_date!=null and check_begin_date!=&#39;&#39;">
		<![CDATA[
			  and DATE_FORMAT(tcb.check_begin_date, &#39;%Y-%m-%d&#39;) >=  DATE_FORMAT(#{check_begin_date}, &#39;%Y-%m-%d&#39;)
		]]>
		</if>
		<if test="check_end_date!=null and check_end_date!=&#39;&#39;">
		<![CDATA[
			  and DATE_FORMAT(tcb.check_begin_date, &#39;%Y-%m-%d&#39;) <=  DATE_FORMAT(#{check_end_date}, &#39;%Y-%m-%d&#39;)
		]]>
		</if>
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：【翻译自mos文章】11gR2中的asm后台进程Next article：【翻译自mos文章】asmcmdcp命令不能拷贝大于2GB的文件。

Related articles

See more