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}