xml从url转换成历史数据图

erhoui1w  于 2021-06-20  发布在  Mysql
关注(0)|答案(0)|浏览(235)

我要找的是一个服务或脚本,它每x分钟从url中提取xml一次,将数据保存到mysql数据库,然后用户就可以搜索一个项目,并显示该项目的历史价格数据。
这是1项的xml外观:

<?xml version="1.0" encoding="UTF-8"?>
<Success>
   <Result>
      <AccId>2075</AccId>
      <Type>2793</Type>
      <Price>100</Price>
      <SaleId>211557</SaleId>
      <Time>636662891054273275</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>7911</AccId>
      <Type>2793</Type>
      <Price>100</Price>
      <SaleId>198528</SaleId>
      <Time>636662291658957640</Time>
      <Hours>31</Hours>
   </Result>
   <Result>
      <AccId>8839</AccId>
      <Type>2793</Type>
      <Price>110</Price>
      <SaleId>203789</SaleId>
      <Time>636662477761119929</Time>
      <Hours>36</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211261</SaleId>
      <Time>636662870212977640</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211445</SaleId>
      <Time>636662885517249200</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211396</SaleId>
      <Time>636662880277082389</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211399</SaleId>
      <Time>636662880277106287</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211259</SaleId>
      <Time>636662870086140573</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211400</SaleId>
      <Time>636662880279095669</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211257</SaleId>
      <Time>636662870086133672</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211256</SaleId>
      <Time>636662870086130216</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211388</SaleId>
      <Time>636662879775606621</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>9897</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>211389</SaleId>
      <Time>636662879775618280</Time>
      <Hours>47</Hours>
   </Result>
   <Result>
      <AccId>8839</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>189990</SaleId>
      <Time>636661845264224374</Time>
      <Hours>18</Hours>
   </Result>
   <Result>
      <AccId>1570</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>185279</SaleId>
      <Time>636661608303483850</Time>
      <Hours>12</Hours>
   </Result>
   <Result>
      <AccId>6144</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>193953</SaleId>
      <Time>636662075376965802</Time>
      <Hours>25</Hours>
   </Result>
   <Result>
      <AccId>6867</AccId>
      <Type>2793</Type>
      <Price>120</Price>
      <SaleId>210396</SaleId>
      <Time>636662809913772219</Time>
      <Hours>45</Hours>
   </Result>
   <Result>
      <AccId>10091</AccId>
      <Type>2793</Type>
      <Price>150</Price>
      <SaleId>209347</SaleId>
      <Time>636662744031038414</Time>
      <Hours>43</Hours>
   </Result>
   <Result>
      <AccId>9326</AccId>
      <Type>2793</Type>
      <Price>150</Price>
      <SaleId>192933</SaleId>
      <Time>636662020656105309</Time>
      <Hours>23</Hours>
   </Result>
   <Result>
      <AccId>9326</AccId>
      <Type>2793</Type>
      <Price>150</Price>
      <SaleId>192934</SaleId>
      <Time>636662020656108191</Time>
      <Hours>23</Hours>
   </Result>
   <Result>
      <AccId>5979</AccId>
      <Type>2793</Type>
      <Price>150</Price>
      <SaleId>190952</SaleId>
      <Time>636661905157273715</Time>
      <Hours>20</Hours>
   </Result>
   <TotalAuctions>4114</TotalAuctions>
</Success>

我需要它来计算所有数据的高,低和平均值,并将其添加到数据库和图表将基于历史

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题