4,011
社区成员
发帖
与我相关
我的任务
分享
void IsExistUser(CString strEMail, CString strPass)
{
_CommandPtr pCommand;
pCommand.CreateInstance(__uuidof(Command));
CString strSQL;
strSQL.Format("SELECT ID FROM dbo.Customer WITH(NOLOCK) WHERE [Email]=@EMail AND [Password]=@Password");
pCommand->PutCommandText(_bstr_t(strSQL));
pCommand->PutCommandType(adCmdText);
_ParameterPtr Param1;
Param1.CreateInstance(__uuidof(Parameter));
Param1->PutName(_variant_t("@EMail"));
Param1->PutValue(_variant_t(strEMail));
Param1->PutSize(strEMail.GetLength()+1);
pCommand->GetParameters()->Append((IDispatch*)Param1);
_ParameterPtr Param2;
Param2.CreateInstance(__uuidof(Parameter));
Param2->PutName(_variant_t("@Password"));
Param2->PutValue(_variant_t(strPass));
Param2->PutSize(strPass.GetLength()+1);
pCommand->GetParameters()->Append((IDispatch*)Param2);
pCommand->Execute(NULL, NULL, adCmdText);
//other code...
//
//..
//release
}