mybatis模糊查询

最新推荐文章于 2022-06-13 14:11:41 发布

javaee_jsp

最新推荐文章于 2022-06-13 14:11:41 发布

阅读量157

点赞数

分类专栏： mybatis 文章标签：数据库 java

本文链接：https://blog.csdn.net/javaee_jsp/article/details/84159932

版权

mybatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

	<select id="searchRoutes" parameterType="com.xaeds.taecs.domain.xlzx.TouristRoute"
		resultMap="BaseResultMapExt">
		select
		<include refid="Base_Column_List_Ext" />
		from "t_tourist_route" tr
		<where>
			<if test="departureDate!=null">
				<if test="returnDate!=null">
					and tr.departure_date BETWEEN #{departureDate,jdbcType=DATE} AND
					#{returnDate,jdbcType=DATE}
			</if>
			</if>
			<if test="routeName!=null">
				and tr.route_name like '%'||#{routeName,jdbcType=VARCHAR}||'%'
		</if>
			<if test="routeNumber!=null">
				and tr.route_number like '%'||#{routeNumber,jdbcType=VARCHAR}||'%'
		</if>
			<if test="publisherId!=null">
				and tr.publisher_id = #{publisherId,jdbcType=INTEGER}
		</if>
		</where>
	</select>