begin
insert into userInfo(userName,userCode,delOrNot) values(in_userName,in_userCode,0);
end
存储过程,连MYSQL NAVICAT里面写的,测试,参数不是中文就OK,可以运行
比如我参数: 'wangwu','cctv-2010'运行就可以插入,但如果是: '王五','cctv-2010',在NAVICAT里面运行就会报不合法的字符,但在MYSQL命令窗口就没有这个问题,请问为什么
下面进入正题:
CString userName = "ZHOULIU";
CString userCode = "ISND-332244";
try
{
_CommandPtr pCmd;
HRESULT hr = pCmd.CreateInstance(__uuidof(Command));
if (FAILED(hr))
{
AfxMessageBox("创建cmd失败");
return;
}
pCmd->CommandText = "InsertUser";
_ParameterPtr pParam;
pParam = pCmd->CreateParameter(_bstr_t("userName"),adVarChar,adParamInput,strlen(userName),(_variant_t)userName);
pCmd->Parameters->Append(pParam);
pParam = pCmd->CreateParameter(_bstr_t("userName"),adVarChar,adParamInput,strlen(userCode),(_variant_t)userCode);
pCmd->Parameters->Append(pParam);
pCmd->CommandType = adCmdStoredProc;
pCmd->ActiveConnection = m_pConn;
pCmd->Execute(NULL,NULL,adCmdStoredProc);
}
catch (...)
{
m_pConn->Close();
}
这是ADO代码,调试还是在excute�