connect.cpp

实现vc对mysql的连接

// connect.cpp : Defines the entry point for the console application.
//

#include "stdafx.h"
#include <afxsock.h> 

#include <stdio.h>
#include <tchar.h>
#include <winsock.h>
#include <mysql.h>
#include <string.h>
#include <windows.h> 
//libmysql.lib  mysqlclient.lib mysys.lib 
//#pragma comment(lib,"C:\\Program Files\\MySQL\\MySQL Server 5.0\\lib\\opt\\libmysql.lib")

void main()     
{     
    
	MYSQL  data;     
	MYSQL   *pdata;     
	MYSQL_RES   *result;     
	MYSQL_ROW   row;     
	char sqlcommand[80];  

     mysql_init(&data);
    
//	pdata = mysql_real_connect( &data,"127.0.0.1",   "root",   "yhj", NULL, 0, NULL, CLIENT_MULTI_STATEMENTS);
    pdata = mysql_real_connect( &data,"127.0.0.1", "root", "yhj", NULL, 0, NULL, 0);
	if(!pdata){     
		printf("ok,   connected!\n");     
	mysql_select_db(   pdata,   "enron");     
		sprintf( sqlcommand, "select * from %s",   "help_topic");     
		mysql_query(  pdata,  sqlcommand);     
		result = mysql_use_result( pdata);     
		row = mysql_fetch_row(result);  
			printf("ok,   1connected!\n");  
		//   获得结果中的下一条记录     
		mysql_close(pdata);  
	}  
	else 
		printf("fail");
    
}