DelphiÓëXMLÎĵµ
ͬ²½³ÌÐò°¸Àý
procedure TGetOrderThread.PostDB(webnr:WideString);
var
Err: String;
SetWebnr:WideString;
xmlDoc: IXMLDocument;
root: IXMLNode;
rowc: IXMLNode;//¼Ç¼Êý
rows: IXMLNodeList;//Ö÷¼Ç¼Áбí
row: IXMLNode;
drows: IXMLNodeList;//Ã÷ϸÁбí
drow: IXMLNode;
i,j,slhj,jlhj:integer;
djhj:real;
begin
//ͬ²½Êý¾Ý
xmlDoc := TXMLDocument.Create(nil);
try
xmlDoc.XML.Text:=Webnr;
xmlDoc.Active:=true;
root:=xmlDoc.DocumentElement;
rowc:=root.ChildNodes.FindNode('RowC');
if (rowc.NodeValue>0) and DBconn then
begin
rows:=root.ChildNodes.FindNode('RowS').ChildNodes;
//showmessage('¼Ç¼Êý:'+rowc.NodeValue);
for i:=0 to rows.Count-1 do
begin
ADOConn.BeginTrans;
try
row:=rows.Nodes[i];
drows:=row.ChildNodes.FindNode('Drows').ChildNodes;
//showmessage(row.ChildValues['billno']+
// ' Ã÷ϸ¼Ç¼Êý:'+inttostr(drows.Count));//ÏÔʾ¶©µ¥ºÅ
if SHelper.Active then SHelper.Close;
SHelper.SQL.Text:=Format(selectStr,[row.ChildValues['billno']]);
SHelper.Open;
jlhj:=0;
slhj:=0;
djhj:=0;
&nb
Ïà¹ØÎĵµ£º
¸öÈËÊÕ¼¯¡¢ÕûÀíÁËһЩLINQ TO XMLµÄ»ù±¾·½·¨£¬Ï£Íû¸÷λ´óϺ¶à¶àÖ¸µ¼£º
/// <summary>
///Xml½ÚµãÊôÐÔ
/// </summary>
public class XmlAttribute
{
public XmlAttribute()
{
}
public XmlAttribute(string _key,object _value)
&nbs ......
<%
'
Set http=Server.CreateObject("Microsoft.XMLHTTP")
http.Open "GET","http://127.0.0.1/1.xml",False
http.send
Dim xml
Set xml = Server.CreateObject("Microsoft.XMLDOM")
xml.async = False
'xml.load (Server.MapPath("1.xml"))¡¡'Èç¹û²»ÊÇÔ¶³ÌÎļþÖ±½ÓÕâÒ»²½
xml.Load(http.ResponseXML)
Dim t ......
ʹÓÃMetadata¼ò»¯±íÊý¾ÝÏòXMLÐÎʽת»¯µÄʵÏÖ
Èç¹ûÐèÒª½«±íÊý¾Ýת»¯ÎªXMLÐÎʽÊý¾ÝµÄ»°£¬Èç¹ûÎÒÃÇʹÓÃSpringµÄJDBC Template£¬ÄÇô³£ÐèÒª×öµÄ¹¤×÷ÊÇ´´½¨Ò»¸öRowMapperÄäÃûÀ࣬ÔÚÆäÖн«×Ö¶ÎÓëÁìÓò¶ÔÏóµÄij¸öÊôÐÔÆ¥ÅäÉÏ£¬È»ºóµÃµ½ÁìÓò¶ÔÏóÁ´±íÐÎʽµÄ½á¹û£¬´ËºóÕ¹¿ªÕâ¸ö¼¯ºÏ£¬ÔÙ½«×Ö¶Îת»¯ÎªXMLÊý¾Ý£¬ÆäÖнøÐÐÁËÁ½´ÎÃû³ÆºÍÖµÖ® ......
Ò»¡¢ ÍøÂç²¼¾Ö
һ̨ÖÐÐÄSQL·þÎñÆ÷£¨¼ò³Æ£ºÖÐÐÄ·þÎñÆ÷£©£¬¶ą̀·Ö²¼ÔÚ²»Í¬µØÓòµÄSQL·þÎñÆ÷£¨¼ò³Æ£º±¾µØ·þÎñÆ÷£©£¬¸÷¸ö±¾µØ·þÎñÆ÷ºÍÖÐÐÄ·þÎñÆ÷¶¼ÄÜͨ¹ýinternetʵÏÖÍøÂ绥Á¬¡£
¶þ¡¢ËùÓÃÓïÑÔ¼°Êý¾Ý¿â£ºDelphi +Sql
¶þ¡¢ ͨÐÅÒªÇó
ÿ̨±¾µØ·þÎñÆ ......