int LoginJudge(USER_ACCOUNT req) {
int i=0; char *name; char *reqname; char *password; char *reqpass; reqname=req.Name; reqpass=req.Password;
if(!(mysql_connect(&mysql,NULL,"root","1111"))) return FALSE; if(mysql_select_db(&mysql,"serverdb")) return FALSE; if (mysql_query(&mysql,"select name,password from main" )) return FALSE; if(!(res=mysql_store_result(&mysql))) return FALSE; while((row=mysql_fetch_row(res))) { name=row[0]; password=row[1]; if (!strcmp(name,reqname)) { if(!strcmp(password,reqpass)) return TRUE; else return FALSE; } } if(! mysql_eof(res)) return FALSE; mysql_free_result(res); mysql_close(&mysql); return FALSE; }
int authority(char *name) { long iBackValue; char *cDBname; char *cDBauthority; char *cQuename; char *cValueOne; char *cValueTwo;
cQuename=name; cValueOne="1"; cValueTwo="2"; if(!(mysql_connect(&mysql,NULL,"root","1111"))) return FALSE; if(mysql_select_db(&mysql,"serverdb")) return FALSE; if (mysql_query(&mysql,"select name,authority from main" )) return FALSE; if(!(res=mysql_store_result(&mysql))) return FALSE; while((row=mysql_fetch_row(res))) { cDBname=row[0]; cDBauthority=row[1]; if (!strcmp(cDBname,cQuename)) { if(!strcmp(cValueOne,cDBauthority)) { iBackValue=1; if(!strcmp(cValueTwo,cDBauthority)) iBackValue=2; } else iBackValue=3; } }
if(! mysql_eof(res)) return FALSE; mysql_free_result(res); mysql_close(&mysql); return iBackValue; }
关闭本页
没有相关教程
|