oracle中的模糊查询

like '%测试%'--

% 匹配0或多个字符
_ 匹配1个字符

Mybatis中的模糊匹配

||

shop.SHOP_NAME LIKE '%' || #{shopName}|| '%'

concat()拼接

shop.SHOP_NAME LIKE CONCAT(CONCAT('%',#{shopName},'%'))

放在程序里–估计用不上

String contiditon = new StringBuilder("%").append(cardcoupons.getShopName).append("%");
parameterMap.put("condition",condition);

放在参数里

cardcoupons.setShopName("%shopName%");
shop.SHOP_NAME LIKE #{shopName}