MSXML2.DOMDocument.3.0从XML中读取数据

解析XML订单数据

最新推荐文章于 2023-02-22 23:03:36 发布

最新推荐文章于 2023-02-22 23:03:36 发布 · 2.1k 阅读

文章标签：

#XML #JavaScript #ViewUI

js 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一种使用JavaScript从XML文件中解析订单数据的方法，并通过一个实际案例演示了如何逐条读取订单项的具体细节。

部署运行你感兴趣的模型镜像

先有一个XML数据：

<?xml version="1.0" ?>
<Order>
  <Account>9900234</Account>
  <Item id="1">
    <SKU>1234</SKU>
    <PricePer>5.95</PricePer>
    <Quantity>100</Quantity>
    <Subtotal>595.00</Subtotal>
    <Description>Super Widget Clamp</Description>
  </Item>
  <Item id="2">
    <SKU>6234</SKU>
    <PricePer>22.00</PricePer>
    <Quantity>10</Quantity>
    <Subtotal>220.00</Subtotal>
    <Description>Mighty Foobar Flange</Description>
  </Item>
  <Item id="3">
    <SKU>9982</SKU>
    <PricePer>2.50</PricePer>
    <Quantity>1000</Quantity>
    <Subtotal>2500.00</Subtotal>
    <Description>Deluxe Doohickie</Description>
  </Item>
  <Item id="4">
    <SKU>3256</SKU>
    <PricePer>389.00</PricePer>
    <Quantity>1</Quantity>
    <Subtotal>389.00</Subtotal>
    <Description>Muckalucket Bucket</Description>
  </Item>
  <NumberItems>1111</NumberItems>
  <Total>3704.00</Total>
  <OrderDate>07/07/2002</OrderDate>
  <OrderNumber>8876</OrderNumber>
</Order>

然后把Item结点的数据读出。

相关的JS函数如下：

<script language="javascript">
    var i = -1;
    var orderDoc = new ActiveXObject ("MSXML2.DOMDocument.3.0");
    orderDoc.load("order.xml");
    var items = orderDoc.documentElement.selectNodes("/Order/Item");

    //获得结点文本
    function getNode(doc, xpath) {
      var retval = "";
      var value = doc.documentElement.selectSingleNode(xpath);
      if (value) retval = value.text;
      return retval;
    }
    //下一条记录
    function getDataNext() {
      i++;
      if (i > items.length - 1) i = 0;

      document.forms[0].SKU.value = getNode(orderDoc, "/Order/Item[" + i + "]/SKU");
      document.forms[0].Price.value = getNode(orderDoc, "/Order/Item[" + i + "]/PricePer");
      document.forms[0].Quantity.value = getNode(orderDoc, "/Order/Item[" + i + "]/Quantity");
      document.forms[0].Total.value = getNode(orderDoc,"/Order/Item[" + i + "]/Subtotal");
      document.forms[0].Description.value = getNode(orderDoc, "/Order/Item[" + i + "]/Description");
    }
    //前一条记录

    function getDataPrev() {
      i--;
      if (i < 0) i = items.length - 1;
      
      document.forms[0].SKU.value = getNode(orderDoc, "/Order/Item[" + i + "]/SKU");
      document.forms[0].Price.value = getNode(orderDoc,"/Order/Item[" + i + "]/PricePer");
      document.forms[0].Quantity.value = getNode(orderDoc, "/Order/Item[" + i + "]/Quantity");
      document.forms[0].Total.value = getNode(orderDoc,"/Order/Item["+ i + "]/Subtotal");
      document.forms[0].Description.value = getNode(orderDoc, "/Order/Item[" + i + "]/Description");
    }
</script>

下面是测试网页代码：

<body onload="getDataNext()">
<form>
  <table border="0">
    <tr>
	    <td>SKU</td>
		<td><input type="text" name="SKU"></td>
	</tr>
    <tr>
	   <td>Price</td>
	   <td><input type="text" name="Price"></td>
    </tr>
    <tr>
	    <td>Quantity</td>
		<td><input type="text" name="Quantity"></td>
	</tr>
    <tr>
	    <td>Total</td>
		<td><input type="text" name="Total"></td>
	</tr>
    <tr>
	    <td>Description</td>
		<td><input type="text" name="Description"></td>
     </tr>
  </table>
    <input type="button" value="<<" onClick="getDataPrev()">
     <input type="button" value=">>" onClick="getDataNext()">
  </form>
</body>

您可能感兴趣的与本文相关的镜像