xml 形式的存储过程
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',
Orders.ID AS 'MachiningPayed/Order/@ID',
-- Task --
Orders.Task AS 'MachiningPayed/Order/Task/@ID',
Tasks.OrderState as 'MachiningPayed/Order/Task/OrderState',
Tasks.UpdateDate as 'MachiningPayed/Order/Task/UpdateDate',
Tasks.CustomerName as 'MachiningPayed/Order/Task/CustomerName',
Tasks.CustomerPhone as 'MachiningPayed/Order/Task/CustomerPhone',
Tasks.CellPhone as 'MachiningPayed/Order/Task/CellPhone',
Tasks.CustomerAddress as 'MachiningPayed/Order/Task/CustomerAddress',
Tasks.ForemanName as 'MachiningPayed/Order/Task/ForemanName',
Tasks.MonitorName as 'MachiningPayed/Order/Task/MonitorName',
Tasks.DesignerName as 'MachiningPayed/Order/Task/DesignerName',
Tasks.Store as 'MachiningPayed/Order/Task/Store',
Tasks.PactNumber as 'MachiningPayed/Order/Task/PactNumber',
Tasks.CreateDate as 'MachiningPayed/Order/Task/CreateDate',
Tasks.PlanDisclosureDate as 'MachiningPayed/Order/Task/PlanDisclosureDate',
Tasks.PlanHiddenCheckDate as 'MachiningPayed/Order/Task/PlanHiddenCheckDate',
Tasks.PlanMidCheckDate as 'MachiningPayed/Order/Task/PlanMidCheckDate',
Tasks.PlanEndCheckDate as 'MachiningPayed/Order/Task/PlanEndCheckDate',
-- Task End--
Orders.PactNumber AS 'MachiningPayed/Order/PactNumber',
Orders.CustomerName AS 'MachiningPayed/Order/CustomerName',
Orders.CustomerPhone AS 'MachiningPayed/Order/CustomerPhone',
Orders.CellPhone AS 'MachiningPayed/
相关文档：
一、简单介绍
using System.Xml;
//初始化一个xml实例
XmlDocument xml=new XmlDocument();
//导入指定xml文件
xml.Load(path);
xml.Load(HttpContext.Current.Server.MapPath("~/file/bookstore.xml"));
//指定一个节点
XmlNode root=xml.SelectSingleNode("/root");
//获取节点下所有直接子节点
XmlNodeList ......
最近工作内容需要对Java对象做XML输出，公司里常用的两种框架是XStream和XML Beans。两种都我都用了，对于普通的，schema不是很复杂的XML文件来说选择XStream更方便。这篇文章先介绍一下XStream的用法，XML Beans的用法另外再介绍。
1. 先给个要输出的xml文档的例子：
<students>
<student>
&l ......
XML开发入门基础：XML语法规则(2) - 网页设计专栏 - 编程入门网
http://www.bianceng.cn/web/XML/200911/11986_2.htm
字符 实体引用
> &n ......
通常情况下,在JAX-WS2.0中是利用JAXB将传入的SOAP XML消息转换成JAVA的object,然后调用对应porttype的JAVA类的相应的方法,在完成调用后,再通过JAXB将返回参数转成SOAP XML.
JAX-WS还提供了另一种方法,让我们可以直接操作SOAP XML,通过让对应porttype的JAVA类实现 Provider<Source>接口,当服务器端收到SOAP消息后,会� ......
本文总结了在Python中主要的几种处理XML的方法：
Element Tree
SAX
Dom
使用第三方类库如Amara 2.x， libxml2dom 等
Element Tree
Element Tree是Python 2.5引入的使用简单，快捷的处理方法， 也是Python标准类库推荐的处理XML的方法。
它使用树形节点的形式来读写XML。Element Tree是轻量级的DOM， 所以� ......
