四眼看世界 XML语法
XML (EXtensible Markup Language)
XML is a
cross-platform, software and hardware independent tool for transmitting
information.
Prolog
XML
Declaration
Processing
Instructions
DOCTYPE
Declaration
Elements
Attributes
XML
Comments
CDATA
Sections
Character
and Entity References
XML
settings
XML processors
treat the character sequence Carriage Return-Line Feed (CRLF) like single CR or
LF characters. All are reported as a single LF character. Applications can save
documents using the appropriate line-ending convention.
Elements
XML documents must
contain one and only one root element
XML
Declaration
<?xml
version="1.0" encoding="UTF-8"?>
If used it must be the first line in the document and no other content or white space can precede it
Version
Declaration
The
version declaration is mandatory and the version number 1.0 is the latest
version currently
Encoding
Declaration
It
must contain a value representing an existing character encoding
Processing
Instructions
Processing
instructions do not have to follow much internal syntax, can include markup
characters without escaping them, and can appear anywhere in the document
outside of other markup. Processing instructions must begin with an identifier
called a target which is are case-sensitive.
Style Sheet
Processing Instructions
<?xml-stylesheet
type="type" href="uri" ?>
DOCTYPE
Declaration
<!DOCTYPE
rootElement PUBLIC "PublicIdentifier" "URIreference">
The
PublicIdentifier provides a separate identifier that some XML parsers can use to
reference the DTD in place of the URIreference. This is useful if the parser is
used on a system without a network connection or where that connection would
slow down processing significantly
XML
Comments
<!--
-->
Comments cannot be
nested
CDATA
Sections
<![CDATA[
]]>
Character
references do not work within CDATA sections.
CDATA
相关文档：
标签：数据访问 ADO.NET
ADO.NET DataSet中的XML支持 ADO.NET中XML支持主要集中于Da ......
using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
namespace System.Bwch.XmlConfig
{
/**////
/// 读取XML配置文件类
///
public class XmlHelper
{
private string strXmlPath = ""; //Xml文档路径
private XmlDocument xmlD ......
在针对XML文档的应用编程接口中，最主要的有W3C制定的DOM(Document Object Method，文档对象模型)和由David Megginson领导的SAX(SimpleAPI for XML，用于XML的简单API)[19]。
SAX和DOM在实现过程中，分别侧重于不同的方面以满足不同的应用需求。DOM为开发基于XML的应用系统提供了便利。它通过一种随机访问机制，使得应用程 ......
将Excel转化为XML。以Excel2003为例说明如何将数据导入MS SQL数据库
说先俺的系统配置：
系统：Windows Server 2003 R2 X64
开发软件：Microsoft VS 2008 Team
Office版本：Excel 2003 Excel2007
数据库：MS SQL 2008
5.1.1建立Excel XML 映射：数据格式见表。
现打算将『用户名称』，『客户联系人� ......
//获取数据库数据返回list
public List queryAll(int fcateId) {
List list = new ArrayList();
String sql = "select * from g_Account where fCateID=? order by fCode";
Connection con = SqlHelp.getConn();//获得连接，sqlhelp自己写的工具类
PreparedStatement pst = null;
ResultSet rs = null;
......
