<select id="goodsList" parameterType="goods" resultMap="goodsResult">
select * from ssm_goods
<where>
<if test="text_find != null and text_find != ''">
goods_name like concat(concat('%',#{text_find}),'%')
or
goods_price like concat(concat('%',#{text_find}),'%')
or
goods_place like concat(concat('%',#{text_find}),'%')
or
goods_pack like concat(concat('%',#{text_find}),'%')
or
goods_evaluate like concat(concat('%',#{text_find}),'%')
</if>
</where>
</select>
mybatis中模糊查询的sql语句
最新推荐文章于 2022-12-20 15:34:25 发布