动态生成xml文件问题（FusionChartsFree类型）-优快云博客

本文探讨了如何处理XML数据中时间重复出现的问题，并提出了优化方案以实现按钢厂分类显示不同价格，包括调整数据结构、生成高效XML文件的步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

我把数据从数据库读取出来存入数据中：[3740.02010-01-04中天3790.02010-01-05中天3800.02010-01-06中天3830.02010-01-07中天3790.02010-01-08中天3770.02010-01-04宝钢3840.02010-01-05宝钢3840.02010-01-06宝钢3840.02010-01-07宝钢3840.02010-01-08宝钢]
我自己做的只能生成这样的xml：
<?xml version="1.0" encoding="UTF-8"?>
<graph caption="quote" decimalPrecision="0" formatNumberScale="0" numberPrefix="RMB" showNames="1" showValues="0" showAlternateHGridColor="1" AlternateHGridColor="ff5904" divLineColor="ff5904" divLineAlpha="20" alternateHGridAlpha="5" baseFontColor="000000" baseFont="Arial" canvasBorderColor="dddddd" baseFontSize="12" bgColor="e6e6e6">
<categories>
<categories name="2010-01-04" />
<categories name="2010-01-05" />
<categories name="2010-01-06" />
<categories name="2010-01-07" />
<categories name="2010-01-08" />
<categories name="2010-01-04" />
<categories name="2010-01-05" />
<categories name="2010-01-06" />
<categories name="2010-01-07" />
<categories name="2010-01-08" />
</categories>
<dataset seriesName="12" bgColor="e6e6e6">
<set value="3740.0" />
<set value="3790.0" />
<set value="3800.0" />
<set value="3830.0" />
<set value="3790.0" />
<set value="3770.0" />
<set value="3840.0" />
<set value="3840.0" />
<set value="3840.0" />
<set value="3840.0" />
</dataset></graph>
-----------------------------------
但是我想要的结果是时间不能重复出现，而且价格按照钢厂多少就分几个（中天，宝钢）
我期待的xml是这样的
<?xml version="1.0" encoding="UTF-8"?>
<graph caption="quote" decimalPrecision="0" formatNumberScale="0" numberPrefix="RMB" showNames="1" showValues="0" showAlternateHGridColor="1" AlternateHGridColor="ff5904" divLineColor="ff5904" divLineAlpha="20" alternateHGridAlpha="5" baseFontColor="000000" baseFont="Arial" canvasBorderColor="dddddd" baseFontSize="12" bgColor="e6e6e6">
<categories>
<categories name="2010-01-04" />
<categories name="2010-01-05" />
<categories name="2010-01-06" />
<categories name="2010-01-07" />
<categories name="2010-01-08" />
</categories>
<dataset seriesName="12" bgColor="e6e6e6">
<set value="3740.0" />
<set value="3790.0" />
<set value="3800.0" />
<set value="3830.0" />
<set value="3790.0" />
</dataset>
<dataset seriesName="12" bgColor="e6e6e6">
<set value="3770.0" />
<set value="3840.0" />
<set value="3840.0" />
<set value="3840.0" />
<set value="3840.0" />
</dataset>
</graph>
------------------------哪位兄弟姐妹帮忙弄下啊，谢谢