Mybatis实现条件查询

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映射配置文件的映射对象。

 

 

 

 

评论

2 楼 牧佑叔叔 2016-12-21  

[size=small][/size]u;8i

1 楼 牧佑叔叔 2016-12-21