¡°XML DOM¶ÁÈ¡½ÚµãÐÅÏ¢¡±Ð¡½á
<?
XML DOM¶ÁÈ¡½ÚµãÐÅÏ¢Óöµ½ÎÊÌâ×ܽ᣺
1:NodeList: ʹÓýڵãµÄchildNodesÊôÐÔ»òÕßdocument¶ÔÏóµÄgetElementsByTagName()·½·¨£¬¾Í»á·µ»ØÒ»¸ö°üº¬½ÚµãÁбíµÄNodeList
2: ÔÚ XML DOM ÖУ¬½ÚµãµÄ¹ØÏµ±»¶¨ÒåΪ½ÚµãµÄÊôÐÔ£º
· parentNode
· childNodes
· firstChild
· lastChild
· nextSibling
· previousSibling
3£º±éÀúXML½ÚµãÁбíµÄ·½·¨
£¨1£©Í¨¹ýʹÓà getElementsByTagName() ·½·¨
£¨2£©Í¨¹ýÑ»·£¨±éÀú£©½ÚµãÊ÷
£¨3£©Í¨¹ýÀûÓýڵãµÄ¹ØÏµÔÚ½ÚµãÊ÷Öе¼º½
1£ºÍ¨¹ýgetElementsByTagName·½·¨
//ͨ¹ýgetElementsByTagNameµÄ·½·¨·ÃÎʽڵã
//ͨ¹ýlengthÀ´Ñ»·Ò»¸ö½ÚµãÁбí
xmlDoc=loadXMLDoc("books.xml");
x=xmlDoc.getElementsByTagName("title");
//È¡µÃ½ÚµãµÄNodeNameΪtitleµÄËùÓнڵã
for (i=0;i<x.length;i++) {
document.write(x[i].childNodes[0].nodeValue);
//Ñ»·Êä³öÿ¸ötitle×Ó½ÚµãµÄÎı¾½ÚµãµÄÖµ
document.write("<br />");
}
2£®1£ºÍ¨¹ýÑ»·¸ù½ÚµãÊ÷µÄ·½·¨
//Ñ»·¸ù½ÚµãµÄ×ӽڵ㣬ͬʱ½ÚµãÊÇÔªËØ½ÚµãµÄ·½·¨±éÀú½Úµã
xmlDoc=loadXMLDoc("books.xml");
x=xmlDoc.documentElement.childNodes;
//»ñµÃ¸ùÔªËØµÄËùÓÐ×ӽڵ㣬¸ÃÎĵµÖеĸù½ÚµãΪbookstore
for (i=0;i<x.length;i++)
{
if (x[i].nodeType==1)
{//Èç¹û×Ó½ÚµãÊÇÔªËØ½Úµã£¬ÔòÊä³ö½ÚµãµÄNodeName
document.write(x[i].nodeName);
document.write("<br />");
}
}
2.2ͨ¹ýÑ»·¸ù½ÚµãµÄ·½·¨£¬²¢È¡µÃÎı¾½ÚµãµÄÖµ
//±éÀúStringÀàÐ͵ÄXML
<html>
<head>
<script type="text/javascript" src="loadxmlstring.js"></script>
</head>
<body>
<script type="text/javascript">
text="<book>";
text=text+"<title>Harry Potter</title>";
text=text+"<author>J K. Rowling</author>";
text=text+"<year>2005</year>";
text=text+"</book>";
xmlDoc=loadXMLString(text);
x=xmlDoc.documentElement.childNodes;
//µÃµ½¸ù½ÚµãbookϵÄËùÓÐ×Ó½ÚµãµÄNodeList
for (i=0;i<
Ïà¹ØÎĵµ£º
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
create procedure [dbo].[MachiningPayedGetListByCondition]
@CustomerName varchar(50),
@CustomerPhone varchar(50),
@PactNumber varchar(50),
@Ispay bit
as
begin
set nocount on;
SELECT
dp.ID as 'MachiningPayed/@ID',
&nbs ......
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="fw_student">
<resultMap class="com.sias.Student" id="student">
<result column="name" property="na ......
Java codeFormat ft=Format.getRawFormat();
ft.setEncoding("utf-8");
ft.setIndent(" ");//ÉèÖÃËõ½ø
XMLOutputter outputter=new XMLOutputter(ft);//ÉèÖÃXML¸ñʽ
Õâλ˵µÄ²»´í£»
ÔÚieÀïÃæ£¬ËüÄܰÑxml×Ô¶¯½âÎö³ÆÊ÷Ðνṹ£¬ËùÒÔ¿´ÆðÀ´Ã»ÎÊÌ⣬ÔÚ¼Çʱ¾ÀïÃæ£¬¾Í²»ÐÐÁ ......
from£ºhttp://www.xland.com.cn/article/7/81/0804/28778.htm
±¾ÀàʵÏÖ£º
Êý¾Ý¿âÐÅÏ¢µ¼³ö£ºword£¬excel£¬json£¬xml£¬sql
Êý¾Ý¿â»Ö¸´£º´Ósql£¬´ÓÎļþ
¾ßÌåÓ÷¨:
Ê×ÏÈн¨²âÊÔÓÃÊý¾Ý¿âmytest£¬È»ºóÔÚÀïÃæ½¨Õűí
PHP´úÂë:
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
--
-- ±íµÄ½á¹¹ `test`
--
CREATE TABLE `test` (
`id ......