bind[10].buffer_type = MYSQL_TYPE_LONGLONG;
bind[10].buffer = (unsigned char*)&nID;
bind[10].buffer_length = (unsigned long)sizeof(nID);
bind[10].length = 0;

char szInsert[1024] = {0};
strcpy_s( szInsert,1024,"CALL P_INSERTFACE( , , , , , , , , , ,@1);");
//strcpy_s( szInsert,1024,"CALL P_INSERTFACE( , , );");

mysql_stmt_prepare(stmt_mysql, szInsert, (unsigned long)strlen(szInsert));
mysql_stmt_bind_param(stmt_mysql, bind);
mysql_stmt_bind_result(stmt_mysql,bind + 10);
if( mysql_stmt_execute(stmt_mysql)==0 )
{
CString cmdStr=_T("SELECT @1");
int nRet = mysql_query(m_pMysql, cmdStr);
if(0 == nRet)
{
MYSQL_RES* pResult = NULL;
pResult = mysql_store_result(m_pMysql);
if (pResult)
{
MYSQL_ROW rdRow;
rdRow = mysql_fetch_row(pResult);
nID = StrToLONG64(CString(rdRow[0]));//自定义函数 该函数是吧字符串转64位整型
}
mysql_free_result(pResult);
}

mysql_stmt_close(stmt_mysql);
return S_OK;
}
else
{
mysql_stmt_close(stmt_mysql);
return S_FALSE;
}

}
catch(...)
{
mysql_stmt_close(stmt_mysql);
}

return S_FALSE;

}