<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>
mybatis只传一个参数的时候
最新推荐文章于 2024-06-15 22:22:43 发布