开发中遇到的问题 JSON转义字符 String转小写 SQL查询

JSON转义字符问题

问题

{“b”:"{“enabled”:“1”,“aa”:""}",“name”:“yy”,“age”:“11”}

  JSONObject a = new JSONObject();
        a.put("name", "yy");
        a.put("age", "11");
        String b = "{\"enabled\":\"1\",\"aa\":\"\"}";
        a.put("b", b);
        System.out.println(a.toJSONString());

如果是这样封装的话,是会出现上面这种情况的.

StringEscapeUtils

网上有用这种方式解决的

        <dependency>
            <groupId>commons-lang</groupId>
            <artifactId>commons-lang</artifactId>
            <version>2.5</version>
        </dependency>

{“b”:"{“enabled”:“1”,“aa”:""}",“name”:“yy”,“age”:“11”}

这样就出现问题

解决办法 JSONObject parse = JSONObject.parseObject()

  JSONObject a = new JSONObject();
        a.put("name", "yy");
        a.put("age", "11");
        String b = "{\"enabled\":\"1\",\"aa\":\"\"}";
        JSONObject parse = JSONObject.parseObject(b);
        a.put("b", parse);
        System.out.println(a.toJSONString());

{“b”:{“aa”:"",“enabled”:“1”},“name”:“yy”,“age”:“11”}

String转小写

JSON转String后转小写

    public static String transformLowerCase(String json) {
        String regex = "[\\\"' ]*[^:\\\"' ]*[\\\"' ]*:";// (\{|\,)[a-zA-Z0-9_]+:

        Pattern pattern = Pattern.compile(regex);
        StringBuffer sb = new StringBuffer();
        Matcher m = pattern.matcher(json);
        while (m.find()) {
            m.appendReplacement(sb, m.group().toLowerCase());
        }
        m.appendTail(sb);
        return sb.toString();
    }

SQL 条件查询and括号的问题

需要做精确查询的时候，不能用到or了，会导致数据查出来很多

SELECT count(1) from xx WHERE 
INSP_ORG_CODE='12330000470027240N'
or AREA_CODE_L2 in('330100','330400','330500') 
or AREA_CODE_L3 in('330106','330521','330523','330155') 
and TRANID='0087A1B86F094D7EB2AA36A5994EAD8C';

改成

SELECT count(1) from xx WHERE 1=1 
and (INSP_ORG_CODE='12330000470027240N'
or AREA_CODE_L2 in('330100','330400','330500') 
or AREA_CODE_L3 in('330106','330521','330523','330155'))
and TRANID='0087A1B86F094D7EB2AA36A5994EAD8C';