将参数中动态SQL的结果赋值给另一个参数

import java.sql.*;

public class DynamicSQLExample {
    public static void main(String[] args) {
        String query = "SELECT * FROM products WHERE category = ?";
        String category = "Electronics";
        String result = null;
        
        try {
            Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database", "username", "password");
            PreparedStatement statement = connection.prepareStatement(query);
            statement.setString(1, category);
            
            ResultSet resultSet = statement.executeQuery();
            if (resultSet.next()) {
                result = resultSet.getString("name");
            }
            
            resultSet.close();
            statement.close();
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        
        System.out.println("Result: " + result);
    }
}