java 持久化数据库 特殊字符 处理

application.yml配置

#str.escape 比对字段中待处理的特殊字符 逗号隔开
str:
  escape: \,',"

工具类

package com.demo.utils;
import org.springframework.stereotype.Component;
import org.apache.commons.lang3.StringUtils;
@Component
public class StringUtil {
    @Value("${chk.escape}")
    private String escape;
    public static void main(String[] args) throws SQLException {
    	System.out.println("你'好\\啊\"");
        System.out.println(escape("你'好\\啊\"",escape));
    }
    public static String escape(String sourceString,String type) {
        if (StringUtils.isNotBlank(type) && StringUtils.isNotBlank(sourceString)){
            String[] split = type.split(",");
            for (String s : split) {
                sourceString = sourceString.replace(s,"\\"+s);
            }
        }
        return sourceString;
    }
}

输出