简单的json字符串和mysql查询sql转义函数

  protected String jsonEscape(String val){
        StringBuilder builder=new StringBuilder();

        for(int i=0;i<val.length();++i){
            char c=val.charAt(i);
            switch (val.charAt(i)){
                case '\r':builder.append("\\r");break;
                case '\n':builder.append("\\n");break;
                case '\t':builder.append("\\t");break;
                case '\b':builder.append("\\b");break;
                case '\0':builder.append("\\0");break;
                case '\f':builder.append("\\f");break;
                case '"':builder.append("\\\"");break;
                case '\\':builder.append("\\\\");break;
                case '/':builder.append("\\/");break;
                default:
                    builder.append(c);
            }
        }
        return builder.toString();
    }

用于手工拼接json对象

 

 protected String mysqlEscape(CharSequence con) {
        StringBuffer buffer=new StringBuffer();
        for(int i=0;i<con.length();++i){
            char c=con.charAt(i);
            switch (c){
                case '\0':buffer.append("\\0");break;
                case '\'':buffer.append("\\'");break;
                case '\"':buffer.append("\\\"");break;
                case '\b':buffer.append("\\b");break;
                case '\n':buffer.append("\\n");break;
                case '\r':buffer.append("\\r");break;
                case '\t':buffer.append("\\t");break;
                case (char)26:buffer.append("\\Z");break;
                case '\\':buffer.append("\\\\");break;
                case '%':buffer.append("\\%");break;
                case '_':buffer.append("\\_");break;
                default: buffer.append(c);
            }
        }

        return buffer.toString();
    }

用于偶尔情况下手工拼接sql