#include "DBuntil.h"
#include <mysql.h>
#include <cstdio>

const char DBuntil::user[] = "root";         
const char DBuntil::pswd[] = "Basic@2017";        
const char DBuntil::host[] = "localhost";    
const char DBuntil::db[] = "demo";       
unsigned int DBuntil::port = 3306; 

MYSQL myCont;
MYSQL_RES *result;
MYSQL_ROW sql_row;
#pragma comment(lib,"D:\\Program Files\\mysql-5.7.17-winx64\\lib\\libmysql.lib") 

DBuntil::DBuntil()
{
	mysql_init(&myCont);
	mysql_real_connect(&myCont, host, user, pswd, db, port, NULL, 0);
}

DBuntil::~DBuntil()
{
	if (result != NULL) 
		mysql_free_result(result);

	mysql_close(&myCont);
}

person DBuntil::db_rearch(int f_id)
{
	person p={0,""};
	db_select(f_id,&p);
	//¶Ô½á¹¹Ì帳ֵ
	return p;
}

int DBuntil::db_select(int f_id,person* per)
{
	//sql="select a.p_id,b.`name`,b.img from face_person a,user_info b where a.face_id = " + f_id + " AND a.p_id = b.pid ";
	char c_sql[1024];
	sprintf( c_sql, "select a.p_id,b.`name`,b.img from face_person a,user_info b where a.face_id = %d AND a.p_id = b.pid " , f_id ); 
	
	//sprintf( sql, "select a.p_id,b.`name`,b.img from face_person a,user_info b where a.face_id = %d AND a.p_id = b.pid " , f_id ); 
	mysql_query(&myCont, "SET NAMES gbk"); //ÉèÖñàÂë¸ñʽ
	res = mysql_query(&myCont,c_sql);//²éѯ
	if (!res)
	{
		result = mysql_store_result(&myCont);
		if (result)
		{
			while (sql_row = mysql_fetch_row(result))//»ñÈ¡¾ßÌåµÄÊý¾Ý
			{
				per->p_id = atoi( sql_row[0]);
				per->name = sql_row[1];
			}
		}
	}
	else
	{
		//cout << "query sql failed!" << endl;
	}
	return per->p_id;
}