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/
相关文档：
JAXB概要
JAXB为Java Architecture for XML Binding的缩写，意为XML绑定的JAVA框架。它提供了一套可以简单存取XML数据的API，同时，JAXB可以根据XML的schema自动生成操作XML的JAVA类。利用JAXB，使用JAXB自动生成的操作XML的JAVA类，可以基本上不用考虑XML结构而简单地存取XML数据。
JAXB的下载与安装
JAXB至少需要导入� ......
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(@"E:\大二下\xml\province.xml");
会提示出现以下错误
http://hi.csdn.net/attachment/201005/24/0_1274703276Ld6I.gif
麻烦各位帮忙看看，谢谢了 ......
使用XmlDocument类完成对XML的查、删、添、改
http://www.aspdiy.net/article/53.htm
后台C#代码
1using System;
2using System.Collections;
3using System.ComponentModel;
4using System.Data;
5using System.Drawing;
6using System. ......
private void CreateNewXmlNode()
{
String strFileName = string.Empty;
strFileName = this.strCurrentPath + "System.xml";
XmlDocument xmlDoc = new XmlDocument();
try
{
xmlDoc.Load(strFileName);
......
红色字体为主要代码
jsp页面中
<script language="javascript">
function updateDB(operate){
var objDom=new ActiveXObject("msxml.DomDocument");
var objRoot=objDom.createElement("All");
objDom.appendChild(objRoot);
var k=document.ge ......
