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µ±Ê±¿ÎÉ趼ûÔõô×ö£¬°¥¡£¡£¡£
À´½áÕËÁË
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
¾ßÌåÒªÇóÓ뱨³êQQ729851670
771234717
¡°Æ´Òô±à³Ì¡±ÊÇʲôÒâ˼
ÒýÓÃ
¡°Æ´Òô±à³Ì¡±ÊÇʲôÒâ˼
1.¸øÒ»¸ö×Ö¿ÉÒÔÏÔʾƴÒô£¬¶àÒô×ֵĻ°ÄÜÏÔʾ¶ÔÓ¦µÄ¶à¸öÆ´Òô
2.¶Ô°üº¬¶àÒô×ֵĴÊÓïÖÇÄÜʶ±ð¸ø³öÆ´Òô¡£
3.¶ÔÒ»¶Î ......
Àý×Ó³ÌÐò¼û¸½¼þ£¬ÓÃDelphi 7½øÐбàÒë
ÎÊÌâ´úÂëΪ
Delphi(Pascal) code:
if Node.ChildNodes <> nil then
begin
for i := 0 to Node.ChildNodes.Count - 1 do
begin
cNode := N ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......