ÇëÎÊ£º
1¡¢ÈçºÎÔÚDelphiÖУ¬°ÑÖ¸¶¨Îļþ±£´æµ½SQLÖУ¬SQL¶ÔÓ¦×Ö¶ÎÓÖÓ¦¸ÃÓÃʲôÀàÐͲűȽϺÏÊÊ£¿
2¡¢¶ÔÓÚ1²Ù×÷£¬ÈçºÎ°Ñ±£´æµ½SQLÖеÄÎļþ´ò¿ª£¿
3¡¢ÒÔÉÏÎļþÖ÷ÒªÕë¶ÔOffice£¨DOC¡¢XLSµÈ£©ÎļþÀàÐÍ£¬Í¼Æ¬£¨BMP¡¢JPGµÈ£©ÀàÐÍÁ½ÖÖ£¬Èç¹û»¹Äܹ»Õë¶ÔÆäËüÎļþÀàÐÍ£¨ÈçEXEµÈ£©¸üºÃ¡£
лл£¡
ÒÔºó·Ö²»¹»ÎÒ»áÔÙ¼Ó¡£
×¢ÒâÕâ¾ä£ºTblobField(TmpAdo.FieldByName('Content')).LoadfromFile(EdtFileDir.Text);
Äã¿ÉÒÔÓÃimageÀàÐͽøÐÐÎļþµÄ´æ·Å,ÒÔÎļþÁ÷ÐÎʽ,
È»ºó¶ÁÈ¡µÄʱºò,ÔÙ°ÑÎļþÁ÷תΪÎļþ±£´æ..
ÄÇ»¹²»Èç,Ö»±£´æÕâЩÎļþ¸úͼƬµÄµØÖ·
ÕâÑù¶ÁÈ¡¸ú±£´æ¸üÓÐЧÂÊ
ÒýÓà ÄÇ»¹²»Èç,Ö»±£´æÕâЩÎļþ¸úͼƬµÄµØÖ· ÕâÑù¶ÁÈ¡¸ú±£´æ¸üÓÐЧÂÊ Ì¸²»ÉÏʲôЧÂʸߣ¬±£´æµØÖ·´øÀ´µÄ×î´óÎÊÌ⣬¾ÍÊÇ·þÎñÆ÷µÄµØÖ·±ä¸ü£¬ÒªÁ¬Í¬ËùÓеÄÎļþÒ»Æð°áǨ£¬²»¹ýÔÚ¾Û¶àµÄÎļþÊýÁ¿Çé¿öÏ£¬ÊÇ¿ÉÒÔ²ÉÓñ£´æµØÖ·µÄ·½·¨µÄ
¶à¼ÓÒ»¸ö×Ö¶ÎExtName±£´æÎļþÀàÐ;ÍÐÐÀ²
ÄÇÄã·þÎñ¶ËµÄÎļþ¾Í±ð»»Â·¾¶ÁË£¬
ÒýÓà ÒýÓà 5 Â¥ lgxyz µÄ»Ø¸´: ÄÇ»¹²»Èç,Ö»±£´æÕâЩÎļþ¸úͼƬµÄµØÖ· ÕâÑù¶ÁÈ¡¸ú±£´æ¸üÓÐЧÂÊ Ì¸²»ÉÏʲôЧÂʸߣ¬±£´æµØÖ·´øÀ´µÄ×î´óÎÊÌ⣬¾ÍÊÇ·þÎñÆ÷µÄµØÖ·±ä¸ü£¬ÒªÁ¬Í¬ËùÓеÄÎļþÒ»Æð°áǨ£¬²»¹ýÔÚ¾Û¶àµÄÎļþÊýÁ¿Çé¿öÏ£¬ÊÇ¿ÉÒÔ²ÉÓñ£´æµØÖ·µÄ·½·¨µÄ ÄãÊý¾Ý¶¼Òª°áǨºÎÀ´Îļþ²»ÐèÒª°áǨÄØ£¿
Êý¾Ý¿â´æµÄÖ»ÊÇÎļþÏà¶ÔµØÖ·
È»ºóÔÚ´æÎļþ·þÎñÆ÷£¨¿ÉÒÔÊÇÓëÊý¾Ý¿âͬһ·þÎñÆ÷£©×ÔÒÑÔÙдһ¸ö½ÓÊÕ/·¢ËÍÎļþµÄ·þÎñ³ÌÐò¾ÍÐÐÁË
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
with adod_dict do begin close; commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿ 21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30 Ö¸µ ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿ try { connection.connect() return true; } catch() { return false; } Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£ ÒýÓà try { connection.connect( ......
ÎÒÏëʹÓÃSql±à¸öС³ÌÐò£¬¾ÍÊÇÅж¨Ò»¸ö×Ö·û´®³öÏÖÁ˼¸´ÎÖ¸¶¨×Ö·û£» ÀýÈçÔÚstringÐÍ¡°6+4+8+2¡±ÖУ¬ÎÒÐèÒªÅж¨³öÏÖÁ˼¸¸ö¡°+¡±£»²¢ÇÒʵÏÖ if £¨³öÏÖ3´Î£© then ¡¡¡¡¡¡£¨Òý·¢Ê¼þ£©£» ......