//增加 with data_form.ADOQuery1 do begin Close; SQL.Clear; SQL.add('insert into 操作员表(操作员名,口令) values '); sql.add('(''' + trim(editname.Text) + ''',''' + trim(editpass.Text)+''''); ExecSQL ; end; //删除 with data_form.ADOQuery1 do begin Close; SQL.Clear ; SQL.add('delete from 操作员表 where 操作员名=''' + editusr.text+''''); ExecSQL; end;
var user,psd:string; begin user:='admin'; psd:='admin'; //增加 with adoquery1 do begin close; sql.Text:='insert into usetable (useId,psd) values ('''+user+''','''+psd+''')'; execsql; end; //删除 with adoquery1 do begin close; sql.Text:='delete from usetable where userId='''+user+''''; execsql; end; end;
首先你要设置数据库连接 可以用ADOConnection,也可以直接用aodquery 设置ConnectionSTRING为你的数据库 aodquery用法跟QUERY是一样的 查询 SQL.Add('select * from T_user'); SQL.Add('where username=:coner'); open 添加 SQL.add('insert into T_user'); SQL.add('字段1,字段2,。。'); SQL.ADD('values'); sql.add('(字段一的值,字段二的值)') ExecSQL ; 删除 SQL.add('delete from T_user where 字段=''' + 某个值+''''); ExecSQL;
用ADOConnection
随便找本书看看就明白
AdoTbl.Connection:=AdocnCar;
AdoTbl.TableName:='C_Enterprise';
AdoTbl.CursorLocation:=clUseClient;
AdoTbl.LockType:=ltOptimistic;
AdoTbl.Active:=true;
AdoTbl.Append;
With AdoTbl do
begin
FieldValues['EnterpriseID']:=IntID;
FieldValues['EnterpriseCode']:=Trim(EdtEnterpriseCode.Text);
FieldValues['EnterpriseName']:=Trim(EdtEnterpriseName.text);
FieldValues['UpCode']:=UpCodeID;
FieldValues['ViewOrder']:=IntViewOrder;
Post;
Close;
Free;
end;
除了用INSERT 外,字段多的话,还是这样合适,
SQL.Clear;
SQL.Add('select * from T_user');
SQL.Add('where username=:coner');
ExecSQL;
这样写可以吗,中间的sql语句怎么写阿
with data_form.ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.add('insert into 操作员表(操作员名,口令) values ');
sql.add('(''' + trim(editname.Text) + ''',''' + trim(editpass.Text)+'''');
ExecSQL ;
end;
//删除
with data_form.ADOQuery1 do
begin
Close;
SQL.Clear ;
SQL.add('delete from 操作员表 where 操作员名=''' + editusr.text+'''');
ExecSQL;
end;
user,psd:string;
begin
user:='admin';
psd:='admin';
//增加
with adoquery1 do
begin
close;
sql.Text:='insert into usetable (useId,psd) values ('''+user+''','''+psd+''')';
execsql;
end;
//删除
with adoquery1 do
begin
close;
sql.Text:='delete from usetable where userId='''+user+'''';
execsql;
end;
end;
可以用ADOConnection,也可以直接用aodquery
设置ConnectionSTRING为你的数据库
aodquery用法跟QUERY是一样的
查询
SQL.Add('select * from T_user');
SQL.Add('where username=:coner');
open
添加
SQL.add('insert into T_user');
SQL.add('字段1,字段2,。。');
SQL.ADD('values');
sql.add('(字段一的值,字段二的值)')
ExecSQL ;
删除
SQL.add('delete from T_user where 字段=''' + 某个值+'''');
ExecSQL;