SQL Server2005 xml×Ö¶ÎʹÓ÷½·¨ 1¶Ô¶à±í¼Ç¼¶ÁÈ¡
ÔÚSQL Server2005ÖÐÓÐFOR XML Ó÷¨£¬¿ÉÒÔ½²Ò»¸ö±í×÷Ϊһ¸ö×ֶΡ£
ÎÒµÄÉè¼ÆÏë·¨Ö÷ÒªÊÇÓÃÔÚ1¶Ô¶àµÄ¹ØϵÖбí¶ÁÈ¡µÄÎÊÌâ¡£
±íA ±íB
ÔÚAÖÐÓÐÒ»Ìõ¼Ç¼¶øÔÚBÖÐÓжàÌõ¼Ç¼¿ÉÒÔ²ÎÕÕÏÂÃæµÄд·¨£º£¨ÎÒµÄÏîÄ¿ÖÐÓõ½µÄ£¬ÐÞ¸ÄÁË×Ö¶ÎÖ÷ÒªÊÇÑÝʾÓã©
select A.*,
(SELECT a, CAST(G_Univalence AS NVARCHAR(48)) AS G_Univalence,
--×¢ÒâÁôÏÂËûµÄÒâÒåÖ»ÊÇmoney×Ö¶ÎÔÚfor xmlÖÐËü²ÉÓÿÆѧ¼ÆÊý·¨ÏÔʾ,ÔÚÓ¦ÓÃÖв»ºÃ´¦Àí
from B WHERE B.CB_ID = A.BP_ID FOR XML RAW,TYPE,ROOT('GrainConstraint')) AS GrainConstraint
--ʹÓÃTYPE·µ»Ø xml×Ö¶ÎÀàÐÍ
from A
ÔÚºǫ́£¬Ê¹ÓÃSqlDataReader¶ÁÈ¡xml×Ö¶Î,GetSqlXml()£¬²ÎÕÕÏÂÃæµÄ´úÂë.
public static bool ToDataTable(SqlXml sxSource, DataTable dt)
{
XmlReader xmlReader = sxSource.CreateReader();
string tempName;
int nColumnIndex;
Type type;
while (xmlReader.Read()) //ÿ´ÎÑ»·1Ìõ¼Ç¼
{
switch (xmlReader.NodeType)
{
case XmlNodeType.Element:
if (xmlReader.LocalName == "row")
{
&n
Ïà¹ØÎĵµ£º
string file = "c:\\work.xml";
private void btnCearte_Click(object sender, EventArgs e)
{
XmlDocument doc = new XmlDocument();
  ......
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.input.SAXBuilder;
import org.jdom.output.XMLOutputter;
£¨1£©Ê¹ÓÃJDOMÊ×ÏÈÒªÖ¸¶¨Ê¹ÓÃʲô½âÎöÆ÷¡£È磺
SAXBuilder builder=new SAXBuilder(false) ......
ʲôÊÇ XML?
XML Ö¸¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨EXtensible Markup Language£©
XML ÊÇÒ»ÖÖ±ê¼ÇÓïÑÔ£¬ºÜÀàËÆ HTML
XML µÄÉè¼Æ×ÚÖ¼ÊÇ´«ÊäÊý¾Ý£¬¶ø·ÇÏÔʾÊý¾Ý
XML ±êǩûÓб»Ô¤¶¨Òå¡£ÄúÐèÒª×ÔÐж¨Òå±êÇ©¡£
XML ±»Éè¼ÆΪ¾ßÓÐ×ÔÎÒÃèÊöÐÔ¡£
XML ÊÇ W3C µÄÍƼö±ê×¼
XML Óë HTML µÄÖ÷Òª²îÒì
XML ²»ÊÇ HTML µÄÌæ´ú¡£
XML ºÍ HTML Ϊ² ......
2009-12-19¿¼ÁËCETÓ¢ÓÐÄÇéºÜ²î£¬¹À¼ÆÓÖ²»¹ýµÄ£¬°¥£¡Ó¢ÎIJ
ÓÚÊÇ¿´¿´Ê飬¿´¿´×Ô¼º¸ÐÐËȤµÄÊé
½ñÌìÏÂÎ磬Ñо¿ÁËÕû¸öÏÂÎçµÄСÄÑÌ⣬ÔÚ8µã40·ÖÖÕÓڸ㶨ÁË£¡¶Ç×Ó¶ö£¬»¹Ã»³Ô·¹£¬»¹Ã»Ï´Ô裬¿Ë·þÁËÒ»¸ö²»¶®µÄСÄÑÌ⣬ÐÄÀíÓеãÌå»á£¬ÏëÔÚÕâÀïÁôµã¼ÍÄ·½±ã±ðÈËÒÔºóѧϰ¡£ÓÚÊǺõ£¬ÎÒдÁË£º
£¨ÄÇЩ¿ªÑµÁ·Æ÷µÄÏà¹Ø½éÉÜÎҾͲ»ÔÙ ......
ºÃ½Ó“OpenCVѵÁ··ÖÀàÆ÷ÖÆ×÷xmlÎĵµÖ®Ò»”
Á˽âÁË´´½¨º¯ÊýµÄÃüÁîÐвÎÊý
ÏÖÔÚÎÒÃǶÔÕýÑù±¾¾Ù¸öÀý×Ó£º
¼ÙÉèÓÐ5 ¸öÕýÑù±¾Í¼Æ¬Îļþimg1.bmp,…img5.bmp;´´½¨Ò»¸öÕýÑù±¾µÄtxtÎı¾Îĵµ£¬Ãû×ÖΪ info.txt
ÕýÑù±¾ÃèÊöÎļþinfo.txt µÄÄÚÈÝÈçÏÂ
positive/image1.bmp 1 0 0 24 28
positive/image2.bmp 1 0 0 24 ......