connectmysql.cpp

VC连接MySQL数据库

#include <afxsock.h>
#include <stdio.h>
#include<stdlib.h>
#include "mysql.h"

void main(){
   
   MYSQL_RES *res;
   MYSQL_ROW row;
   char *query;
   unsigned int t,r;
   MYSQL *mysql=NULL;
   mysql=mysql_init(mysql);
   if (!mysql_real_connect(mysql,"localhost","root","cyb","mysql",3306,NULL,0))
   {
       printf( "Error connecting to database: %s\n",mysql_error(mysql));
   }
   else printf("Connected...\n");

   query="select * from user ;";
   t=mysql_real_query(mysql,query,(unsigned int) strlen(query));
   if (t) 
   {
      printf("Error making query: %s\n", mysql_error(mysql));
   }
   else printf("Query made...\n");
   res=mysql_use_result(mysql);
   for(r=0;r<mysql_field_count(mysql);r++){
           row=mysql_fetch_row(res);           
           if(row==NULL) break;                 
           for(t=0;t<mysql_num_fields(res);t++)
          {
                   printf("%s ",row[t]);
           }
           printf("\n");
   }
     mysql_close(mysql);
}