¼±£¡Ò»¸ö¹ØÓÚSQLµÄ¼òµ¥ÎÊÌâ
Delphi(Pascal) code:
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from pw where ÀàÐÍ=:a AND ±êÌâ=:b');
Parameters.ParamByName('a').Value:=spSkinComboBox1.Items[spSkinComboBox1.ItemIndex];
Parameters.ParamByName('b').Value:=spSkinEdit2.Text;
Prepared;
Open;
if RecordCount=0 then
Append;
FieldByName('ÀàÐÍ').AsString:=spSkinComboBox1.Items[spSkinComboBox1.ItemIndex];
FieldByName('±êÌâ').AsString:=spSkinEdit2.Text;
FieldByName('Óû§Ãû').AsString:=spSkinEdit3.Text;
FieldByName('ÃÜÂë').AsString:=spSkinEdit5.Text;
FieldByName('±¸×¢').AsString:=memo1.Text;
Post;
end;
ÕâÊÇ´úÂ룬Ӧ¸ÃÊÇÄǼ¸¸ö²ÎÊýÎÊÌ⣬´íÎóÌáʾÊÇ: ÖÁÉÙÓÐÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ
ÎҺܼ±£¬¸øÎÒ´óÏÀ¿ì°ïæ!
try
Delphi(Pascal) code:
SQL.Add('select ÀàÐÍ,±êÌâ,Óû§Ãû,ÃÜÂë,±¸×¢ from pw where ÀàÐÍ=:a AND ±êÌâ=:b');
崃쵀
²»Ðа¡
´óÏÀ¿ìÏÖÉí
spSkinComboBox1.Items[spSkinComboBox1.ItemIndex];
stringֵû±ØÒª ÕâÑùд°¡¡£¡£Ö±½ÓSPSKINCOMBOBOX1.TEXT¶àºÃ¡£¡£ÄãÕâ¸öд·¨ÎÒÓеãÏë²»Ã÷°×¡£Äã¼Ó±äÁ¿¸½Ò»ÏÂÖµ¡£¸ú×ÙһϿ´¿´¡£¡£Ó¦¸ÃÊÇÕâÀïµÄÎÊÌâ¡£
{{
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......