Mybatis实现条件查询

最新推荐文章于 2024-09-18 17:04:07 发布

lenghanbing

最新推荐文章于 2024-09-18 17:04:07 发布

阅读量313

点赞数

分类专栏： Mybatis 文章标签： java

本文链接：https://blog.csdn.net/lenghanbing/article/details/84251759

版权

Mybatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

javaBean对应的映射文件方法

<select id="getAllHistoryInfo" resultType="hashmap"
		parameterType="historyAlarm">
		<![CDATA[
		     select 
		    	history.*,alarmConfig.alarmZhName,alarmConfig.alarmEnName,alarmConfig.alarmType as almType 
		    from 
		    	historyAlarmInfo history
		    	left JOIN  AlarmInfoConfig alarmConfig on history.alarmID=alarmConfig.alarmID
		    where 1=1
	    ]]>
		<if test="hnbID != null and '' != hnbID">
			<![CDATA[
			  AND history.hnbID = #{hnbID}
			]]>
		</if>

		<if test="alarmID != null and '' != alarmID">
			<![CDATA[
			  AND history.alarmID = #{alarmID}
			]]>
		</if>

		<if test="alarmType != null and '' != alarmType">
			<![CDATA[
			  AND alarmConfig.alarmType = #{alarmType}
			]]>
		</if>

		<if test="perceivedSeverity != null and '' != perceivedSeverity">
			<![CDATA[
			  AND history.perceivedSeverity = #{perceivedSeverity}
			]]>
		</if>

		<if test="probableCause != null and '' != probableCause">
			<![CDATA[
			  AND history.probableCause like '%' #{probableCause} '%'
			]]>
		</if>

		<if test="startAlarmRaisedTime != null and '' != startAlarmRaisedTime">
			<![CDATA[
			  AND history.alarmRaisedTime >= #{startAlarmRaisedTime}
			]]>
		</if>

		<if test="endAlarmRaisedTime != null and '' != endAlarmRaisedTime">
			<![CDATA[
			  AND history.alarmRaisedTime <= #{endAlarmRaisedTime}
			]]>
		</if>

		<if test="clearedManner != null">
			<![CDATA[
			  AND history.clearedManner = #{clearedManner}
			]]>
		</if>
	</select>

parameterType="historyAlarm"：表示又业务层传进来的参数，该参数是MyBatis映射配置文件的映射对象。