#include <Windows.h>
#include <mysql.h>
#include <string>
#include <iostream>

using namespace std;
#pragma comment(lib,"D:\\Program Files\\mysql-5.7.17-winx64\\lib\\libmysql.lib") 

int main()
{

	const char user[] = "root";         
	const char pswd[] = "";        
	const char host[] = "localhost";    
	const char db[] = "demo";       
	unsigned int port = 3306;                
	MYSQL myCont;
	MYSQL_RES *result;
	MYSQL_ROW sql_row;
	int res;
	char *sql;
	mysql_init(&myCont);


	if (mysql_real_connect(&myCont, host, user, pswd, db, port, NULL, 0) != NULL)
	{
		sql="INSERT INTO user_info (NAME, img) VALUES ('c', null)";
		res = mysql_query(&myCont,sql);//²éѯ
		if (res)
		{
			cout << "INSERT sql1 failed!" << endl;
		}else
		{
			sql="INSERT INTO face_person (p_id, face_id) VALUES (LAST_INSERT_ID(), 2)";
			res = mysql_query(&myCont,sql);
			if (res)
			{
				cout << "INSERT sql2 failed!" << endl;
			}
		}

		printf("MySQL client version: %s\n", mysql_get_client_info());
		sql="select a.pid,a.name,a.img,b.face_id from user_info a,face_person b where a.pid = b.p_id";
		mysql_query(&myCont, "SET NAMES gbk"); //ÉèÖñàÂë¸ñʽ
		res = mysql_query(&myCont,sql);//²éѯ
		cout<<res<< endl;
		if (!res)
		{
			result = mysql_store_result(&myCont);
			if (result)
			{
				while (sql_row = mysql_fetch_row(result))//»ñÈ¡¾ßÌåµÄÊý¾Ý
				{
					cout<<"  pid:" << sql_row[0] << endl;
					cout<<"  name:" << sql_row[1] << endl;
					//cout<<"  img:" << sql_row[2] << endl;
					cout<<"  faceid:" << sql_row[3] << endl;
					cout<< endl;
				}
			}
		}
		else
		{
			cout << "query sql failed!" << endl;
		}

	}
	else
	{
		cout << "connect failed!" << endl;
	}
	


	if (result != NULL) 
		mysql_free_result(result);

	mysql_close(&myCont);
	system("pause");
	return 0;

}