mysql查询处理转义关键字

mysql查询处理转义关键字

/**
     * mysql查询处理转义关键字
     * @param keyword
     * @return
     */
    public static String escapeSpecialChar(String keyword){
        if (org.apache.commons.lang.StringUtils.isNotBlank(keyword)) {
            String[] fbsArr = { "\\", "$", "|","%","_" , "(", ")", "*", "+", ".", "[", "]", "?", "^", "{", "}"};
            for (String key : fbsArr) {
                if (keyword.contains(key)) {
                    keyword = keyword.replace(key, "\\" + key);
                }
            }
        }

        return keyword;
    }