Mybatis ‘%’ ‘_’模糊查询处理

1. mapper.xml 增加ESCAPE '/'

比如

and oper_name like CONCAT('%',#{operName},'%') ESCAPE '/'

2. 对应字符串处理

import org.apache.commons.lang3.StringUtils;

/**
 * @author zhangyuhang
 */
public class EscapeUtil {
    /**
     * mysql的模糊查询时特殊字符转义
     */
    public static String escapeChar(String before){
        if(StringUtils.isNotBlank(before)){
            before = before.replaceAll("_", "/_");
            before = before.replaceAll("%", "/%");
        }
        return before.trim() ;
    }
}