2021-08-09

#include
#include <mysql.h>
#include
using namespace std;
MYSQL mysql; //进行连接
MYSQL_FIELD* fd;//字段列数组

char filed[32][32];//存字段名二维数组
MYSQL_RES* res;//这个结构代表返回行的一个查询结果集合
MYSQL_ROW column;//标识数据行的列
char sql[150];//sql语句

bool ConnectDatabase()
{ //初始化mysql
mysql_init(&mysql);
const char host[] = “localhost”;
const char username[] = “root”;
const char password[] = “7029”;
const char table[] = “”;
const int port = 3306;

if (!(mysql_real_connect(&mysql, host, username, password, table, port, NULL, 0)))
{
	cout << "error connect \n";
	return false;
}
else {


	cout << "connect successful";
	return true;

}

}

void freeconnect() {
mysql_free_result(res); //释放一个结果集合使用的内存
mysql_close(&mysql);//关闭服务器连接

}

bool QueryDatabase() {

strcpy(sql, "selelct * from user");
mysql_query(&mysql, "set name gbk");//设置编码格式避免乱码
if (mysql_query(&mysql, sql))//返回0 成功 返回1查询失败
{
	cout << "query error\n";
	return false;
}
else
{

	cout << "query success";



}
 //获取结果
if (!(res = mysql_store_result(&mysql)))
{
	cout << "can't get result from %s\n", mysql_error(&mysql);
	return false;

}
	//打印行的个数
cout << "number of dataline returned :%d\n", mysql_affected_rows(&mysql);
char* str_filed[32];//存储字段信息
for (int i = 0; i < 4; i++)//在已经知道字段数量的情况下获得字段名
{
	str_filed[i] = mysql_fetch_field(res)->name;//返回有字段结构的数组。
}
for (int i = 0; i < 4; i++)
	cout << "\t", str_filed[i];//进行打印

while (column = mysql_fetch_row(res))//在已经知道的字段数量情况下，逐个获取并打印
{

	cout << column[0], column[1], column[2],column[3]; //



}

return true;

}
bool querydatabase2() {

mysql_query(&mysql, "set names gbk");
if (mysql_query(&mysql, "selelct * from user")) {


	cout << "Query filed"<< mysql_error(&mysql);
	return false;


}
else
{
	cout << "query success\n";
}

res = mysql_store_result(&mysql);
cout << mysql_affected_rows(&mysql);
for (int i = 0; fd = mysql_fetch_field(res); i++)
	strcpy(filed[i], fd->name);
int j = mysql_num_fields(res);
for (int i = 0; i < j; i++)
	{
		cout << filed[i];

	}


while (column = mysql_fetch_row(res));
{for (int i = 0; i < j; i++)
	cout << column[i];

}


return true;

}

bool insertdata() {

strcpy(sql,“insert into user values(”","","")");

if (mysql_query(&mysql, sql))//执行sql语句
{
cout << “query error”;
return false;
}
else
{
cout << “query successful”;
return true;
}

}

void main() {

cout << "ddd";

}