后端-框架-MyBatis-动态SQL-choose

最新推荐文章于 2022-10-23 09:02:22 发布

CaediosViolet

最新推荐文章于 2022-10-23 09:02:22 发布

阅读量144

点赞数

分类专栏：后端框架 MyBatis 文章标签：后端框架 MyBatis 动态SQL choose

本文链接：https://blog.csdn.net/qq_40925226/article/details/83418760

版权

后端同时被 3 个专栏收录

29 篇文章 0 订阅

订阅专栏

框架

29 篇文章 0 订阅

订阅专栏

MyBatis

9 篇文章 0 订阅

订阅专栏

后端-框架-MyBatis-动态SQL-choose

public interface UserMapper{
	public List<User> getUserListByChoose(@Param("userName")String userName,
											@Param("userRole")Integer roleId,
											@Param("gender")Integer gender,
											@Param("creationDate")Date creationDate);
}

choose本质上等于switch

<select id="getUserListByChoose" resultMap="getUserListByChoose">
	 	select * from smbms_user as user where 1 = 1
	 		<choose>
	 			<when test="userName!=null and userName!=''">
	 				and user.userName like Concat('%',#{userName},'%')
	 			</when>
	 			<when test="userRole!=null">
	 				and user.userRole = #{userRole}
	 			</when>
	 			<when test="gender!=null">
	 				and user.gender = #{gender}
	 			</when>
	 			<otherwise>
	 				and YEAR(user.creationDate) = YEAR(#{creationDate})
	 			</otherwise>
	 		</choose>
	 </select>