mysql简单代码_mysql api简单的存取代码

引入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;

}