C++连接Mysql数据库

#include <iostream>
#include <mysql.h>
using namespace std;

int main()
{
	const char host[] = "localhost";//host IP
	const char user[] = "use_name";//use_name
	const char pswd[] = "use_name";//password
	const char table[] = "database_name";//database_name
	unsigned int port = 3306;
	
	MYSQL myCont;
	mysql_init(&myCont);
	
	if (mysql_real_connect(&myCont, host, user, pswd, table, port, NULL, 0))
	{
		cout << "connect success!" << endl;
		char mysql[] = "insert into tb_report_test(source_id,title) values(1,'title')";
		mysql_query(&myCont, "SET NAMES UTF8");
		mysql_query(&myCont, mysql);
	}
	else
	{
		cout << "connect fail!" << endl;
	}
	mysql_close(&myCont);
	
	return 0;
}