unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, DB, ADODB, DBTables, Grids, DBGrids;type
TForm1 = class(TForm)
ADOConnection1: TADOConnection;
Button2: TButton;
ADOQuery1: TADOQuery;
Edit1: TEdit;
Edit2: TEdit;
Label1: TLabel;
Label2: TLabel;
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.Button2Click(Sender: TObject);
var
sGDDM: string;
begin
edit1.Text := '';
sGDDM := 'select * from FstTrade where SJYGDDM = ' +'''' + edit1.text + ''''; ADOConnection1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\FstTrade;Extended Properties=dBase 5.0;Persist Security Info=False'; if ADOConnection1.Connected = False then ADOConnection1.Connected := True; with ADOQuery1 do
begin
Active := False;
Connection := ADOConnection1;
SQL.Clear;
SQL.Add(sGDDM);
// ExecSQL;
open;
if RecordCount > 0 then
edit2.Text := FieldByName('SJYJYRQ').AsString;
Active := False;
ADOConnection1.Connected := False;
end;
end;end.
解决方案 »
- 找控件!
- delphi文件操作的问题
- 请问打印监控时,怎么可以得到打印内容?
- 怎样实现像电驴那样,在网站上点专用的网址就能调用电驴软件来下载???
- 如何提出一个字符串的后几位???
- Form的调用问题
- ●100分,EhLib可不可以直接在表格中进行数据录入???●
- delphi 开发类似qq的聊天项目,什么组件比较好?还是只用winsock?
- 如何将delphi1或delphi2的程序转到delphi6上用?
- 两台机器通过拨号上网,是否能够通过一台机器读取另一台机器的数据库,用SocketConnection(内详)
- 问题重发Field的Type为 Guid时报错 可以见图片了
- 来看看什么shit老板,拖着工资不发.
线程中用到VCL需要用线程类的同步函数Synchronize();同步 这点注意下就可以了
代码大概想下面的样子procedure AThread.Execute;
begin
{ Place thread code here }
Synchronize(DoIt);
end;
sGDDM := 'select * from FstTrade where SJYGDDM = ' +'''' + edit1.text + '''';这样写不会有SQL注入吗?