From 85ce0fa8006e3290447ae0e78783b353f7a3e8f6 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期五, 17 十一月 2023 10:05:47 +0800
Subject: [PATCH] 查询条件中like语法错误修改
---
pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientTypeMapper.xml | 2 +-
pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientMapper.xml | 4 ++--
pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml | 6 +++---
3 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml
index b836678..0fee717 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaBlockMapper.xml
@@ -40,10 +40,10 @@
from ba_block
<trim prefix="where " suffixOverrides="and">
<if test="name != null">
- name like '%#{name,jdbcType=VARCHAR}%' and
+ name like concat('%', #{name}, '%') and
</if>
<if test="header != null">
- header = '#{header,jdbcType=VARCHAR}' and
+ header like concat('%', #{header}, '%') and
</if>
<if test="phone != null">
phone = '#{phone,jdbcType=VARCHAR}' and
@@ -60,7 +60,7 @@
from ba_block
<trim prefix="where " suffixOverrides="and">
<if test="name != null">
- name like '%#{name,jdbcType=VARCHAR}%' and
+ name like concat('%', #{name}, '%') and
</if>
<if test="header != null">
header = '#{header,jdbcType=VARCHAR}' and
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientMapper.xml
index be5f478..0a73af3 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientMapper.xml
@@ -65,7 +65,7 @@
blockId = #{blockId,jdbcType=BIGINT} and
</if>
<if test="name != null">
- name like '%#{name,jdbcType=VARCHAR}%' and
+ name like concat('%', #{name}, '%') and
</if>
<if test="num != null">
num = '#{num,jdbcType=VARCHAR}' and
@@ -95,7 +95,7 @@
blockId = #{blockId,jdbcType=BIGINT} and
</if>
<if test="name != null">
- name like '%#{name,jdbcType=VARCHAR}%' and
+ name like concat('%', #{name}, '%') and
</if>
<if test="num != null">
num = '#{num,jdbcType=VARCHAR}' and
diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientTypeMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientTypeMapper.xml
index fbc1eb5..356fafe 100644
--- a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientTypeMapper.xml
+++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientTypeMapper.xml
@@ -38,7 +38,7 @@
from ba_client_type
<trim prefix="where" suffixOverrides="and">
<if test="name != null">
- name like concat('%', #{name}, '%')
+ name like concat('%', #{name}, '%') and
</if>
</trim>
</select>
--
Gitblit v1.8.0