/////检测输入的是否正确 sql:='select * from db_user where user_name='''+ edit1.text+''''+ ' and user_password='''+edit2.text+''''; query.Close; query.SQL.Text:=sql; query.Open; if query.RecordCount>=1 then begin 下一个form.show; end;
dbedit是数据敏感控件,其本身就是和db链接的,你是什么意思呢?
if pos('''',edit1.Text)>0 then exit; query.Close; query.SQL.Clear; query.SQL.Add('select * from T_user ') ; query.sql.Add(format('where name=''%s'' and password=''%s'''[edit1.text,edit2.text])); query.Open; if query.IsEmpty then begin showmessage('warning!'+#13+'error'); exit; end; i:=1; self.hide; showmessage('欢迎使用访系统'); edit1.Clear; edit2.Clear;
query.Close; query.sql.clear; query.sql.add('select * from db_user where user_name=:a and password=:b'); query.Parameters.ParamByName('a').Value:=dbedit1.text; query.Parameters.ParamByName('b').Value:=dbedit2.text;query.open; if query.RecordCount>=1 then begin 下一个form.show; end;
sql:='select * from db_user where user_name='''+
edit1.text+''''+
' and user_password='''+edit2.text+'''';
query.Close;
query.SQL.Text:=sql;
query.Open;
if query.RecordCount>=1 then
begin
下一个form.show;
end;
query.Close;
query.SQL.Clear;
query.SQL.Add('select * from T_user ') ;
query.sql.Add(format('where name=''%s'' and password=''%s'''[edit1.text,edit2.text]));
query.Open;
if query.IsEmpty then
begin
showmessage('warning!'+#13+'error');
exit;
end;
i:=1;
self.hide;
showmessage('欢迎使用访系统'); edit1.Clear;
edit2.Clear;
query.sql.clear;
query.sql.add('select * from db_user where user_name=:a and password=:b');
query.Parameters.ParamByName('a').Value:=dbedit1.text;
query.Parameters.ParamByName('b').Value:=dbedit2.text;query.open;
if query.RecordCount>=1 then
begin
下一个form.show;
end;