c/c++在visualstudio上链接msql，及其基本操作

一：工具及环境配置

           1.工具

                           visual studio 2013 +mysql-5.7.16-winx64

          

           2.环境配置

    

                            1.首先创建一个工程，此处以控制台工程为例

                

                   

             2.项目->属性->配置属性->c/c++->常规，把附加包目录改为mysql安装目录下的 include，如图

         

          3.项目->属性->配置属性->连接器->常规,把附加库目录改为 mysql安装目录下的 lib 目录

               

            4.连接器->输入的附加依赖项加入libmysql.lib

             

二、链接

 

          代码如下，以获取密码和注册函数为例

 

bool getPassword(char * username,char * &pwd){
	
	MYSQL mysql, *sock;
	mysql_init(&mysql);
	if (!(sock = mysql_real_connect(&mysql, "localhost", "root", "admin", "windowsPrograming", 0, NULL, 0)))
	{
		printf("Cannot connect to database:%s\n", mysql_error(sock));
		return false;
	}

	char sqlbuf[200];
	sprintf(sqlbuf, "select pass_word from userInfo where user_name=%s", username);
	//printf("%s\n", sqlbuf);

	if (mysql_query(sock, sqlbuf))
	{
		printf("Query Failed:%s", mysql_error(sock));
		return 0;
	}

	MYSQL_RES *res;
	MYSQL_ROW row;
	if (!(res = mysql_store_result(sock)))
	{
		printf("Failed to store result:%s", mysql_error(sock));
		return 0;
	}
	while (row = mysql_fetch_row(res))
	{
		pwd = (char *)malloc(sizeof(char *));
		strcpy(pwd, (char*)row[0]);
		//puts(row[0]);
	}
	mysql_free_result(res);
	mysql_close(sock);
	return true;
}

bool regist(char * username, char * password){
	MYSQL mysql, *sock;
	mysql_init(&mysql);
	if (!(sock = mysql_real_connect(&mysql, "localhost", "root", "admin", "windowsPrograming", 0, NULL, 0)))
	{
		printf("Cannot connect to database:%s\n", mysql_error(sock));
		return false;
	}

	char sqlbuf[200];
	sprintf(sqlbuf, "insert into  userInfo(user_name,pass_word) values('%s','%s')", username,password);


	if (mysql_query(sock, sqlbuf))
	{
		printf("Query Failed:%s", mysql_error(sock));
		return 0;
	}
	return true;
}

   完事儿！！！！！！！！！