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

DelphiÓëSQLµÄÎļþ´æÈ¡ÎÊÌâ

ÇëÎÊ£º
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 µÄ»Ø¸´:
ÄÇ»¹²»Èç,Ö»±£´æÕâЩÎļþ¸úͼƬµÄµØÖ·
ÕâÑù¶ÁÈ¡¸ú±£´æ¸üÓÐЧÂÊ

̸²»ÉÏʲôЧÂʸߣ¬±£´æµØÖ·´øÀ´µÄ×î´óÎÊÌ⣬¾ÍÊÇ·þÎñÆ÷µÄµØÖ·±ä¸ü£¬ÒªÁ¬Í¬ËùÓеÄÎļþÒ»Æð°áǨ£¬²»¹ýÔÚ¾Û¶àµÄÎļþÊýÁ¿Çé¿öÏ£¬ÊÇ¿ÉÒÔ²ÉÓñ£´æµØÖ·µÄ·½·¨µÄ


ÄãÊý¾Ý¶¼Òª°áǨºÎÀ´Îļþ²»ÐèÒª°áǨÄØ£¿

Êý¾Ý¿â´æµÄÖ»ÊÇÎļþÏà¶ÔµØÖ·

È»ºóÔÚ´æÎļþ·þÎñÆ÷£¨¿ÉÒÔÊÇÓëÊý¾Ý¿âͬһ·þÎñÆ÷£©×ÔÒÑÔÙдһ¸ö½ÓÊÕ/·¢ËÍÎļþµÄ·þÎñ³ÌÐò¾ÍÐÐÁË


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

¹ØÓÚgroup byµÄsqlÓï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ï棡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεĻ°¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......

pl/SqlС±à³Ì

ÎÒÏëʹÓÃSql±à¸öС³ÌÐò£¬¾ÍÊÇÅж¨Ò»¸ö×Ö·û´®³öÏÖÁ˼¸´ÎÖ¸¶¨×Ö·û£»
ÀýÈçÔÚstringÐÍ¡°6+4+8+2¡±ÖУ¬ÎÒÐèÒªÅж¨³öÏÖÁ˼¸¸ö¡°+¡±£»²¢ÇÒʵÏÖ
if £¨³öÏÖ3´Î£©
then
  ¡­¡­¡­¡­¡­¡­£¨Òý·¢Ê¼þ£©£»

......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ