.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
Ïà¹ØÎĵµ£º
×î½üÔÚ¹¤×÷ÖУ¬¾³£Éè¼Æ±¨±í£¨ireport+jasperReport£©·´¸´ºÍÉè¼ÆÄ£°åxml´ò½»µÀ£¬ÓÚÊǾÍÓÐÁËдÕâÆªÎÄÕµÄÏë·¨ÁË¡£java²Ù×÷xmlÖ÷ÒªÊÇÓÐËÄÖÖ·½Ê½£ºdom£¬sax£¬jdom£¬dom4j¡£ÕâËÄÖÖ·½Ê½¸÷ÓÐÓÅȱµã£º£¨ÒÔϱȽÏÊÇÀ´×ÔÍøÂ磩
1£ºDOM4JÐÔÄÜ×îºÃ£¬Á¬SunµÄJAXMÒ²ÔÚÓÃDOM4J.ĿǰÐí¶à¿ªÔ´ÏîÄ¿ÖдóÁ¿²ÉÓÃDOM4J£¬ÀýÈç´óÃû¶¦¶¦µÄHibernate ......
´ó¶àÊýä¯ÀÀÆ÷¶¼ÄÚ½¨Á˹©¶ÁÈ¡ºÍ²Ù×÷ XML µÄ XML ½âÎöÆ÷¡£
½âÎöÆ÷°Ñ XML ת»»Îª JavaScript ¿É´æÈ¡µÄ¶ÔÏó¡£
µ«ÊÇIEºÍÆäËüä¯ÀÀÆ÷ÊÇÓкܴóÇø±ðµÄ
½âÎö XML Îļþ - ¿çä¯ÀÀÆ÷ʵÏÖ
<html>
<body>
<mce:script type="text/javascript"><!--
try //Õë¶ÔIEºÍ»ùÓÚIEÄں˵Ää¯ÀÀÆ÷
{
xmlD ......
ÔÚSQL Server ÖвåÈëÒ»ÌõÊý¾ÝʹÓÃInsertÓï¾ä£¬µ«ÊÇÈç¹ûÏëÒªÅúÁ¿²åÈëÒ»¶ÑÊý¾ÝµÄ»°£¬Ñ»·Ê¹ÓÃInsert²»½öЧÂʵͣ¬¶øÇһᵼÖÂSQLһϵͳÐÔÄÜÎÊÌâ¡£ÏÂÃæ½éÉÜSQL ServerÖ§³ÖµÄÁ½ÖÖÅúÁ¿Êý¾Ý²åÈë·½·¨£ºBulkºÍ±íÖµ²ÎÊý(Table-Valued Parameters)¡£
ÔËÐÐÏÂÃæµÄ½Å±¾£¬½¨Á¢²âÊÔÊý¾Ý¿âºÍ±íÖµ²ÎÊý¡£
´úÂëÈçÏÂ:
--Create D ......
DOMÊÇ»ùÓÚÆ½Ì¨¡¢ÓïÑÔÎ޹صĹٷ½W3C±ê×¼¡£»ùÓÚÊ÷µÄ²ã´Î£¬ÆäÓŵãÊÇ¿ÉÒÔÒÆÖ²£¬±à³ÌÈÝÒ×£¬¿ª·¢ÈËÔ±Ö»ÐèÒªµ÷Óý¨Ê÷µÄÖ¸Áî¡£ÆäȱµãÊǼÓÔØ´óÎļþ²»ÀíÏë¡£
¡¡¡¡SAXÊÇ»ùÓÚʼþÄ£Ð͵ģ¬ËüÔÚ½âÎö XML ÎĵµµÄʱºò¿ÉÒÔ´¥·¢Ò»ÏµÁеÄʼþ£¬µ±·¢ÏÖ¸ø¶¨µÄtagµÄʱºò£¬Ëü¿ÉÒÔ¼¤»îÒ»¸ö»Øµ÷·½·¨£¬¸æË߸÷½·¨Öƶ¨µÄ±êÇ©ÒѾÕÒµ½¡£ÀàËÆÓëÁ÷ýÌåµÄ½ ......
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
ÒÔÉÏ´úÂëʵÏֵĹ¦Ä ......