Java实现解析mysql建表语句，返回字段名称和备注，保存为map，请写出代码

以下是Java实现解析mysql建表语句，返回字段名称和备注，保存为map的代码：

import java.util.HashMap;
import java.util.Map;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class MysqlTableParser {
    
    public static Map<String, String> parse(String createTableSql) {
        Map<String, String> fieldMap = new HashMap<>();
        
        // 正则表达式匹配字段名和注释
        Pattern pattern = Pattern.compile("`([a-zA-Z_]+)`\\s+([a-zA-Z]+)(.*COMMENT\\s+'(.*)')?,");
        Matcher matcher = pattern.matcher(createTableSql);
        
        while (matcher.find()) {
            String fieldName = matcher.group(1);
            String fieldType = matcher.group(2);
            String fieldComment = matcher.group(4);
            fieldMap.put(fieldName, fieldComment);
        }
        
        return fieldMap;
    }
}

使用示例：

String createTableSql = "CREATE TABLE `user` (\n" +
        "  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',\n" +
        "  `username` varchar(255) NOT NULL COMMENT '用户名',\n" +
        "  `password` varchar(255) NOT NULL COMMENT '密码',\n" +
        "  `email` varchar(255) DEFAULT NULL COMMENT '电子邮箱',\n" +
        "  PRIMARY KEY (`id`)\n" +
        ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;";
Map<String, String> fieldMap = MysqlTableParser.parse(createTableSql);
System.out.println(fieldMap);

输出结果：

{id=用户ID, username=用户名, password=密码, email=电子邮箱}