procedure Tloginfm.Button1Click(Sender: TObject);
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser=user and adminpwd=pwd');
dataModule1.ADOQuery1.ExecSQL;
showmessage('登录成功...');
except
begin
showmessage('用户名或密码错误...');
end;
end;
end;
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser=user and adminpwd=pwd');
dataModule1.ADOQuery1.ExecSQL;
showmessage('登录成功...');
except
begin
showmessage('用户名或密码错误...');
end;
end;
end;
这样改一下,看看行不行。。
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear
s:='select * from admin where (adminuser=''%s'') and (adminpwd=''%s'')';
s:=format(s,[Trim(edit1.Text),Trim(edit2.Text);]
dataModule1.ADOQuery1.SQL.Add(s);
dataModule1.ADOQuery1.open
showmessage('登录成功...');
except
begin
showmessage('用户名或密码错误...');
end;
end;
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser='+Quotedstr(user)+ 'and adminpwd='+Quotedstr(pwd));
dataModule1.ADOQuery1.Open;
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser=:user and adminpwd=:pwd');
dataModule1.ADOQuery1.Parameters.ParamByName('user ').value := user ;
dataModule1.ADOQuery1.Parameters.ParamByName('pwd').value := pwd;
dataModule1.ADOQuery1.ExecSQL;
if not dataModule1.ADOQuery1.IsEmpty then //这样才行
showmessage('登录成功...');
except
begin
showmessage('用户名或密码错误...');
end;
end;
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser=:user and adminpwd=:pwd');
dataModule1.ADOQuery1.Parameters.ParamByName('user ').value := user ;
dataModule1.ADOQuery1.Parameters.ParamByName('pwd').value := pwd;
dataModule1.ADOQuery1.ExecSQL;
if not dataModule1.ADOQuery1.IsEmpty then //这样才行
showmessage('登录成功...')
else
showmessage('用户名或密码错误...');
except
begin
/////////showmessage('用户名或密码错误...');
end;
end;
Application.CreateForm(TFrmmain, Frmmain);
Frmmain.show;
Application.createForm(TFrmdenglu,frmdenglu);
frmdenglu.ShowModal;
Application.Run;
procedure Tloginfm.Button1Click(Sender: TObject);
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser='''+user+''' and adminpwd='+pwd);
dataModule1.ADOQuery1.ExecSQL;
showmessage('登录成功...');
except
showmessage('用户名或密码错误...');
end;
end;
如果你的用户是数字,而密码也是数字,则你的程序应改为如下程序(并且你的EXCEPT后的BEGIN应删除):
procedure Tloginfm.Button1Click(Sender: TObject);
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser='+user+' and adminpwd='+pwd);
dataModule1.ADOQuery1.ExecSQL;
showmessage('登录成功...');
except
showmessage('用户名或密码错误...');
end;
end;
如果你的用户是字符,而密码也是字符,则你的程序应改为如下程序(并且你的EXCEPT后的BEGIN应删除):
procedure Tloginfm.Button1Click(Sender: TObject);
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser='''+user+''' and adminpwd='''+pwd+'''');
dataModule1.ADOQuery1.ExecSQL;
showmessage('登录成功...');
except
showmessage('用户名或密码错误...');
end;
end;
1、对字符串的用法不清楚,应有单引号;
2、模态和非模态只要用 Show 或 ShowModal 区分就行了!
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser='''+user+''' and adminpwd='''+pwd+'''');
dataModule1.ADOQuery1.Open;
if dataModule1.ADOQuery1.RecordCount<>0 then
showmessage('登录成功...')
else
showmessage('用户名或密码错误...');
end;
end;
var
user:string;
pwd:string;
begin
try
dataModule1.ADOQuery1.Close;
dataModule1.ADOQuery1.SQL.Clear;
user:=Trim(edit1.Text);
pwd:=Trim(edit2.Text);
dataModule1.ADOQuery1.SQL.Add('select * from admin where adminuser=''' + user
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
如果是Access,要改的,老大,把admin改成 [admin]
+ '''and adminpwd = ''' + pwd'''');
dataModule1.ADOQuery1.ExecSQL;
showmessage('登录成功...');
except
begin
showmessage('用户名或密码错误...');
end;
end;
end;