From 25d21a0dffb5a83fddcb6352bf0304a85b0186ec Mon Sep 17 00:00:00 2001 From: 18516761980 <tqsxp@163.com> Date: 星期六, 04 三月 2023 09:42:11 +0800 Subject: [PATCH] # --- src/main/resources/mapper/OrderMapper.xml | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/src/main/resources/mapper/OrderMapper.xml b/src/main/resources/mapper/OrderMapper.xml index 9e112d4..8bb394e 100644 --- a/src/main/resources/mapper/OrderMapper.xml +++ b/src/main/resources/mapper/OrderMapper.xml @@ -62,4 +62,13 @@ order by create_time asc </select> + <select id="selectorderNoL" resultMap="BaseResultMap"> + select top 10 * + from man_order + where 1=1 + <if test="orderNo != null"> + and order_no = #{orderNo} + </if> + </select> + </mapper> -- Gitblit v1.9.1