package org.springblade.common.utils;

import java.util.regex.Pattern;
import java.util.regex.Matcher;
public class SQLParseUtils {

	public static String parseSQLType(String sql){
		if (sql==null){
			return null;
		}
		String type = sql.split(" ")[0];
		if (type.equalsIgnoreCase("INSERT")){
			return "INSERT";
		} else if (type.equalsIgnoreCase("UPDATE")) {
			return "UPDATE";
		} else if (type.equalsIgnoreCase("DELETE")) {
			return "DELETE";
		}else {
			return null;
		}
	}

	public static String getTableName(String sql) {

		String tableName = null;
		// 正则表达式匹配 INSERT、UPDATE 和 DELETE 语句
		String regex = "(?i)(?:INSERT\\s+INTO|UPDATE|DELETE\\s+FROM)\\s+(\\w+)";
		Pattern pattern = Pattern.compile(regex);
		Matcher matcher = pattern.matcher(sql.trim());
		if (matcher.find()) {
			tableName = matcher.group(1);
		}
		return tableName;
	}
	public static void main(String[] args) {
		String tableName = getTableName("INSERT INTO orders (customer_id, product_id, quantity) VALUES (789, 123, 5)");
		System.out.println(tableName);
	}

}