ת×Ô½±ß¹ÂÄñ: http://blog.csdn.net/jbgh608/archive/2007/08/31/1767414.aspx
W3school µÄxsl½Ì³Ì£º http://www.w3school.com.cn/xsl/index.asp
²úÆ·¼¸ÄêǰʹÓÃASP£¬ºóÀ´Éý¼¶µ½.Net 1.1£¬ÔÙÉý¼¶µ½2.0£¬Ò»Ö±¶¼ÓÐÓÃXSLTת»»XMLÉú³ÉÍøÒ³µÄ·½Ê½£¬ÉÔ΢ÕûÀíÏ¡£
XML file:
<?xml version="1.0" encoding="utf-8" ?>
<ric>
<catalog>
<book price="75">
<author>Kalen Delaney</author>
<name>Inside SQL Server 2000</name>
</book>
<book price="200">
<author>Ken Henderson</author>
<name>The Guru's Guide to SQL Server Architecture</name>
</book>
</catalog>
& ......
ͨ¹ýxslת»»´óxmlÎļþ
Õ⼸ÌìÔÚ×öÕâ¸ö£¬ÍøÉϵļ¸¸ö·½·¨ÎÒ¶¼ÊÔ¹ýÁË£¬»ã×ÜÈçÏÂ
·½·¨Ò»£º
XPathDocument myXPathDoc = new XPathDocument(tbXMLFile.Text);
XslCompiledTransform myXslTrans = new XslCompiledTransform();
myXslTrans.Load(tbXSLFile.Text);
XmlTextWriter myWriter = new XmlTextWriter("toSolrXML.xml", null);
myWriter.Formatting = Formatting.Indented;
myXslTrans.Transform(myXPathDoc, null, myWriter);
ÕâÖÖ·½·¨¿ÉÒԺܺõÄת»»xmlÎļþ£¬µ«ÊÇת»»´óxmlÎļþʱ¾ÍÎÞÄÜΪÁ¦ÁË£¬ÎÒת55mbµÄxmlʱ£¬±¨ÄÚ´æ´íÎó¡£
·½·¨¶þ£º
MSXML2.DOMDocument xmldoc = new DOMDocument();
xmldoc.async = false;
xmldoc.preserveWhiteSpace = true;
xmldoc.load(tbXMLFile.Text);
MSXML2.DOMDocument xsldoc = new DOMDocument();
xsldoc.async = false;
xsldoc.load(tbXSLFile.Text);
MSXML2.DOMDocument result = new DOMDocument();
result.async = false;
result.preserveWhiteSpace = true;
xmldoc.transformNodeToObject(xsldoc, result);
result.save("toSolrXML.xml");
ÕâÖÖ·½·¨¿ÉÒ ......
ͨ¹ýxslת»»´óxmlÎļþ
Õ⼸ÌìÔÚ×öÕâ¸ö£¬ÍøÉϵļ¸¸ö·½·¨ÎÒ¶¼ÊÔ¹ýÁË£¬»ã×ÜÈçÏÂ
·½·¨Ò»£º
XPathDocument myXPathDoc = new XPathDocument(tbXMLFile.Text);
XslCompiledTransform myXslTrans = new XslCompiledTransform();
myXslTrans.Load(tbXSLFile.Text);
XmlTextWriter myWriter = new XmlTextWriter("toSolrXML.xml", null);
myWriter.Formatting = Formatting.Indented;
myXslTrans.Transform(myXPathDoc, null, myWriter);
ÕâÖÖ·½·¨¿ÉÒԺܺõÄת»»xmlÎļþ£¬µ«ÊÇת»»´óxmlÎļþʱ¾ÍÎÞÄÜΪÁ¦ÁË£¬ÎÒת55mbµÄxmlʱ£¬±¨ÄÚ´æ´íÎó¡£
·½·¨¶þ£º
MSXML2.DOMDocument xmldoc = new DOMDocument();
xmldoc.async = false;
xmldoc.preserveWhiteSpace = true;
xmldoc.load(tbXMLFile.Text);
MSXML2.DOMDocument xsldoc = new DOMDocument();
xsldoc.async = false;
xsldoc.load(tbXSLFile.Text);
MSXML2.DOMDocument result = new DOMDocument();
result.async = false;
result.preserveWhiteSpace = true;
xmldoc.transformNodeToObject(xsldoc, result);
result.save("toSolrXML.xml");
ÕâÖÖ·½·¨¿ÉÒ ......
XmlDocument doc = new XmlDocument();
XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", "GB2312", null);
doc.AppendChild(dec);
//´´½¨Ò»¸ö¸ù½Úµã£¨Ò»¼¶£©
XmlElement root = doc.CreateElement("First");
doc.AppendChild(root);
//´´½¨½Úµã£¨¶þ¼¶£©
XmlNode node = doc.CreateElement("Seconde");
//´´½¨½Úµã£¨Èý¼¶£©
XmlElement element1 = doc.CreateElement("Third1");
element1.SetAttribute("Name", "Sam");
element1.SetAttribute("ID", "665");
element1.InnerText = "Sam Comment";
node.AppendChild(element1);
XmlElement element2 = doc.CreateElement("Third2");
element2.SetAttribute("Name", "Round");
element2.SetAttribute("ID", "678");
element2.InnerText = "Round Comment";
node.AppendChild(element2);
root.AppendChild(node);
doc.Save(@"E:\bb.xml");
Console.Write(doc.OuterXml); ......
XmlDocument doc = new XmlDocument();
XmlDeclaration dec = doc.CreateXmlDeclaration("1.0", "GB2312", null);
doc.AppendChild(dec);
//´´½¨Ò»¸ö¸ù½Úµã£¨Ò»¼¶£©
XmlElement root = doc.CreateElement("First");
doc.AppendChild(root);
//´´½¨½Úµã£¨¶þ¼¶£©
XmlNode node = doc.CreateElement("Seconde");
//´´½¨½Úµã£¨Èý¼¶£©
XmlElement element1 = doc.CreateElement("Third1");
element1.SetAttribute("Name", "Sam");
element1.SetAttribute("ID", "665");
element1.InnerText = "Sam Comment";
node.AppendChild(element1);
XmlElement element2 = doc.CreateElement("Third2");
element2.SetAttribute("Name", "Round");
element2.SetAttribute("ID", "678");
element2.InnerText = "Round Comment";
node.AppendChild(element2);
root.AppendChild(node);
doc.Save(@"E:\bb.xml");
Console.Write(doc.OuterXml); ......
ÔÚ¿ª·¢ÏµÍ³Ê±£¬ÎÒÃǾ³£»áʹÓõ½xmlÃèÊöµÄÎļþ£¬ÎÒÃÇ»ù±¾²ÉÓÃÈçϼ¸ÖÖ·½Ê½½øÐнâÎö£º
1dom
DOM ÊÇÓÃÓëƽ̨ºÍÓïÑÔÎ޹صķ½Ê½±íʾ XML ÎĵµµÄ¹Ù·½ W3C ±ê×¼¡£DOM ÊÇÒÔ²ã´Î½á¹¹×éÖ¯µÄ½Úµã»òÐÅϢƬ¶ÏµÄ¼¯ºÏ¡£Õâ¸ö²ã´Î½á¹¹ÔÊÐí¿ª·¢ÈËÔ±ÔÚÊ÷ÖÐÑ°ÕÒÌض¨ÐÅÏ¢¡£·ÖÎö¸Ã½á¹¹Í¨³£ÐèÒª¼ÓÔØÕû¸öÎĵµºÍ¹¹Ôì²ã´Î½á¹¹£¬È»ºó²ÅÄÜ×öÈκι¤×÷¡£ÓÉÓÚËüÊÇ»ùÓÚÐÅÏ¢²ã´ÎµÄ£¬Òò¶ø DOM ±»ÈÏΪÊÇ»ùÓÚÊ÷»ò»ùÓÚ¶ÔÏóµÄ¡£DOM ÒÔ¼°¹ãÒåµÄ»ùÓÚÊ÷µÄ´¦Àí¾ßÓм¸¸öÓŵ㡣Ê×ÏÈ£¬ÓÉÓÚÊ÷ÔÚÄÚ´æÖÐÊdz־õģ¬Òò´Ë¿ÉÒÔÐÞ¸ÄËüÒÔ±ãÓ¦ÓóÌÐòÄܶÔÊý¾ÝºÍ½á¹¹×÷³ö¸ü¸Ä¡£Ëü»¹¿ÉÒÔÔÚÈκÎʱºòÔÚÊ÷ÖÐÉÏϵ¼º½£¬¶ø²»ÊÇÏñ SAX ÄÇÑùÊÇÒ»´ÎÐԵĴ¦Àí¡£DOM ʹÓÃÆðÀ´Ò²Òª¼òµ¥µÃ¶à¡£
¡¡¡¡ÁíÒ»·½Ã棬¶ÔÓÚÌرð´óµÄÎĵµ£¬½âÎöºÍ¼ÓÔØÕû¸öÎĵµ¿ÉÄܺÜÂýÇҺܺÄ×ÊÔ´£¬Òò´ËʹÓÃÆäËûÊÖ¶ÎÀ´´¦ÀíÕâÑùµÄÊý¾Ý»á¸üºÃ¡£ÕâЩ»ùÓÚʼþµÄÄ£ÐÍ£¬±ÈÈç SAX¡£
¡¡¡¡BeanÎļþ£º
¡¡¡¡package com.test;
¡¡¡¡import java.io.*;
¡¡¡¡import java.util.*;
¡¡¡¡import org.w3c.dom.*;
¡¡¡¡import javax.xml.parsers.*;
¡¡¡¡public class MyXMLReader{
¡¡¡¡public static void main(String arge[]){
¡¡¡¡long lasting =System.currentTi ......
×î³£¼ûµÄXMLÊý¾ÝÀàÐÍÓУºElement, Attribute£¬Comment, Text.
Element, Ö¸ÐÎÈç<Name>Tom<Name>µÄ½Úµã¡£Ëü¿ÉÒÔ°üÀ¨£ºElement, Text, Comment, ProcessingInstruction, CDATA, and EntityReference.
Attribute, Ö¸ÔÚ<Employee id=”12345”>ÖеĴÖÌ岿·Ö¡£
Comment£¬Ö¸ÐÎÈ磺<!-- my comment --> µÄ½Úµã¡£
Text£¬Ö¸ÔÚ<Name>Tom<Name>µÄ´ÖÌ岿·Ö¡£
ÔÚXMLÖУ¬¿ÉÒÔÓÃXmlNode¶ÔÏóÀ´²ÎÕÕ¸÷ÖÖXMLÊý¾ÝÀàÐÍ¡£
2.1 ²éѯÒÑÖª¾ø¶Ô·¾¶µÄ½Úµã£¨¼¯£©
objNodeList = objDoc.SelectNodes(“Company/Department/Employees/Employee”)
»òÕß
objNodeList = objNode.SelectNodes(“/Company/Department/Employees/Employee”)
ÒÔÉÏÁ½ÖÖ·½·¨¿É·µ»ØÒ»¸öNodeList¶ÔÏó£¬Èç¹ûÒª·µ»Øµ¥¸ö½Úµã¿ÉʹÓÃSelectSingleNode·½·¨£¬¸Ã·½·¨Èç¹û²éѯµ½Ò»¸ö»ò¶à¸ö½Úµã£¬·µ»ØµÚÒ»¸ö½Úµã£»Èç¹ûûÓвéѯµÄÈκνڵ㷵»Ø Nothing¡£ÀýÈ磺
objNode = objNode.SelectSingleNode(“/Co ......
Ö÷Ìâ
±¾ OBE ½Ì³Ì°üÀ¨ÏÂÁÐÖ÷Ì⣺
¸ÅÊö
Çé¾°
Ñé֤ǰÌáÌõ¼þ
ÔÚ ODI ÖÐн¨ÏîÄ¿
Ϊ XML Îļþ²åÈëÐÂÄ£ÐÍ
ΪÊý¾Ý¿â±í CLIENT ²åÈëÄ£ÐÍ
ɾ³ý CITY_CLIENT µÄÔ¼Êø¸±±¾
ÔÚ CLIENT Êý¾Ý´æ´¢ÉÏÉèÖà ODI Ô¼Êø
µ¼Èë֪ʶģ¿é
´´½¨ÓÃÓÚ¼ÓÔØ XML ÎļþµÄнӿÚ
Ö´ÐгÌÐò°ü²¢²âÊÔ½á¹û
²é¿´½Ó¿ÚÖ´ÐеÄÔ¼Êø´íÎó
×ܽá
Ïà¹ØÐÅÏ¢
²é¿´ÆÁÄ»½Øͼ
½«Êó±êÖÃÓÚ´Ëͼ±êÉÏÒÔ¼ÓÔغͲ鿴±¾½Ì³ÌµÄËùÓÐÆÁÄ»½Øͼ¡££¨¾¯¸æ£º´Ë²Ù×÷»áͬʱ¼ÓÔØËùÓÐÆÁÄ»½Øͼ£¬ÍøËÙ½ÏÂýʱ£¬ÏìӦʱ¼ä¿ÉÄÜ»á±È½Ï³¤¡££©
×¢£º´ËÍ⣬Äú»¹¿ÉÒÔÔÚÏÂÁв½ÖèÖн«Êó±ê·ÅÔÚÿ¸öµ¥¶ÀµÄͼ±êÉÏ£¬´Ó¶ø½ö¼ÓÔغͲ鿴Óë¸Ã²½ÖèÏà¹ØµÄÆÁÄ»½Øͼ¡£
ÕâЩÆÁÄ»½Øͼ²»ÄÜ·´Ó³Óû§µÄ¾ßÌå»·¾³¡£Ö»ÊÇ˵Ã÷ÈçºÎÔÚ Oracle Data Integrator ÖÐÕÒµ½Ìض¨¹¦ÄÜ¡£
¸ÅÊö
Oracle Data Integrator Äܹ»ÔÚʹÓà ODI Ô¼Êø»òÊý¾Ý¿âÔ¼Êø¼ÓÔص½Ä¿±êÆÚ¼äÑéÖ¤Êý¾Ý¡£Ê¹ÓÃÁ÷¿ØÖƸù¾ÝÔ¼Êø¼ì²éÕâЩÊý¾Ýʱ£¬·¢ÏÖµÄÈκδíÎ󶼲»»á¼ÓÔص½Ä¿±ê£¬¶øÊǼÓÔص½ÓÉ ODI ´´½¨²¢¹ÜÀíµÄ´íÎó±í¡£¸Ã±íµÄÿһÐдú±íÒ»Ìõδͨ¹ýÔ¼ÊøµÄ¼Ç¼£¬ÆäÖаüÀ¨¼Ç¼ÊܾÜÔÒòµÄÏûÏ¢ÁС£
¸Ã±íµÄ±à¼¿ÉÔÚ ODI Designer ÄÚ½øÐлòÓÉÆäËûÈκοɱ༹Øϵ±íµÄ¹¤¾ß½øÐС£È»¶ø£¬¶Ô×îÖÕÓû§»òÒµÎñÓû§¶øÑÔ£¬Õâ²¢·Ç ......