extern "C" void PASCAL EXPORT enroll(int numA,int numB)
{
AFX_MANAGE_STATE(AfxGetStaticModuleState());
// 此处为普通函数体
MYSQL m_sqlCon;
try{
mysql_init(&m_sqlCon);
if(!mysql_real_connect(&m_sqlCon, "ip地址","登陆账号","登陆密码","数据库名",3306,NULL,0)){
AfxMessageBox(_T("数据库连接失败!"));
}else{
char select_user[255];
int content;
int num_row,num_col;
MYSQL_RES *result=NULL;
MYSQL_ROW mysql_row;
sprintf_s(select_user, "select * from gmicus where num='%d'", numA);
if (mysql_query(&m_sqlCon, select_user) || !(result = mysql_store_result(&m_sqlCon))) {
AfxMessageBox(_T("程序运行错误!"));
}
num_row=(int)mysql_num_rows(result);
num_col=(int)mysql_num_fields(result);
if (num_row== 0) {
AfxMessageBox(_T("识别码错误!"));
}else{
while (mysql_row = mysql_fetch_row(result))//获取具体的数据
{
for (int i = 0; i < num_col; i++)
{
if(i==0){
/*CString str;
str.Format(_T("%d"), (int)atoi(mysql_row[i]));
AfxMessageBox(str);*/
content=(int)atoi(mysql_row[i]);
break;
}
}
}
if(content==0){
char update[255];
sprintf_s(update, "update gmicus set id='%d' where num='%d'", numB, numA);
if(mysql_query(&m_sqlCon, update)) {
AfxMessageBox(_T("注册失败!"));
}else{
AfxMessageBox(_T("注册成功!"));
}
}else{
AfxMessageBox(_T("此识别码已被注册过!"));
}
}
mysql_free_result(result);
mysql_close(&m_sqlCon);
getchar();
}
}catch (...){
AfxMessageBox(_T("未知错误!"));
}
}