Small fuzzy query, unexpectedly modified the code three times back and forth? Find an electronics factory

First , The architecture is springboot+mybatis
Fuzzy query name 、 cell-phone number , Is it simple

for the first time ：

java

 String name =MapUtils.getString(param,"name");
 String telNumber =MapUtils.getString(param,"telNumber");

 if(StringUtil.isEmpty(name) && StringUtil.isEmpty(telNumber)){
    throw new xxxException(Err.Check," Name and mobile number cannot be empty ！");
}

mybatis xml

<if test="name != null and name != '' ">
     and s.name like concat('%', #{name,jdbcType=VARCHAR}, '%')
</if>
<if test="telNumber != null and telNumber != '' ">
     and s.tele_number like concat('%', #{telNumber,jdbcType=VARCHAR}, '%')
</if>

Happily submitted ...

The ginseng ：

{
 "name":"1",
"telNumber":"1"
}

The second time ：

Front end theory , The name and mobile phone number should be put in a field and transmitted

Change it

<if test="keyWord != null and keyWord != '' ">
              and (name like concat('%', #{keyWord,jdbcType=VARCHAR}, '%')
                or s.tele_number like concat('%', #{keyWord,jdbcType=VARCHAR}, '%')
      )
</if>

The ginseng ：

{
"keyWord":"1"
}

It feels perfect .. Submit ！！！

third time ：

Too young. , Front end theory ：“ Pass a number 1 You can find tens of thousands of data , The front page crashed , Add a limit ”

<if test="keyWord != null and keyWord != '' ">
              and (name like concat('%', #{keyWord,jdbcType=VARCHAR}, '%')
                or s.tele_number like concat('%', #{keyWord,jdbcType=VARCHAR}, '%')
      )
</if>
<if test="limitNum != null and limitNum != '' ">
     limit #{limitNum}
 </if>

Because it's a fuzzy search with pop-up boxes , No need to paginate , You don't need to show all the data , So add a limit Just fine

Pass on ：

{
"keyWord":"1",
"limitNum":"100"
}

We finally got it , Front end theory ：“ All right ”