INSERT INTO `fanpin`.`fan_category_product_goods` (`id`, `category_id`, `product_id`, `goods_specs`, `original_price`, `sales_price`, `type`, `integral`, `freight`, `inventory`, `status`, `create_time`, `create_by`, `update_by`, `update_time`, `attribute_name`, `attribute_value`) VALUES (135874794, '1723709945486000129', '267376620', NULL, NULL, '199', '普通商品', '20', '20', '10', NULL, '2023-11-13', 'admin', NULL, NULL, '重量', '100KG');
INSERT INTO `fanpin`.`fan_category_product_goods` (`id`, `category_id`, `product_id`, `goods_specs`, `original_price`, `sales_price`, `type`, `integral`, `freight`, `inventory`, `status`, `create_time`, `create_by`, `update_by`, `update_time`, `attribute_name`, `attribute_value`) VALUES (154825191, '1723709945486000129', '1952382663', NULL, NULL, '99', '普通商品', '10', '10', '999', NULL, '2023-11-13', 'admin', NULL, NULL, '转速', '100转');
INSERT INTO `fanpin`.`fan_category_product_goods` (`id`, `category_id`, `product_id`, `goods_specs`, `original_price`, `sales_price`, `type`, `integral`, `freight`, `inventory`, `status`, `create_time`, `create_by`, `update_by`, `update_time`, `attribute_name`, `attribute_value`) VALUES (388124086, '1723709945486000129', '267376620', NULL, NULL, '199', '普通商品', '20', '20', '10', NULL, '2023-11-13', 'admin', NULL, NULL, '转速', '100转');
INSERT INTO `fanpin`.`fan_category_product_goods` (`id`, `category_id`, `product_id`, `goods_specs`, `original_price`, `sales_price`, `type`, `integral`, `freight`, `inventory`, `status`, `create_time`, `create_by`, `update_by`, `update_time`, `attribute_name`, `attribute_value`) VALUES (595222892, '1723709945486000129', '1952382663', NULL, NULL, '99', '普通商品', '10', '10', '999', NULL, '2023-11-13', 'admin', NULL, NULL, '重量', '90KG');
INSERT INTO `fanpin`.`fan_category_product_goods` (`id`, `category_id`, `product_id`, `goods_specs`, `original_price`, `sales_price`, `type`, `integral`, `freight`, `inventory`, `status`, `create_time`, `create_by`, `update_by`, `update_time`, `attribute_name`, `attribute_value`) VALUES (806805885, '1723709945486000129', '267376620', NULL, NULL, '199', '普通商品', '20', '20', '10', NULL, '2023-11-13', 'admin', NULL, NULL, '颜色', '灰色');
INSERT INTO `fanpin`.`fan_category_product_goods` (`id`, `category_id`, `product_id`, `goods_specs`, `original_price`, `sales_price`, `type`, `integral`, `freight`, `inventory`, `status`, `create_time`, `create_by`, `update_by`, `update_time`, `attribute_name`, `attribute_value`) VALUES (1295610808, '1723709945486000129', '1952382663', NULL, NULL, '99', '普通商品', '10', '10', '999', NULL, '2023-11-13', 'admin', NULL, NULL, '颜色', '黑色');
INSERT INTO `fanpin`.`fan_category_product_goods` (`id`, `category_id`, `product_id`, `goods_specs`, `original_price`, `sales_price`, `type`, `integral`, `freight`, `inventory`, `status`, `create_time`, `create_by`, `update_by`, `update_time`, `attribute_name`, `attribute_value`) VALUES (1720111770, '1723709945486000129', '267376620', NULL, NULL, '199', '普通商品', '20', '20', '10', NULL, '2023-11-13', 'admin', NULL, NULL, '转速', '200转');
INSERT INTO `fanpin`.`fan_category_product_goods` (`id`, `category_id`, `product_id`, `goods_specs`, `original_price`, `sales_price`, `type`, `integral`, `freight`, `inventory`, `status`, `create_time`, `create_by`, `update_by`, `update_time`, `attribute_name`, `attribute_value`) VALUES (2039846087, '1723709945486000129', '1952382663', NULL, NULL, '99', '普通商品', '10', '10', '999', NULL, '2023-11-13', 'admin', NULL, NULL, '颜色', '灰色');
这个是8条sql语句，两个同类型不同规格价格的产品，插入数据库之后，如何用java把这个数据处理为{"颜色"："灰色","重量"："90G","转速"："100转","sales_price":"99"},{"颜色"："黑色","重量"："90G","转速"："100转","sales_price":"99"},{"颜色"："灰色","重量"："100G","转速"："100转","sales_price":"199"},{"颜色"："灰色","重量"："100G","转速"："200转","sales_price":"199"}这样的数据