首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > ASP >

xml文件,需要用asp语句把数据直接写入数据库

2012-05-02 
xml文件,需要用asp语句把数据直接写入数据库?求救?xml version1.0 encodingutf-8 ?- root- pro

xml文件,需要用asp语句把数据直接写入数据库?求救
<?xml version="1.0" encoding="utf-8" ?> 
- <root>
- <pro pid="55001">
  <name>挎包</name> 
  <category>121</category> 
  <dw>1</dw> 
  <brand>0</brand> 
  <property>9</property> 
  <stats>2</stats> 
  <procode /> 
  <defaultprice>100.00</defaultprice> 
  <kthcartsmoney>99.00</kthcartsmoney> 
  <kc>0</kc> 
  <description><img alt="" src="images/upload/month_1105/201105130954076378.jpg" /></description> 
  <pic>images/attachments/1105131003208y0hl8y4o483.jpg</pic> 
  <gg>36*43</gg> 
  <weight>0.293</weight> 
  <material>帆布</material> 
  <boxing>opp袋</boxing> 
  <origin>浙江</origin> 
  <boxnums>0</boxnums> 
  <gw /> 
  <nw /> 
  <smallfile>images/attachments/1105131003208y0hl8y4o483_small.jpg</smallfile> 
  <middlefile>images/attachments/1105131003208y0hl8y4o483_middle.jpg</middlefile> 
  <att>18772,55001,images/attachments/1105131003208y0hl8y4o483.jpg,1</att> 
  </pro>
- <pro pid="55002">
  <name>日式牛津布多功能纸巾盒(黑色)</name> 
  <category>67</category> 
  <dw>1</dw> 
  <brand>0</brand> 
  <property>3</property> 
  <stats>1</stats> 
  <procode>B100503</procode> 
  <defaultprice>8.20</defaultprice> 
  <kthcartsmoney>8.00</kthcartsmoney> 
  <kc>53</kc> 
  <description><img alt="" src="images/upload/month_1105/201105131122441500.jpg" /></description> 
  <pic>images/attachments/110516154502kfygzhxtxnvg.jpg</pic> 
  <gg>21*10*10cm</gg> 
  <weight>0.287</weight> 
  <material>牛津布</material> 
  <boxing>opp袋</boxing> 
  <origin>浙江</origin> 
  <boxnums>100</boxnums> 
  <gw /> 
  <nw /> 
  <smallfile>images/attachments/110516154502kfygzhxtxnvg_small.jpg</smallfile> 
  <middlefile>images/attachments/110516154502kfygzhxtxnvg_middle.jpg</middlefile> 
  <att>18773,55002,images/attachments/1105131123237krgf6vil88y.jpg,1|18774,55002,images/attachments/110513112331z7tmcwxmcf9a.jpg,2|18837,55002,images/attachments/110516154502kfygzhxtxnvg.jpg,1</att> 
  </pro>
- <pro pid="55003">
  <name>日式牛津布多功能纸巾盒(蓝色)</name> 
  <category>67</category> 
  <dw>1</dw> 
  <brand>0</brand> 
  <property>3</property> 
  <stats>1</stats> 
  <procode>C151503</procode> 
  <defaultprice>8.20</defaultprice> 
  <kthcartsmoney>8.00</kthcartsmoney> 
  <kc>99</kc> 
  <description><img alt="" src="images/upload/month_1105/201105131256586500.jpg" /></description> 


  <pic>images/attachments/110516154535x7uysn9akx8e.jpg</pic> 
  <gg>21*10*10cm</gg> 
  <weight>0.287</weight> 
  <material>牛津布</material> 
  <boxing>opp袋</boxing> 
  <origin>浙江</origin> 
  <boxnums>100</boxnums> 
  <gw /> 
  <nw /> 
  <smallfile>images/attachments/110516154535x7uysn9akx8e_small.jpg</smallfile> 
  <middlefile>images/attachments/110516154535x7uysn9akx8e_middle.jpg</middlefile> 
  <att>18776,55003,images/attachments/110513125926wc512ko4iltu.jpg,2|18838,55003,images/attachments/110516154535x7uysn9akx8e.jpg,1</att> 
  </pro>
- <pro pid="55004">
  <name>日式牛津布多功能纸巾盒(条纹)</name> 
  <category>67</category> 
  <dw>1</dw> 
  <brand>0</brand> 
  <property>3</property> 
  <stats>1</stats> 
  <procode>B100902</procode> 
  <defaultprice>8.20</defaultprice> 
  <kthcartsmoney>8.00</kthcartsmoney> 
  <kc>50</kc> 
  <description><img alt="" src="images/upload/month_1105/201105131301581763.jpg" /></description> 
  <pic>images/attachments/110516154621bn80xplg34xf.jpg</pic> 
  <gg>21*10*10cm</gg> 
  <weight>0.287</weight> 
  <material>牛津布</material> 
  <boxing>opp袋</boxing> 
  <origin>浙江</origin> 
  <boxnums>100</boxnums> 
  <gw /> 
  <nw /> 
  <smallfile>images/attachments/110516154621bn80xplg34xf_small.jpg</smallfile> 
  <middlefile>images/attachments/110516154621bn80xplg34xf_middle.jpg</middlefile> 
  <att>18777,55004,images/attachments/110513130212kmo05zlz6rie.jpg,1|18778,55004,images/attachments/1105131302247ewsfxbrowgo.jpg,2|18839,55004,images/attachments/110516154621bn80xplg34xf.jpg,1</att> 
  </pro>
- <pro pid="55005">
  <name>新奇创意迷你红酒开瓶器 瓶盖起子</name> 
  <category>28</category> 
  <dw>1</dw> 
  <brand>0</brand> 
  <property>3</property> 
  <stats>1</stats> 
  <procode>A031902</procode> 
  <defaultprice>7.80</defaultprice> 
  <kthcartsmoney>7.80</kthcartsmoney> 
  <kc>117</kc> 
  <description><img alt="" src="images/upload/month_1105/201105131420381125.jpg" /></description> 
  <pic>images/attachments/1105131421114dllu7chzumk.jpg</pic> 
  <gg>11.5*2.5cm</gg> 
  <weight>0.061</weight> 
  <material>PC塑料、不锈钢</material> 
  <boxing>彩盒</boxing> 
  <origin>上海</origin> 
  <boxnums>300</boxnums> 
  <gw /> 
  <nw /> 
  <smallfile>images/attachments/1105131421114dllu7chzumk_small.jpg</smallfile> 
  <middlefile>images/attachments/1105131421114dllu7chzumk_middle.jpg</middlefile> <att>18780,55005,images/attachments/1105131421114dllu7chzumk.jpg,1|18781,55005,images/attachments/110513142124hdt1wu4mk71v.jpg,2</att> 


  </pro>
  </root>

以上每一个参数都需要写进相对应的数据库中,用ASP语句写,因为数据量非常大,我只是把其中的几个黏贴出来了,最好一次写数据库的数量为200个。

[解决办法]
这么多数据,最好别用xml传输,用纯文本试试

热点排行