CONVERT º¯Êý xmlת varchar µÄʹÓ÷½·¨ÇóÖú
ÈçϵØÖ·ÖУ¬fcuandy¸ø³öÁËÕýÈ·´ð°¸£º µÃµ½µÄ½á¹ûÊÇxml¸ñʽµÄ£¬ÏÖÐèҪת»»³Évarchar¡£ÇëÅóÓÑÃÇ°ïæ¡£
http://topic.csdn.net/u/20091215/15/eddfb230-9ee5-4019-a4a8-4374259863cb.html
{{ ......
ÎÒÊý¾Ý¿âͼƬ·ÅµÄÊÇblob×ֶΣ¬È¡³öÀ´ºó£¬ÒªÈýøxml ͨ¹ýwebservice´«µ½¿Í»§¶Ë£¬¿Í»§¶ËÔÚ½âÎö¡£·þÎñ¶ËºÍ¿Í»§¶ËÔõôд£¡
ÊÇÕâÑùÈ¡³öÀ´µÄ
while(rs.next())
{
Blob pic = rs.getBlob("LICENSE_PIC");
}
ÒÔʲôÐÎʽ´æÔÚxmlÖУ¬²¢ÇÒÔÚ½âÎö³öÀ´£¡
×Ö½Úת×Ö·û ×Ö·ûת×Ö½Ú
×Ö·ûºÍ×Ö½ ......
×¢ ÎÒÓõÄÊÇC#
ÎÒ×Ô¼ºÐ´ÁËÒ»¸öÀ࣬¹¦ÄÜÊǶÁÈ¡XMLÎļþÖеÄÖ¸¶¨½ÚµãµÄÖµ¡£
XMLÎļþÄÚÈÝÈçÏ£º
<?xml version="1.0" encoding="utf-8"?>
<Patients>
<Patients_virtue>
<ID>001 </ID>
<Last_Name> ......
<priceParameters>
<parameter Prop1="°×É«|FFFFFF" Prop2="3ÆÚ" Prop3="ÖйúÒøÐÐ" Prop4="XL> </parameter>
<parameter Prop2="3ÆÚ" Prop4="ÖйúÒøÐÐ"> </parameter>
<parameter Prop3="Ö ......
ÎÒÓÖÕâÑùÒ»¸ö
<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 ......
¸÷λ´óÏÀ£¬ÔÚÏÂÇë½ÌÒ»¸öÎÊÌ⣬Îʵõͼ¶Á˲»Òª¼ûЦ£¬ÎÒÓõÄÊÇspring2.5£¬À¨ºÅ£¬²»Ê죬ҵÎñ²ãµÄʵÏÖÒ»°ãÊÇÕâÑùдµÄ
public List <Object> checkLogin(User user)
{
String sql=" select * from `user` where loginname=? and password=? and `isdeleted`=0 ";
Object[] object={ user.getLogi ......