D
dysoft
Unregistered / Unconfirmed
GUEST, unregistred user!
如何将XML格式的数据导入SQL数据库,假设一个表有“日期”,“金额”两个字段,
XML的格式如下:
<?xml version="1.0" encoding="gb2312" ?>
- <ufinterface roottag="bankcontrast" billtype="bc" subtype="" receiver="9009" sender="9009" proc="add" replace="Y" isexchange="Y" filename="bankcontrast.xml" operation="req">
- <bankcontrast id="7055475116">
- <bankcontrast_head>
<contrastaccount />
<company />
<explanation />
<checkstyle />
<checkno />
<checkdate>2006-01-06</checkdate>
<debitamount>0</debitamount>
<creditamount>3494</creditamount>
<years />
<period />
<count />
</bankcontrast_head>
</bankcontrast>
- <bankcontrast id="5334240199">
- <bankcontrast_head>
<contrastaccount />
<company />
<explanation />
<checkstyle />
<checkno />
<checkdate>2006-01-06</checkdate>
<debitamount>0</debitamount>
<creditamount>2836.47</creditamount>
<years />
<period />
<count />
</bankcontrast_head>
</bankcontrast>
</ufinterface>
最好有代码,谢谢!!
XML的格式如下:
<?xml version="1.0" encoding="gb2312" ?>
- <ufinterface roottag="bankcontrast" billtype="bc" subtype="" receiver="9009" sender="9009" proc="add" replace="Y" isexchange="Y" filename="bankcontrast.xml" operation="req">
- <bankcontrast id="7055475116">
- <bankcontrast_head>
<contrastaccount />
<company />
<explanation />
<checkstyle />
<checkno />
<checkdate>2006-01-06</checkdate>
<debitamount>0</debitamount>
<creditamount>3494</creditamount>
<years />
<period />
<count />
</bankcontrast_head>
</bankcontrast>
- <bankcontrast id="5334240199">
- <bankcontrast_head>
<contrastaccount />
<company />
<explanation />
<checkstyle />
<checkno />
<checkdate>2006-01-06</checkdate>
<debitamount>0</debitamount>
<creditamount>2836.47</creditamount>
<years />
<period />
<count />
</bankcontrast_head>
</bankcontrast>
</ufinterface>
最好有代码,谢谢!!