mysql api简单的存取代码

最新推荐文章于 2024-10-01 12:01:24 发布

boxer2011111

最新推荐文章于 2024-10-01 12:01:24 发布

阅读量403

点赞数

文章标签： mysql api sql server null query database

本文链接：https://blog.csdn.net/boxer2011111/article/details/7077801

版权

引入Mysql/lib/opt/libmysql.dll，发布的时候需要带着这个DLL

typedef   struct   MSQLConnection 
{ 
        char*   sevname; 
int   port; 
char*   user; 
char*   pwd; 
char*   db; 
}MSQLConn; 

int   getIPlist(char*   iplist) 
{ 
MYSQL *   myData   ;     
MYSQL_RES *   res   ; 

MYSQL_ROW row   ; 


if   (myData   =   mysql_init((MYSQL*)   0)) 
msg= "ok,mysql_init   success! "; 
else{ 
msg= "error,mysql_init   fail! "; 
return   1; 
} 


//mysql初始化工作 
if   (mysql_real_connect(myData,     conn.sevname,   conn.user,   conn.pwd,   NULL,   conn.port,     NULL,   0   )) 
{ 

    
    msg= "ok,   connect   to   my_sql   server "; 
    
    if   (   mysql_select_db(   myData,   conn.db   )   <   0   ) 
{ 
msg= "Can 't   select   the   database   ! "   ; 
mysql_close(   myData   )   ; 
return   3   ; 
} 
}else{ 
msg= "Can 't   connect   to   my_sql   server "; 
mysql_close(   myData   )   ; 
return   2   ; 
} 


//取得一行 

char   *   q= "select   ip   from   boxinfo   "; 
if   (mysql_query(myData,q)) 
msg= "query   ok "; 


res=mysql_store_result(myData); 
if   (res==NULL){   
msg= "get   result   error "; 
mysql_close(   myData   )   ; 
return   5;   
}else 
msg= "getresult   ok "; 


if   (row   =   mysql_fetch_row(   res   )) 
strcat(iplist,row[0]); 


        while   (   row   =   mysql_fetch_row(   res   )   )   { 


strcat(iplist, ", "); 
strcat(iplist,row[0]); 



} 


mysql_close(   myData   )   ; 
return   0; 
}