java 为mysql添加索引

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class AddIndexExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String user = "username";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement()) {

            // 创建单列索引
            String sql1 = "CREATE INDEX idx_name ON mytable(name)";
            stmt.executeUpdate(sql1);

            // 创建复合索引
            String sql2 = "CREATE INDEX idx_name_age ON mytable(name, age)";
            stmt.executeUpdate(sql2);

            System.out.println("Indexes created successfully!");

        } catch (SQLException e) {
            System.err.println("Error creating indexes: " + e.getMessage());
        }
    }
}