读书人

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

发布时间: 2012-05-02 15:36:04 作者: rapoo

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传输,用纯文本试试

读书人网 >ASP

热点推荐