VC操作MySQL数据库

首先需要下载mysql server，并安装，安装好之后，把include和lib设置一下。

代码如下：

#include <windows.h>
#include <stdio.h>
#include <mysql.h>
#pragma comment(lib, "libmysql.lib")

int main()
{
	unsigned short Port = 3306;
    char *IPAddress = "114.112.90.57";
    char *UserName = "user";
    char *Password = "123";
    char *DBName = "mobile";
    unsigned long i;
    printf("Start... \n");
    
    MYSQL *ssock;
    MYSQL_RES   *res;      
    MYSQL_ROW   row;   
    //char execsql[500];
    ssock = (MYSQL *)malloc(sizeof(MYSQL));  
    //在某些版本中，不需要该初始化工作，可观看mysql.H以及readme
    mysql_init(ssock);
    if(ssock == NULL)
    {
        printf("EROR: MySQL ssock init error. \n");
        return FALSE;
    }
    printf("MySQL ssock init OK. \n");
    
    //连接到指定的数据库
    ssock = mysql_real_connect(ssock, IPAddress, UserName, Password, NULL, Port, NULL, 0);
    if(!ssock)
    {
        printf("conn fail... \n");
        //memcpy(eee, mysql_error(ssock), 20);
        //fprintf(stderr, "Failed to connect to database: Error: %s ", mysql_error(ssock));
        
        //printf("%c ", eee);
        unsigned int mtint = mysql_errno(ssock);
        //printf("%d ");
        return FALSE;
    }
    printf("MySQL connnect OK... \n");
    
    if(mysql_select_db(ssock, DBName) != 0)
    {
        printf("select db error. \n");
        return FALSE;
    }
    printf("select db OK. \n");
    printf("version=%d \n", mysql_get_server_version(ssock));
    //SQL查询语句
    if(mysql_query( ssock,"SELECT * FROM  UserInfo"))  
    {
        printf("mysql_query() Error, %s\n", mysql_error(ssock));  
    }
    
    if( !(res = mysql_store_result(ssock)) )  
    {
        printf("mysql_store_result() Error, %s\n", mysql_error(ssock));  
    } 
    
    while( (row = mysql_fetch_row(res)) )
    {          
        for(i=0 ; i<mysql_num_fields(res); i++)  
        {
            printf("%s ",row[i]);
        }    
        printf("\n");
    }      
    mysql_free_result(res);   

	
    //执行SQL插入语句,第一列自增
    if(mysql_query( ssock,"insert into UserInfo SET userName=\'lmy4\', userLogName=\'lmy4\', userLogPWD=\'000000\', userRole=1,userState=0 " ))  
    {
        printf("mysql_query() Error, %s\n", mysql_error(ssock));  
    }
	

    mysql_close(ssock);
    printf("End... \n");
    
	getchar();
    return TRUE;

}