var username,password,sqlstr:string ; begin username:=trim(Eusername.Text);//Eusername是用户名输入 password:=trim(Epassword.Text);//Epassword是密码输入 if username='' then begin showmessage('用户名不能为空!'); Eusername.SetFocus; exit; end; if password='' then begin showmessage('密码不能为空!'); Epassword.SetFocus; exit; end; with DataModule1.ADOQUERY1 do //DataModule1.ADOQUERY1是我的一个数据模块中的adoquery begin close; sql.clear; sqlstr:='select * from yhxx where user=:V1 '; sql.Add(sqlstr); Parameters.ParamByName('V1').value:=username; try OPEN; except on EDatabaseError do messagedlg('数据库操作错误!',mtError,[mbok],0); end; if isempty then begin showmessage('无此用户名,请重新录入!'); Eusername.SetFocus; exit; end else begin close; sql.Clear; sqlstr:='select * from yhxx where user=:V1 and pass=:V2'; sql.Add(sqlstr); Parameters.ParamByName('V1').value:=username; Parameters.ParamByName('V2').value:=password; try OPEN; except on EDatabaseError do messagedlg('数据库操作错误!',mtError,[mbok],0); end; if isempty then begin showmessage('密码输入有误,请重新输入密码!'); Epassword.SetFocus; exit; end else begin Flogin.Hide; if DataModule1.ADOQUERY1.FieldByName('super').AsString='否' then begin Fmain.TBuserman.Enabled:=false; Fmain.TBsetting.Enabled:=false; Fmain.N3.Enabled:=false; end; fmain.Logined:=true; Fmain.ShowModal; end; end; end; end;
工程文件代码是: program Ptag;
uses Forms, Umain in 'Umain.pas' {Fmain}, DataMudule in 'DataMudule.pas' {DataModule1: TDataModule}, Ulogin in 'Ulogin.pas' {Flogin};