java 格式化mysql语句

import com.github.javafaker.Faker;
import net.sf.jsqlparser.JSQLParserException;
import net.sf.jsqlparser.parser.CCJSqlParserManager;
import net.sf.jsqlparser.statement.Statement;
import net.sf.jsqlparser.statement.select.PlainSelect;
import net.sf.jsqlparser.util.TablesNamesFinder;

public class SqlFormatterExample {
    public static void main(String[] args) {
        String sql = "SELECT * FROM users WHERE age > 18 AND city = 'New York'";
        
        try {
            CCJSqlParserManager parserManager = new CCJSqlParserManager();
            Statement statement = parserManager.parse(new StringReader(sql));
            
            if (statement instanceof PlainSelect) {
                PlainSelect plainSelect = (PlainSelect) statement;
                TablesNamesFinder tablesNamesFinder = new TablesNamesFinder();
                tablesNamesFinder.setSelectBody(plainSelect);
                System.out.println("Tables involved: " + tablesNamesFinder.getTableList());
            }
            
            // 使用sql-formatter库进行格式化
            String formattedSql = formatSql(sql);
            System.out.println("Formatted SQL: \n" + formattedSql);
        } catch (JSQLParserException e) {
            e.printStackTrace();
        }
    }

    private static String formatSql(String sql) {
        // 这里可以使用sql-formatter库的具体实现方法
        // 例如：return SqlFormatter.format(sql);
        return sql; // 这里仅作为示例，实际应调用格式化方法
    }
}