mybatis只传一个参数的时候

流水记录查询SQL

最新推荐文章于 2021-05-15 20:30:50 发布

原创最新推荐文章于 2021-05-15 20:30:50 发布 · 3.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis

mybatis 专栏收录该内容

1 篇文章

订阅专栏

	<select id="commissionRecordList" resultType="com.enjoylife.system.domain.FlowingWaterDO">
		SELECT m.member_phone,m.member_name,f.*
		FROM flowing_water f
		LEFT JOIN member_manager m ON m.id = f.user_id
		<where>
			flowing_water_status in (5,6)
			<if test="_parameter != null and _parameter != ''">and f.order_id  = #{_parameter,jdbcType=VARCHAR}</if>
		</where>
		ORDER BY create_time DESC
	</select>