delphi ÈçºÎ¼õÉÙ ¼ì²éÊý¾Ý¿âÊÇ·ñÁ¬Í¨ µÄʱ¼ä
delphi7.0 ÓÃadoÁ¬½Óºǫ́µÄSql Êý¾Ý¿â£¬µ±·¢ÏÖÊý¾Ý¿âÎÞ·¨Á¬½ÓÉÏ£¨Êý¾Ý¿â²»´æÔÚµÈÒì³££©£¬ÐèÒªµÈ´ýµÄʱ¼ä±È½Ï³¤£¬
try
adoconnection.active := true;
except
on E:exception do
begin
dosomething or reconnect to db.
end;
ÔËÐÐÕâ¸ö¹ý³ÌµÄʱºò£¬Èç¹ûûÓÐÁ¬½ÓÉÏÊý¾Ý¿â dosomething or reconnect to db ÕâÐдúÂëÐèµÈ´ý±È½Ï³¤µÄʱ¼ä¡£
ÏëÎÊÒ»ÏÂÓÐʲô·½·¨¸ÄÁ¼Ò»ÏÂÂð£¿
×îºÃÊÇÖ»ÒªÁ¬½Ó²»ÉϾÍcatch Exception ÈçºÎ¼õÉÙ µÈ´ýµÄʱ¼ä¡£¶ø×ªÈ¥×ö±ðµÄÊÂÇé¡£
°ÑADOCONNECTIONµÄConnectionTimeoutÉèСһµã¾ÍºÃÁË£¬Ä¬ÈÏÊÇ15s¡£
to haochin :
15s == 15 second?
ÎÒÉèÖÃÁË3s »¹ÊÇÒªµÈ±È½Ï³¤µÄʱ¼ä£¬µ«ÊÇÃ÷ÏÔÊÇËõ¶ÌÁËһЩ¡£¶øÇÒ·¢ÏÖÉèÖà 1£¬2£¬3£¬4s µÄÏìӦʱ¼äÊÇ»ù±¾Ò»ÑùµÄ£¬¸Ð¾õ²»µ½²î±ð¡£
¶øÇÒadoConnection.ConnectionString := '... DataSource = 192.168.1.100';
ºÍ adoConnection.ConnectionString := '... DataSource = DBName';
Á½¸öÁ¬½ÓʱºòµÄÏìÓ¦µÄʱ¼äÒ²²»Ò»Ñù¡£
ÓÃDBNameµÄcatch Òª¿ì¡£
ºÎ½â£¿
лл
Ë˵TimeoutûÓÐÓÃ?
Ö»ÊDz»ÊǺÜ×¼¶øÒÑ¡£
Ïà¹ØÎÊ´ð£º
delphiÈçºÎÏòAccessÊý¾Ý±íÖÐ×Ô¶¨Òå×Ö¶Î?È»ºóÏÔʾµ½DBGridÖÐ
ÔõôûÈËÀíÎÒѽ
·Ö·Ö߯ÉÙßÖ£¬Ò»°ãÈ˶¼ÀÁµÃ½øÀ´¡¡*^_^*
SQL
creat table TableName(ID Counter Primary Key,FieldName varchar(20))
ADOQue ......
ÕâÓïÑÔºÃÄѰ¡ ѧdelphi¼òµ¥ ¿Þ
Ò»¸ödll ºÍÒ»¸ö Ö¸Õ뺯Êýµ÷Óà ¸ãÁËÎÒ2Àñ°Ý »¹ÊÇÔÚÎÒÓÐdelphi»ù´¡µÄÇé¿öÏ ¿Þ
ÄÑ¶È ±È delphi ¸ßºÜ¶à¡£¼ÌÐøÅ¬Á¦Ñ§°¡¡£
ºÃÏñÒ²²¢²»±ÈdelphiÄѶàÉÙ°É
Ö÷Òª´úÂë ²»Ö±¹ÛÁË¡ ......
Çë½Ì¸÷·¸ßÊÖ¡£ÎäÁÖǰ±²¡£ÎÒ½«B.EXE×ö³É×ÊÔ´Îļþ£¬È»ºó¼Óµ½123.dllÖС£ÓÃA.EXEÀ´µ÷ÓÃ123.dllÖеÄB.EXE
Çë¸÷λǰ±²°ïæָ½ÌÏ¡£A.exeÈçºÎÀ´µ÷ÓÃdllÖеÄexe£¿´úÂëÓÖ¸ÃÈçºÎд£¿
ÏȰÑb.exe»¹Ô³öÀ´ÔÚµ÷Óã¬Ó¦¸ÃÊÇ× ......
×ÜÖ®£¬Õâ¸öÓ¦¸ÃÊǸöСBUG¡£
Ëæ±ã½¨¸ötxtÎĵµ
µÚÒ»ÐÐ68¸ös¼ÓÒ»¸ö»Ø³µ
µÚ¶þÐÐ98¸ös¼ÓÒ»¸ö»Ø³µ
µÚÈýÐÐ17¸ös¼ÓÒ»¸ö»Ø³µ
×ܹ²183¸ös¼ÓÈý¸ö»»ÐУ¬´óС189×Ö½Ú¡£
½Ó×ÅÓÃFileOpenºÍFileRead°ÑÎļþ ......
½ÓÊÕµ½µÄÎı¾ÄÚÈÝÊÇucs2±àÂë¸ñʽ£¬ÇëÎÊÔõÑùת»»³ÉÖÐÎÄ
°´ÎÒµÄÀí½â£¬UCS-2ÊÇ×Ö·û¼¯£¬¾ßÌåµÄ±àÂëÓÐUTF-8£¬UTF-16 (LE/BE)µÈ¡£
Èç¹ûÄãÓÃDelphi 2009¼°ÒÔÉϰ汾£¬¿ÉÒÔ¿´¿´TEncodingÀà¡£
btw. Äã˵µÄת»»³ÉÖÐÎÄÊÇɶÒâË ......