【MyBatis】动态SQL

动态SQL

• <if>标签
• <choose>、<when>、<otherwise>标签
• <where>、<set>标签
• <foreach>标签

<if>标签

<select id="findActiveBlogLike" resultType="Blog">
	SELECT * FROM BLOG WHERE state = ‘ACTIVE’
	<if test="title != null">
		AND title like #{title}
	</if>
	<if test="author != null and author.name != null">
		AND author_name like #{author.name}
	</if>
</select>

---

<choose>、<when>、<otherwise>标签

<select id="findActiveBlogLike" resultType="Blog">
	SELECT * FROM BLOG WHERE state = ‘ACTIVE’
	<choose>
		<when test="title != null">
			AND title like #{title}
		</when>
		<when test="author != null and author.name != null">
			AND author_name like #{author.name}
		</when>
		<otherwise>
			AND featured = 1
		</otherwise>
	</choose>
</select>

---

<where>、<set>标签

<select id="findActiveBlogLike" resultType="Blog">
	SELECT * FROM BLOG
	<where>
		<if test="state != null">
			state = #{state}
		</if>
		<if test="title != null">
			AND title like #{title}
		</if>
		<if test="author != null and author.name != null">
			AND author_name like #{author.name}
		</if>
	</where>
</select>

<update id="updateAuthorIfNecessary">
	UPDATE Author
	<set>
		<if test="username != null">
			username=#{username},
		</if>
		<if test="password != null">
			password=#{password},
		</if>
		<if test="email != null">
			email=#{email},
		</if>
		<if test="bio != null">
			bio=#{bio}
		</if>
    </set>
	WHERE id=#{id}
</update>

---

<foreach>标签

<select id="selectPostIn" resultType="domain.blog.Post">
	SELECT *
	FROM POST P
	WHERE ID in
	<foreach collection="list" item="item" index="index" open="(" separator="," close=")">
		#{item}
	</foreach>
</select>

---

我寻见一片海 碧蓝且耀着光

大片船只航行其上 都向着远方

                         Shared by Foriver_江河

© 1997-8023 江河 All Rights Reserved.