varchar字段作为查询条件时，Mapper.xml文件中不应加‘’

liurunyu

2023-11-27 6c0fea3c86ca0398d918984fcbbdf1234c052be4

varchar字段作为查询条件时，Mapper.xml文件中不应加‘’

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaClientMapper.xml

@@ -71,10 +71,10 @@
                bc.name like concat('%', #{name}, '%') and
            </if>
            <if test="num != null">
                bc.num = '#{num,jdbcType=VARCHAR}' and
                bc.num = #{num,jdbcType=VARCHAR} and
            </if>
            <if test="phone != null">
                bc.phone = '#{phone,jdbcType=VARCHAR}' and
                bc.phone = #{phone,jdbcType=VARCHAR} and
            </if>
        </trim>
    </select>
@@ -107,10 +107,10 @@
                bc.name like concat('%', #{name}, '%') and
            </if>
            <if test="num != null">
                bc.num = '#{num,jdbcType=VARCHAR}' and
                bc.num = #{num,jdbcType=VARCHAR} and
            </if>
            <if test="phone != null">
                bc.phone = '#{phone,jdbcType=VARCHAR}' and
                bc.phone = #{phone,jdbcType=VARCHAR} and
            </if>
        </trim>
        order by bc.id DESC

 pipIrr-platform/pipIrr-global/src/main/resources/mapper/BaUserMapper.xml

@@ -67,7 +67,7 @@
                name like concat('%', #{name}, '%') and
            </if>
            <if test="phone != null">
                phone = '#{phone,jdbcType=VARCHAR}'
                phone = #{phone,jdbcType=VARCHAR}
            </if>
        </trim>
    </select>
@@ -80,7 +80,7 @@
                name like concat('%', #{name}, '%') and
            </if>
            <if test="phone != null">
                phone = '#{phone,jdbcType=VARCHAR}'
                phone = #{phone,jdbcType=VARCHAR}
            </if>
        </trim>
        order by id DESC