Java正規表示式匹配字串並提取中間值的方法範例

<saml:AttributeStatement>
    <saml:Attribute Name="mail">
        <saml:AttributeValue xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">zhengkai.blog.csdn.net</saml:AttributeValue>
    </saml:Attribute>
    <saml:Attribute Name="cn">
        <saml:AttributeValue xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">amAdmin</saml:AttributeValue>
    </saml:Attribute>
</saml:AttributeStatement>

public static void main(String[] args) {
        String content = "";
        content = "<saml:AttributeStatement>";
        content += "    <saml:Attribute Name="mail">";
        content += "        <saml:AttributeValue xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">zhengkai.blog.csdn.net</saml:AttributeValue>";
        content += "    </saml:Attribute>";
        content += "    <saml:Attribute Name="cn">";
        content += "        <saml:AttributeValue xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="xs:string">amAdmin</saml:AttributeValue>";
        content += "    </saml:Attribute>";
        content += "</saml:AttributeStatement>";
        String pattern = "\<saml\:Attribute Name=\"(?<scope>.*?)\"\>[\s\S]*?\<saml\:AttributeValue[\s\S]*?\>(?<value>.*?)\<\/saml\:AttributeValue\>[\s\S]*?\<\/saml\:Attribute\>";
        Pattern r = Pattern.compile(pattern);
        Matcher matcher = r.matcher(saml2attributeString);
        while (matcher.find()){
            String attributeName = matcher.group("scope");
            String attributeValue = matcher.group("value");
            System.out.println("attributeName->"+attributeName +",attributeValue->"+attributeValue );
        }
    }

\<saml\:Attribute Name=\"(?<scope>.*?)\"\>[\s\S]*?\<saml\:AttributeValue[\s\S]*?\>(?<value>.*?)\<\/saml\:AttributeValue\>[\s\S]*?\<\/saml\:Attribute\>

    //匹配整個ddl，將ddl分為表名，列sql部分，表註釋
    private static final Pattern DDL_PATTERN = Pattern.compile("\s*create\s+table\s+(?<tableName>\S+)[^\(]*\((?<columnsSQL>[\s\S]+)\)[^\)]+?(comment\s*(=|on\s+table)\s*'(?<tableComment>.*?)'\s*;?)?$", Pattern.CASE_INSENSITIVE);
    //匹配列sql部分，分別解析每一列的列名 型別 和列註釋
    private static final Pattern COL_PATTERN = Pattern.compile("\s*(?<fieldName>\S+)\s+(?<fieldType>\w+)\s*(?:\([\s\d,]+\))?((?!comment).)*(comment\s*'(?<fieldComment>.*?)')?\s*(,|$)", Pattern.CASE_INSENSITIVE);

    public static void parse(String sql){
        Matcher matcher = DDL_PATTERN.matcher(sql);
        if (matcher.find()){
            String tableName = matcher.group("tableName");
            String tableComment = matcher.group("tableComment");
            System.out.println(tableName + "tt" + tableComment);
            System.out.println("==========");
            String columnsSQL = matcher.group("columnsSQL");
            if (columnsSQL != null && columnsSQL.length() > 0){
                Matcher colMatcher = COL_PATTERN.matcher(columnsSQL);
                while (colMatcher.find()){
                    String fieldName = colMatcher.group("fieldName");
                    String fieldType = colMatcher.group("fieldType");
                    String fieldComment = colMatcher.group("fieldComment");
                    if (!"key".equalsIgnoreCase(fieldType)){
                        System.out.println(fieldName + "tt" + fieldType + "tt" + fieldComment);
                    }
                }
            }
        }
    }

    public static void main(String[] args){
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>");
        parse("CREATE TABLE `userinfo` (n" +
                "  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '使用者ID',n" +
                "  `username` varchar(255) NOT NULL COMMENT '使用者名稱',n" +
                "  `addtime` datetime NOT NULL COMMENT '建立時間',n" +
                "  PRIMARY KEY (`user_id`)n" +
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='使用者資訊'");
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>");
        parse("CREATE TABLE `USER` (n" +
                "`ID` varchar(32) PRIMARY KEY COMMENT '主鍵',n" +
                "`password` varchar(32) NOT NULL COMMENT '密碼',n" +
                "`username` varchar(32) NOT NULL COMMENT '使用者'n" +
                ") ENGINE=InnoDB DEFAULT CHARSET=utf8;");
        System.out.println(">>>>>>>>>>>>>>>>>>>>>>>>>>>>>");
        parse("CREATE TABLE `tb_amount` (n" +
                "`ID` int(10) NOT NULL AUTO_INCREMENT,n" +
                "`PRODUCT_CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '產品程式碼',n" +
                "`GENDER` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性別(male,female)',n" +
                "`MIN_INSURED_AGE` int(3) NULL DEFAULT NULL COMMENT '最小投保年齡',n" +
                "`MAX_INSURED_AGE` int(3) NULL DEFAULT NULL COMMENT '最大投保年齡',n" +
                "`AMOUNT` double(10, 2) NULL DEFAULT NULL COMMENT '基本保額',n" +
                "`PREMIUM_RATE` double(10, 2) NULL DEFAULT NULL COMMENT '基本保費',n" +
                "`YEAR_NUM` int(3) NULL DEFAULT NULL COMMENT '繳費年限',n" +
                "`PREMIUM_TYPE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '費率型別',n" +
                "`INSURANCE_PERIOD` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保險期間(30年，60年)',n" +
                "`INSURANCE_PERIOD_TYPE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '保險期間型別(如定期年0,定期歲1,終身2,以後終身對應值：200)',n" +
                "`PAY_MODE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '交費方式',n" +
                "PRIMARY KEY (`ID`) USING BTREEn" +
                ") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;");
    }