1 特殊字符转义—SQL模糊查询字段

  1. package com.orange.utils;
  3. import org.apache.commons.lang3.StringUtils;
  5. import java.util.Arrays;
  6. import java.util.HashMap;
  7. import java.util.List;
  8. import java.util.Map;
  9. import java.util.stream.Collectors;
  11. /**
  12.  * 字符串工具类  用于模糊查询
  13.  */
  14. public class StrUtil extends StringUtils {
  16.     private static final Map<String,String> keyMap;
  18.     /**
  19.      * key --原字符
  20.      * value -- 替换后字符
  21.      */
  22.     static {
  23.         keyMap = new HashMap<>();
  24.         keyMap.put("%","/%");
  25.         keyMap.put("_","/_");
  26.         keyMap.put("&","/&");
  27.         keyMap.put("'","/'");
  28.         keyMap.put(">","/%");
  29.         keyMap.put("<","/%");
  30.         keyMap.put("and","/");
  31.         keyMap.put("or","/");
  32.     }
  34.     /**
  35.      * 特俗字符转义--SQL模糊查询字段
  36.      * @param keyWord
  37.      * @return
  38.      */
  39.     public static String escapeExprSpecialWord(String keyWord){
  41.         if(StringUtils.isBlank(keyWord)){
  42.             return "";
  43.         }
  44.         /**
  45.          * 特殊字符转义--SQL模糊查询字段
  46.          */
  47.         List<String> list = Arrays.asList(keyWord.split("")).stream()
  48.                 .map(mo -> {
  49.                     for (Map.Entry<String, String> fo : keyMap.entrySet()) {
  50.                         String key = fo.getKey();
  51.                         String value = fo.getValue();
  52.                         if (key.equals(mo)) {
  53.                             mo = mo.replace(key, value);
  54.                         }
  55.                     }
  56.                     return mo;
  57.                 }).collect(Collectors.toList());
  58.         StringBuffer result = new StringBuffer();
  59.         list.forEach(s -> result.append(s));
  60.         return result.toString();
  61.     }
  63. }