• java 正则 贪婪匹配 匹配sql语句中的引号内容


    public class Demo {
        public static void main(String[] args) {
            String sql1 = "use test;select * from default.abc where dt='abc;faf;fff' and ct="2012;43" ; ";
            sql1 = "select * from aaa where dt= '20 ;12; 34;3' AND name='fafae; fa ; a'";
            //配置“” 或 ‘’ 里的内容
                Pattern p1 = Pattern.compile("'.*'|".*"");//贪婪匹配
    
                Matcher m1 = p1.matcher(sql1);
                String replace1 = null;
                while (m1.find()) {
                // 贪婪匹配 group= '20 ;12; 34;3' AND name='fafae; fa ; a'
                    String group = m1.group();
                    if (group.contains(";")) {
                        replace1 = sql1.replace(group, "'PLACEHOLDER'");
                        sql1 = replace1;
                    }
                }
            System.out.println("贪婪匹配" + sql1);
    
            String sql2 = "select * from aaa where dt= '20 ;12; 34;3' AND name='fafae; fa ; a'";
            //配置“” 或 ‘’ 里的内容
            Pattern p2 = Pattern.compile("'.*?'|".*?"");//非贪婪匹配
            Matcher m2 = p2.matcher(sql2);
            String replace2 = null;
            while (m2.find()) {
            // 第一次匹配  group   '20 ;12; 34;3'
            // 第二次匹配  group   'fafae; fa ; a'
                String group = m2.group();
                if (group.contains(";")) {
                    replace2 = sql2.replace(group, "'PLACEHOLDER'");
                    sql2 = replace2;
                }
            }
            System.out.println("非贪婪匹配" + sql2);
    
        }
    }
    
    
    结果:
    贪婪匹配  select * from aaa where dt= 'PLACEHOLDER'
    非贪婪匹配select * from aaa where dt= 'PLACEHOLDER' AND name='PLACEHOLDER'
    
    
  • 相关阅读:
    面向对象程序设计六大原则
    获取View的快照
    Xcode调试之exc_bad_access以及 message sent to deallocated instance
    OOA/OOD/OOP
    检测网络是否有效
    图像IO
    iOS应用性能调优的25个建议和技巧
    iOS围绕某点缩放或旋转的AnchorPoint的设定
    NPOI导出Excel2007板
    不同三级域名与二级域名之间互相共享Cookie
  • 原文地址:https://www.cnblogs.com/jiangxiaoxian/p/7134201.html
Copyright © 2020-2023  润新知