假设数据集名为 adoquery1 adoquery1的sqlSELECT u.user_name, u.user_password FROM user_info u WHERE user_name = :NAME AND user_password = :PASSWORD程序中,(假设输入用户名的编辑框名为edtUserID,输入密码的编辑框名为edtPass) if length(trim(edtUserID.Text)) <> 0 then begin adoquery1.Close; adoquery1.Parameters.Items[0].Value := edtUserID.Text; //Parameters 1:UserID adoquery1.Parameters.Items[1].Value := edtPass.Text; //Parameters 2:Pass try adoquery1.Open; except on E:Exception do // Open table Error ShowMessage(E.Message); end; adoquery1.Last; if adoquery1.RecordCount <= 0 then // UserID or Password is Error begin ShowMessage('UserID or Password is Error!'); exit; end; end else begin ShowMessage('Please input UserID and Password!'); exit; end;
var spass: string; ... spass := adoquery1.fieldbyname('user_password').asstring;
query1.sql.clear;
sqlstr := 'select count(*) from user_info where unser_name = '''+edit1.text+''' and user_password = '''+edit2.text
query1.sql.add(sqlstr);
query1.open;
if query1.field[0].asinteger <> 1 then
showmessage(invalidate user)
else
....
adoquery1的sqlSELECT u.user_name, u.user_password
FROM user_info u
WHERE user_name = :NAME
AND user_password = :PASSWORD程序中,(假设输入用户名的编辑框名为edtUserID,输入密码的编辑框名为edtPass) if length(trim(edtUserID.Text)) <> 0 then
begin
adoquery1.Close;
adoquery1.Parameters.Items[0].Value := edtUserID.Text; //Parameters 1:UserID
adoquery1.Parameters.Items[1].Value := edtPass.Text; //Parameters 2:Pass try
adoquery1.Open;
except
on E:Exception do // Open table Error
ShowMessage(E.Message);
end; adoquery1.Last;
if adoquery1.RecordCount <= 0 then // UserID or Password is Error
begin
ShowMessage('UserID or Password is Error!');
exit;
end;
end
else
begin
ShowMessage('Please input UserID and Password!');
exit;
end;
spass: string;
...
spass := adoquery1.fieldbyname('user_password').asstring;