| ²é¿´: 985 | »Ø¸´: 1 | |||
zyj8119ľ³æ (ÖøÃûдÊÖ)
|
[½»Á÷]
¡¾×ªÌû¡¿Delphi±à³ÌÖÐADOquery¿Ø¼þµÄÓ÷¨ ÒÑÓÐ1È˲ÎÓë
|
|
ͨ¹ýsqlµÄ´æ´¢¹ý³ÌÀ´ÊµÏÖ: Ìí¼Ó With ADOQuery1 do begin Close; SQL.Clear; SQL.Add(' Insert Into Table1(Field1,Field2)') SQL.Add(' Values(10,20)'); ExecSQL; end; ÐÞ¸Ä With ADOQuery1 do begin Close; SQL.Clear; SQL.Add(' Update Table1 Set Field1=20,Field2=30)') ExecSQL; end; ɾ³ý With ADOQuery1 do begin Close; SQL.Clear; SQL.Add(' Delete From Table1') SQL.Add(' Where Field1=20 and Field2=30'); ExecSQL; end; ²éѯ With ADOQuery1 do begin Close; SQL.Clear; SQL.Add(' Select Field1,Field2 From Table1') SQL.Add(' Where Field1=20 and Field2=30'); Open; end; *************************************************** ͨ¹ýDelphi×ÔÓеķ½·¨ÊôÐÔʵÏÖ: Ìí¼Ó£º with ADOQuery1 do append; ...... post; ɾ³ý£º with ADOQuery1 do delete£¨Ñ¡Ôñɾ³ýµÄ¼Ç¼£©; //ĬÈÏɾ³ý¼Ç¼ָÕëÖ¸ÏòµÄ¼Ç¼ Ð޸ģº with ADOQuery1 do edit; ...... post; adotable1.Append; //Ìí¼Ó ADotable1.Fields.FieldByName('gxid1').Value:=gx; adotable1.Post; adotable1.delete; //ɾ³ý adotable1.edit; //ÐÞ¸Ä ADotable1.Fields.FieldByName('gxid1').Value:=gx; adotable1.post; WITHI adoquery do begin//Ìí¼Ó adoquery.open;//motice set adoquery.sql adoquery.append;//OR adoquery.insert; fieldbyname(fieldname).asstring:=trim(edit1.text); ...... adoquery.post; end; ɾ³ý: adoquery.delete ÐÞ¸Ä: adoquery.edit; fieldbyname(fieldname).asstring:=trim(edit1.text); ÓйØÏ¸½Ú¿ÉÒԲο´°ïÖúOR DEMO |
» ²ÂÄãϲ»¶
290Çóµ÷¼Á
ÒѾÓÐ3È˻ظ´
Ò»Ö¾Ô¸Î÷ÄϽ»Í¨ ר˶ ²ÄÁÏ355 ±¾¿ÆË«·Ç Çóµ÷¼Á
ÒѾÓÐ4È˻ظ´
295¸´ÊÔµ÷¼Á
ÒѾÓÐ6È˻ظ´
279·ÖÇóµ÷¼Á Ò»Ö¾Ô¸211
ÒѾÓÐ8È˻ظ´
¹¤¿Æ²ÄÁÏ085601 279Çóµ÷¼Á
ÒѾÓÐ8È˻ظ´
317Çóµ÷¼Á
ÒѾÓÐ8È˻ظ´
Ò»Ö¾Ô¸Äϲý´óѧ£¬327·Ö£¬²ÄÁÏÓ뻯¹¤085600
ÒѾÓÐ5È˻ظ´
274Çóµ÷¼Á
ÒѾÓÐ7È˻ظ´
317Çóµ÷¼Á
ÒѾÓÐ9È˻ظ´
ÕÐÊÕµ÷¼Á˶ʿ
ÒѾÓÐ11È˻ظ´
» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:
matlabÀۺͱà³ÌÇóÎÊ
ÒѾÓÐ9È˻ظ´
ÂÁ²ÄµÄÓ÷¨£º³ä·Ö·¢»Ó²ÄÁϺÍÉè¼ÆÌØµãÖÆÔì²úÆ·
ÒѾÓÐ4È˻ظ´
ÓïÑÔÖ¤Ã÷ÄÚÈݳöÏÖÁ½¸öµ¥´ÊÓ÷¨Ð¡´íÎóÕâ¸öÎÊÌâÑÏÖØÂð£¿
ÒѾÓÐ10È˻ظ´
pdquestÓ÷¨Çë½Ì
ÒѾÓÐ3È˻ظ´
¡¾ÇóÖú¡¿ÈçºÎÓÃDELPHIʵÏÖ¶Ô¶àÖÖÀàÐÍÎļþµÄ¹ÜÀí¹¦ÄÜ
ÒѾÓÐ9È˻ظ´
ÇóÖúdelphi ±à³Ì£¬ÔÚwindow2003ÖÐÊäÈ뺺×ÖΪÂÒÂëÎÊÌâ
ÒѾÓÐ5È˻ظ´
È˹¤Éñ¾ÍøÂç±à³Ì
ÒѾÓÐ12È˻ظ´
¡¾×ªÌû¡¿ÓÃDelphi¿ª·¢ÊÓÆµÁÄÌìÈí¼þ
ÒѾÓÐ8È˻ظ´
¡¾·ÖÏí¡¿Ò»¸öDelphiµÄÔ´Âë¼ÓÃܲå¼þ
ÒѾÓÐ4È˻ظ´

¹ÜÌìµÀµÀ
½ð³æ (ÖøÃûдÊÖ)
- Ó¦Öú: 18 (СѧÉú)
- ½ð±Ò: 326.1
- É¢½ð: 1102
- ºì»¨: 11
- Ìû×Ó: 1697
- ÔÚÏß: 45.4Сʱ
- ³æºÅ: 2620881
- ×¢²á: 2013-08-28
- ÐÔ±ð: MM
- רҵ: ÈÏÖª¹¦ÄÜÕϰ

2Â¥2013-10-11 02:13:13













»Ø¸´´ËÂ¥