正则表达式提取内容

From line 4, column 2 to line 4, column 3: Column 'id' not found in any table

从上面报错信息中提前出行号、列号信息。

private static final String ERROR_LINE_PATTER = ".*From line (?<lineNum>\\d+), column (?<columnNum>\\d+) to line (?<endLineNum>\\d+), column (?<endColumnNum>\\d+):.*";

@VisibleForTesting
    static ErrorPosition parsePos(String errorMessage) {
        Pattern pattern = Pattern.compile(ERROR_LINE_PATTER);
        Matcher matcher = pattern.matcher(errorMessage);
        if (matcher.matches()) {
            return ErrorPosition.builder()
                    .lineNum(Integer.parseInt(matcher.group("lineNum").trim()))
                    .columnNum(Integer.parseInt(matcher.group("columnNum").trim()))
                    .endLineNum(Integer.parseInt(matcher.group("endLineNum").trim()))
                    .endColumnNum(Integer.parseInt(matcher.group("endColumnNum").trim()))
                    .build();
        }

        return null;
    }