delphi×î»ù´¡µÄSQL²éѯ - Delphi / Êý¾Ý¿âÏà¹Ø
ÎÒÒª²éѯX±íÖÐ ÊÕÈë = YµÄ ×Ö¶Î
±ÈÈç ÎÒÔÚSQLÖÐ ÊÇÕâôÊäÈëµÄ slect * from X where ÊÕÈë = y
ÔÚdelphi ÖÐ y ¾ÍÓÃedit1.textÀïÊäÈë
begin
adoquery1.Close;
ADOQuery1.SQL.Clear;
adoquery1.SQL.Add('select * from xmb where ÊÕÈë='+''''+trim(edit1.Text)+'''');
try
adoquery1.open;
except
showmessage('ûÓиÃÊÕÈë¼Ç¼');
exit;
end;
Õâ¶Î¶ÏÂëµÄ»°£¬Èç¹ûÊÕÈëÎı¾µÄ¿ÉÒÔÖ´ÐÐ £¬µ«Èç¹ûÊÕÈëÊÇÊýÖµµÄ Ó¦¸ÃÔõôÐ޸ĴúÂ룡
Çë¸÷λ´óϺָ½Ì£¡
×¢Ò⣺ÊÕÈë×Ö¶ÎÊÇÊý×ÖÐÍ
ºÃ½áÕÊÁË
½¨ÒéÕâôд£º
adoquery1.SQL.Add('select * from xmb where ÊÕÈë:= earn')
adoquery1.Parameters.ParamValues['earn'] := trim(edit1.Text);
ͬÒâ3Â¥µÄ
delphiµ±Ê±¿ÎÉ趼ûÔõô×ö£¬°¥¡£¡£¡£
À´½áÕËÁË
Ïà¹ØÎÊ´ð£º
ÒÑÖªPython ÖУº
s = unicode("²âÊÔ", "gb2312")
s = u'\u6d4b\u8bd5'
print s
²âÊÔ
ÔÚDelphiÀïÃæÈçºÎ½«\u6d4b\u8bd5ÕâÑùµÄ»¹Ô³ÉGb2312µÄºº×ÖÄØ£¿
ÕÒµ½¸ö·½·¨
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......