mybatis拼接查询条件

最新推荐文章于 2023-12-22 15:11:33 发布

shjniu3000

最新推荐文章于 2023-12-22 15:11:33 发布

阅读量3.2k

点赞数 1

分类专栏： web后端文章标签： mybatis 条件分割

本文链接：https://blog.csdn.net/shjniu3000/article/details/51957216

版权

web后端专栏收录该内容

10 篇文章 0 订阅

订阅专栏

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="mapper.AlarmMapper" >
	 <resultMap id="AlarmResultMap" type="vo.AlarmRs" >
		<result column="alarm_id" property="alarm_id" jdbcType="INTEGER" />
		<result column="alarm_level" property="alarm_level" jdbcType="INTEGER" />
		<result column="alarm_flag" property="alarm_flag" jdbcType="INTEGER" />
		<result column="alarm_time" property="alarm_time" jdbcType="TIMESTAMP" />
		<result column="alarm_desc" property="alarm_desc" jdbcType="VARCHAR" />
	</resultMap>
	
	<sql id="Base_Column_List" >
                alarm_id, alarm_level, alarm_flag, alarm_time, alarm_desc 
  	</sql>
  	
  	<sql id="tableNameSql">
		jy_alarm
	</sql>
	
	<sql id="varSql2">
		<where>
			<trim suffixOverrides="and">
			  	<if test="startDate != null and startDate !=''" >
			     DATE(alarm_time) &gt;= #{startDate,jdbcType=VARCHAR} and 
			    </if>
			    <if test="endDate != null and endDate !=''" >
			     DATE(alarm_time) &lt;= #{endDate,jdbcType=VARCHAR} and 
			    </if>
			    <if test="level !=3" >
			     alarm_level = #{level,jdbcType=INTEGER} and 
			    </if>
			</trim>
		</where>
	</sql>
	
	<select id="getAlarmRs" resultMap="AlarmResultMap" parameterType="vo.AlarmCondition">
		select 
		<include refid="Base_Column_List" />
		from 
		<include refid="tableNameSql" /> 
		<include refid="varSql2" /> 
		ORDER BY alarm_time DESC 
	</select>
	
	<select id="getAlarmRsFirst" resultMap="AlarmResultMap" parameterType="vo.AlarmCondition">
		select alarm_id, alarm_level, alarm_flag, alarm_time, alarm_desc from jy_alarm 
		where DATE(alarm_time) = #{toDay,jdbcType=VARCHAR} ORDER BY alarm_time DESC
	</select>
	
</mapper>