Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : xml

CONVERT º¯Êý xmlת varchar µÄʹÓ÷½·¨ÇóÖú

CONVERT º¯Êý  xmlת varchar µÄʹÓ÷½·¨ÇóÖú

ÈçϵØÖ·ÖУ¬fcuandy¸ø³öÁËÕýÈ·´ð°¸£º µÃµ½µÄ½á¹ûÊÇxml¸ñʽµÄ£¬ÏÖÐèҪת»»³Évarchar¡£ÇëÅóÓÑÃÇ°ïæ¡£

http://topic.csdn.net/u/20091215/15/eddfb230-9ee5-4019-a4a8-4374259863cb.html


{{ ......

xml ´«Í¼Æ¬ÎÊÌ⣨¼±£¬ÔÚÏߵȣ©

ÎÒÊý¾Ý¿âͼƬ·ÅµÄÊÇblob×ֶΣ¬È¡³öÀ´ºó£¬ÒªÈýøxml ͨ¹ýwebservice´«µ½¿Í»§¶Ë£¬¿Í»§¶ËÔÚ½âÎö¡£·þÎñ¶ËºÍ¿Í»§¶ËÔõôд£¡
ÊÇÕâÑùÈ¡³öÀ´µÄ
while(rs.next())

{
Blob pic = rs.getBlob("LICENSE_PIC");
}
ÒÔʲôÐÎʽ´æÔÚxmlÖУ¬²¢ÇÒÔÚ½âÎö³öÀ´£¡

×Ö½Úת×Ö·û ×Ö·ûת×Ö½Ú

×Ö·ûºÍ×Ö½ ......

C# ÔõÑù¶ÁÈ¡XMLÎļþÖеÄÖ¸¶¨Öµ

×¢ ÎÒÓõÄÊÇC#

ÎÒ×Ô¼ºÐ´ÁËÒ»¸öÀ࣬¹¦ÄÜÊǶÁÈ¡XMLÎļþÖеÄÖ¸¶¨½ÚµãµÄÖµ¡£
XMLÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="utf-8"?>
<Patients>
  <Patients_virtue>
    <ID>001 </ID>
    <Last_Name> ......

¹ØÓÚxmlµÄ½âÎö

<priceParameters>
<parameter Prop1="°×É«|FFFFFF" Prop2="3ÆÚ" Prop3="ÖйúÒøÐÐ" Prop4="XL> </parameter>
    <parameter Prop2="3ÆÚ" Prop4="ÖйúÒøÐÐ"> </parameter>
<parameter Prop3="Ö ......

²Ù×÷XMLµÄÎÊÌâÔÚÏßµÈ

ÎÒÓÖÕâÑùÒ»¸ö
<cun>
  <node month="2009-10" mytime="2009-10-11"/>
  <node month="2009-10" mytime="2009-10-11"/>
  <node month="2009-10" mytime="2009-10-23"/>
  <node mon ......

sqlÓï¾äÈçºÎ·Åµ½xml spring2.5

¸÷λ´óÏÀ£¬ÔÚÏÂÇë½ÌÒ»¸öÎÊÌ⣬Îʵõͼ¶Á˲»Òª¼ûЦ£¬ÎÒÓõÄÊÇspring2.5£¬À¨ºÅ£¬²»Ê죬ҵÎñ²ãµÄʵÏÖÒ»°ãÊÇÕâÑùдµÄ
public List <Object> checkLogin(User user)
{
String sql=" select * from `user` where loginname=? and password=? and `isdeleted`=0 ";
Object[] object={ user.getLogi ......
×ܼǼÊý:834; ×ÜÒ³Êý:139; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [108] [109] [110] [111] 112 [113] [114] [115] [116] [117]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ