sqlÓï¾ä´íÎó - Delphi / Êý¾Ý¿âÏà¹Ø
¶¨Òå±äÁ¿s,sqlΪstringÀàÐÍ£¬sΪº¯Êý²ÎÊý£¬sql£º='select field1 from table1 where'+s;ÔËÐÐʱs¸³ÖµÎªid>7»òÕßid<7¡¢id=7,µ«ÊÇÔËÐÐʱ×ÜÊdzö´í£¬Çë¸÷λ°ïÎÒ¸Ä´í£¬¶àл£¡
showMessage(sql)Ï¿´¿´
sql£º='select field1 from table1 where '+s;
ÓпÉÄÜwhereºó±ßÒª¼Ó¸ö¿Õ¸ñ
ÊÇ¿Õ¸ñ
¸Ðл2룬2Â¥Â鷳˵Ïêϸһµã£¬Äã˵µÄ¿Õ¸ñÊǺÍÂ¥ÉϵÄÒ»ÑùÂð
×Ö·û´®Á¬ÔÚÒ»ÆðÁË£¬ÔËÐÐʱSQLµÄÖµ='select field1 from table1 whereid>7'¡£ÒªÔÚwhereºóÃæ¼ÓÒ»¸ö¿Õ¸ñ×Ö·û£¬¾Í»á±ä³É£º'select field1 from table1 where id>7'£¬Æäʵ2¥˵µÃºÜÃ÷°×À²£¬×Ô¼ºµ÷ÊÔÏÂÂï
ÔΡ£¡£¡£ÊÇ1Â¥¡£¡£¡£sorry¡£¡£¡£
ȷʵÊÇÕâÑùµÄ
End_rbody_64695987//-->
¸Ã»Ø¸´ÓÚ2010-04-16 08:58:16±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
cloudysoul
(cloudysoul)
µÈ¡¡¼¶£º
#8Â¥ µÃ·Ö£º10»Ø¸´ÓÚ£º2010-04-15 20:26:35
sql£º='select field1 from table1 where'+s
ÕâÑùд²»Ì«ºÃ°É
¸Ä³ÉÕâÑùÊÔÒ»ÊÔ£º
sql£º='select field1 from table1'£»
if (Ìõ¼þ) then
sql:=sql+'where id>7';
if (Ìõ¼þ) then
sql:=sql+'where id<7';
if (Ìõ¼þ) then
sql:=sql+'where id=7';
ÐÂÊֻشðÎÊÌ⣬¼ûЦÁË£¡
ÉÙÁ˸ö¿Õ¸ñ°É
showMessage(sql)Ï¿´¿´
Òª²»°Ñ´íÎóÌùÉÏÀ´£¡
ÔÎÓ´¡¢Ã»¿Õ¸ñŶ¡¢
Ó¦¸ÃÊÇÉÙ¿Õ¸ñ£¬ÎÒÒ²Óöµ½¹ýÀàËÆÇé¿ö¡¡
¿ÉÄÜÊÇ¿Õ¸ñµÄÔÒò£¬¸Ä³É
sql£º='select field1 from table1 where '+s
×îºÃÑø³ÉÏ°¹ß£¬ÔÚ×Ö·ûÏà¼ÓÇ°£¬¶¼Ô¤ÁôÏ¿ո
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃдʲôÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×ֶΠ±àºÅ Öµ ״̬ ʱ¼ä
Id value state dattime
101 32.3 0 ......