Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

.NET SQLServer2005 XML×Ö¶Î

//ÕâÊÇÌí¼Ó 
private void button1_Click(object sender, EventArgs e)
        {
            string s = "Persist Security Info=False;Integrated Security=SSPI;database=IIntegration;server=(local)";
            using (SqlConnection conn = new SqlConnection(s))
            {
                using (SqlCommand cmd1 = new SqlCommand("INSERT testxml VALUES(@ID, @XmlData)", conn))
                {
                    conn.Open();
                    cmd1.Parameters.Add("@ID", SqlDbType.Int, 4);
                    cmd1.Parameters[0].Value = 2;
                    cmd1.Parameters.Add("@XmlData", SqlDbType.Xml);
                    cmd1.Parameters[1].Value = GetXmlData();
                    cmd1.ExecuteNonQuery();
                 
                }
            }
        }
     &nbs


Ïà¹ØÎĵµ£º

java²Ù×÷xml£¨sax£¬dom£¬jdom£¬dom4j£©Ôöɾ¸Ä²é

×î½üÔÚ¹¤×÷ÖУ¬¾­³£Éè¼Æ±¨±í£¨ireport+jasperReport£©·´¸´ºÍÉè¼ÆÄ£°åxml´ò½»µÀ£¬ÓÚÊǾÍÓÐÁËдÕâÆªÎÄÕµÄÏë·¨ÁË¡£java²Ù×÷xmlÖ÷ÒªÊÇÓÐËÄÖÖ·½Ê½£ºdom£¬sax£¬jdom£¬dom4j¡£ÕâËÄÖÖ·½Ê½¸÷ÓÐÓÅȱµã£º£¨ÒÔϱȽÏÊÇÀ´×ÔÍøÂ磩
1£ºDOM4JÐÔÄÜ×îºÃ£¬Á¬SunµÄJAXMÒ²ÔÚÓÃDOM4J.ĿǰÐí¶à¿ªÔ´ÏîÄ¿ÖдóÁ¿²ÉÓÃDOM4J£¬ÀýÈç´óÃû¶¦¶¦µÄHibernate ......

JS½âÎöXMLÎļþºÍ×Ö·û´®µÄ¿çä¯ÀÀÆ÷ʵÏÖ


´ó¶àÊýä¯ÀÀÆ÷¶¼ÄÚ½¨Á˹©¶ÁÈ¡ºÍ²Ù×÷ XML µÄ XML ½âÎöÆ÷¡£
½âÎöÆ÷°Ñ XML ת»»Îª JavaScript ¿É´æÈ¡µÄ¶ÔÏó¡£
µ«ÊÇIEºÍÆäËüä¯ÀÀÆ÷ÊÇÓкܴóÇø±ðµÄ
½âÎö XML Îļþ - ¿çä¯ÀÀÆ÷ʵÏÖ
<html>
<body>
<mce:script type="text/javascript"><!--
try //Õë¶ÔIEºÍ»ùÓÚIEÄں˵Ää¯ÀÀÆ÷
{
xmlD ......

[SQL Server]SQLServer ÅúÁ¿²åÈëÊý¾ÝµÄÁ½ÖÖ·½·¨

ÔÚSQL Server ÖвåÈëÒ»ÌõÊý¾ÝʹÓÃInsertÓï¾ä£¬µ«ÊÇÈç¹ûÏëÒªÅúÁ¿²åÈëÒ»¶ÑÊý¾ÝµÄ»°£¬Ñ­»·Ê¹ÓÃInsert²»½öЧÂʵͣ¬¶øÇһᵼÖÂSQLһϵͳÐÔÄÜÎÊÌâ¡£ÏÂÃæ½éÉÜSQL ServerÖ§³ÖµÄÁ½ÖÖÅúÁ¿Êý¾Ý²åÈë·½·¨£ºBulkºÍ±íÖµ²ÎÊý(Table-Valued Parameters)¡£
   ÔËÐÐÏÂÃæµÄ½Å±¾£¬½¨Á¢²âÊÔÊý¾Ý¿âºÍ±íÖµ²ÎÊý¡£
´úÂëÈçÏÂ:
--Create D ......

JavaÖÐËÄÖÖXML½âÎö¼¼Êõ

DOMÊÇ»ùÓÚÆ½Ì¨¡¢ÓïÑÔÎ޹صĹٷ½W3C±ê×¼¡£»ùÓÚÊ÷µÄ²ã´Î£¬ÆäÓŵãÊÇ¿ÉÒÔÒÆÖ²£¬±à³ÌÈÝÒ×£¬¿ª·¢ÈËÔ±Ö»ÐèÒªµ÷Óý¨Ê÷µÄÖ¸Áî¡£ÆäȱµãÊǼÓÔØ´óÎļþ²»ÀíÏë¡£
¡¡¡¡SAXÊÇ»ùÓÚʼþÄ£Ð͵ģ¬ËüÔÚ½âÎö XML ÎĵµµÄʱºò¿ÉÒÔ´¥·¢Ò»ÏµÁеÄʼþ£¬µ±·¢ÏÖ¸ø¶¨µÄtagµÄʱºò£¬Ëü¿ÉÒÔ¼¤»îÒ»¸ö»Øµ÷·½·¨£¬¸æË߸÷½·¨Öƶ¨µÄ±êÇ©ÒѾ­ÕÒµ½¡£ÀàËÆÓëÁ÷ýÌåµÄ½ ......

SqlServer ʵÏÖÈÕÆÚ²»Í¬¸ñʽµÄת»»£¡£¡

select
convert(char(4),auth,120)+'Äê'+
substring(convert(char(10),auth,120),6,2)+'ÔÂ'+
substring(convert(char(10),auth,120),9,2)+'ÈÕ',
convert(char(4),appr,120)+'Äê'+
substring(convert(char(10),appr,120),6,2)+'ÔÂ'+
substring(convert(char(10),appr,120),9,2)+'ÈÕ'
from a

ÒÔÉÏ´úÂëʵÏֵĹ¦Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ