c++连接数据库

最新推荐文章于 2026-05-03 14:19:49 发布

原创最新推荐文章于 2026-05-03 14:19:49 发布 · 4.3k 阅读

10 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

c++

MySQL

本文详细介绍了使用C++连接MySQL数据库的方法，包括配置、连接函数的编写，如`ConnectDatabase()`、`ConnectDatabase(const char*, const char*, const char*, const char*, int)`、`ConnextDatabase(const char*)`，以及查询数据和显示数据的函数。示例代码展示了如何从数据库获取数据并进行处理。" 116662137,10896739,Android Hook 技术解析与面试实战,"['Android开发', '移动开发', '面试准备', '剑指Offer', '编程算法']

1.进行配置

2.代码如下

LinkWithMysql.h：

#pragma once
#define _CRT_SECURE_NO_WARNINGS
#include<iostream>
#include<Windows.h>
#include<WinSock.h>
#include<mysql.h>
#include<vector>
#include <string>
#include <cstdlib>

using namespace std;

bool ConnectDatabase();
bool ConnectDatabase(const char* host, const char* userName, const char* password, const char* datbaseName, int number);
bool ConnextDatabase(const char* datbaseName);

bool showDatabaseMessage();
bool getDatabaseMessage(string* strName, string* strNum);//返回表每一列信息
bool getDatabaseMessage(string* strName, string* strNum, string tableName);
bool getDatabaseMessage(vector<string>& strName, vector<string>& strNum, string tableName);
bool getDatabaseMessage(vector<string>& y, vector<string>& u, vector<string>& ni, vector<string>& y_b, vector<string>& u_b, vector<string>& ni_b, vector<string>& n, vector<string>& r, string tableName);
void showDatabase();//显示数据库中数据信息
void changeType(vector<string>& y, vector<string>& u, vector<string>& ni, vector<string>& y_b, vector<string>& u_b, vector<string>& ni_b, vector<string>& n, vector<string>& r, vector<double>& sy, vector<double>& su, vector<double>& sni, vector<double>& sy_b, vector<double>& su_b, vector<double>& sni_b, vector<double>& sn, vector<double>& sr);//转换类型
void initializeProject(vector<double>& sy, vector<double>& su, vector<double>& sni, vector<double>& sy_b, vector<double>& su_b, vector<double>& sni_b, vector<double>& sn, vector<double>& sr,string databaseName,string tableName);//初始化程序，包括连接数据库拿到数据等操作。

LinkWithMysql.cpp

#include"LinkWithMysql.h"
#pragma comment(lib,"libmysql.lib")
#pragma comment(lib,"wsock32.lib")
MYSQL* mysql = new MYSQL; //mysql连接
MYSQL_FIELD* fd; //字段列数组
char field[32][32]; //存字段名二维数组
MYSQL_RES* res; //这个结构代表返回行的一个查询结果集
MYSQL_ROW column; //一个行数据的类型安全(type-safe)的表示，表示数据行的列
char query[150]; //查询语句
bool ConnectDatabase()
{
//初始化mysql
mysql_init(mysql);
//返回false则连接失败，返回true则连接成功
if (!(mysql_real_connect(mysql, "localhost", "root", "888888", "db1", 3306, NULL, 0))) //中间分别是主机，用户名，密码，数据库名，端口号（可以写默认0或者3306等），可以先写成参数再传进去
{
printf("Error connecting to database:%s\n", mysql_error(mysql));
return false;
}
else
{
return true;
}
return true;
}
bool ConnectDatabase(const char* host, const char* userName, const char* password, const char* datbaseName, int number) {
//初始化mysql
mysql_init(mysql);
//返回false则连接失败，返回true则连接成功
if (!(mysql_real_connect(mysql, host, userName, password, datbaseName, number, NULL, 0))) //中间分别是主机，用户名，密码，数据库名，端口号（可以写默认0或者3306等），可以先写成参数再传进去
{
printf("Error connecting to database:%s\n", mysql_error(mysql));
return false;
}
else
{
return true;
}
return true;
}
bool ConnextDatabase(const char* datbaseName) {
//初始化mysql
mysql_init(mysql);
//返回false则连接失败，返回true则连接成功
if (!(mysql_real_connect(mysql, "localhost", "root", "888888", datbaseName, 3306, NULL, 0))) //中间分别是主机，用户名，密码，数据库名，端口号（可以写默认0或者3306等），可以先写成参数再传进去
{
printf("Error connecting to database:%s\n", mysql_error(mysql));
return false;
}
else
{
return true;
}
return true;
}
bool showDatabaseMessage()
{
sprintf_s(query, "select * from Student"); //执行查询语句，这里是查询所有，user是表名，不用加引号，用strcpy也可以
mysql_query(mysql, "set names gbk"); //设置编码格式（SET NAMES GBK也行），否则cmd下中文乱码
//返回0 查询成功，返回1查询失败
if (mysql_query(mysql, query)) //执行SQL语句
{
printf("Query failed (%s)\n", mysql_error(mysql));
return false;
}
else
{
printf("query success\n");
}
//获取结果集
if (!(res = mysql_store_result(mysql))) //获得sql语句结束后返回的结果集
{
printf("Couldn't get result from %s\n", mysql_error(mysql));
return false;
}

//打印数据行数
//printf("number of dataline returned: %d\n", mysql_affected_rows(mysql));
cout << mysql_affected_rows(mysql) << endl;
//获取字段的信息
char* str_field[32]; //定义一个字符串数组存储字段信息
for (int i = 0; i < 2; i++) //在已知字段数量的情况下获取字段名
{
str_field[i] = mysql_fetch_field(res)->name;
}
for (int i = 0; i < 2; i++) //打印字段
printf("%10s\t", str_field[i]);
printf("\n");
//打印获取的数据
while (column = mysql_fetch_row(res)) //在已知字段数量情况下，获取并打印下一行
{
printf("%10s\t%10s\n", column[0], column[1]); //column是列数组
}
return true;
}
bool getDatabaseMessage(string* strName, string* strNum) {
sprintf_s(query, "select * from Student"); //执行查询语句，这里是查询所有，user是表名，不用加引号，用strcpy也可以
mysql_query(mysql, "set names gbk"); //设置编码格式（SET NAMES GBK也行），否则cmd下中文乱码
//返回0 查询成功，返回1查询失败
if (mysql_query(mysql, query)) //执行SQL语句
{
printf("Query failed (%s)\n", mysql_error(mysql));
return false;
}
else
{
printf("query success\n");
}
//获取结果集
if (!(res = mysql_store_result(mysql))) //获得sql语句结束后返回的结果集
{
printf("Couldn't get result from %s\n", mysql_error(mysql));
return false;
}

//打印数据行数
//printf("number of dataline returned: %d\n", mysql_affected_rows(mysql));
//获取字段的信息
char* str_field[32]; //定义一个字符串数组存储字段信息
for (int i = 0; i < 2; i++) //在已知字段数量的情况下获取字段名
{
str_field[i] = mysql_fetch_field(res)->name;
}
printf("\n");
//打印获取的数据
int row1 = 0;
int row2 = 0;
while (column = mysql_fetch_row(res)) //在已知字段数量情况下，获取并打印下一行
{
strName[row1] = column[0];
strNum[row2] = column[1];
row1++;
row2++;
}
return true;
}
bool getDatabaseMessage(string* strName, string* strNum, string tableName) {
string querystr = "select * from ";
querystr = querystr + tableName;
sprintf_s(query, querystr.c_str()); //执行查询语句，这里是查询所有，user是表名，不用加引号，用strcpy也可以
mysql_query(mysql, "set names gbk"); //设置编码格式（SET NAMES GBK也行），否则cmd下中文乱码
//返回0 查询成功，返回1查询失败
if (mysql_query(mysql, query)) //执行SQL语句
{
printf("Query failed (%s)\n", mysql_error(mysql));
return false;
}
else
{
printf("query success\n");
}
//获取结果集
if (!(res = mysql_store_result(mysql))) //获得sql语句结束后返回的结果集
{
printf("Couldn't get result from %s\n", mysql_error(mysql));
return false;
}

//打印数据行数
//printf("number of dataline returned: %d\n", mysql_affected_rows(mysql));
//获取字段的信息
char* str_field[32]; //定义一个字符串数组存储字段信息
for (int i = 0; i < 2; i++) //在已知字段数量的情况下获取字段名
{
str_field[i] = mysql_fetch_field(res)->name;
}
printf("\n");
//打印获取的数据
int row1 = 0;
int row2 = 0;
while (column = mysql_fetch_row(res)) //在已知字段数量情况下，获取并打印下一行
{
strName[row1] = column[0];
strNum[row2] = column[1];
row1++;
row2++;
}
return true;
}
bool getDatabaseMessage(vector<string>& strName, vector<string>& strNum, string tableName) {
string querystr = "select * from ";
querystr = querystr + tableName;
sprintf_s(query, querystr.c_str()); //执行查询语句，这里是查询所有，user是表名，不用加引号，用strcpy也可以
mysql_query(mysql, "set names gbk"); //设置编码格式（SET NAMES GBK也行），否则cmd下中文乱码
//返回0 查询成功，返回1查询失败
if (mysql_query(mysql, query)) //执行SQL语句
{
printf("Query failed (%s)\n", mysql_error(mysql));
return false;
}
else
{
printf("query success\n");
}
//获取结果集
if (!(res = mysql_store_result(mysql))) //获得sql语句结束后返回的结果集
{
printf("Couldn't get result from %s\n", mysql_error(mysql));
return false;
}

//打印数据行数
//printf("number of dataline returned: %d\n", mysql_affected_rows(mysql));
//获取字段的信息
char* str_field[32]; //定义一个字符串数组存储字段信息
for (int i = 0; i < 2; i++) //在已知字段数量的情况下获取字段名
{
str_field[i] = mysql_fetch_field(res)->name;
}
printf("\n");
//打印获取的数据
while (column = mysql_fetch_row(res)) //在已知字段数量情况下，获取并打印下一行
{
strName.push_back(column[0]);
strNum.push_back(column[1]);
}
return true;
}
bool getDatabaseMessage(vector<string>& y, vector<string>& u, vector<string>& ni, vector<string>& y_b, vector<string>& u_b, vector<string>& ni_b, vector<string>& n, vector<string>& r, string tableName) {
string querystr = "select * from ";
querystr = querystr + tableName;
sprintf_s(query, querystr.c_str()); //执行查询语句，这里是查询所有，user是表名，不用加引号，用strcpy也可以
mysql_query(mysql, "set names gbk"); //设置编码格式（SET NAMES GBK也行），否则cmd下中文乱码
//返回0 查询成功，返回1查询失败
if (mysql_query(mysql, query)) //执行SQL语句
{
printf("Query failed (%s)\n", mysql_error(mysql));
return false;
}
else
{
/*printf("query success\n");*/
}
//获取结果集
if (!(res = mysql_store_result(mysql))) //获得sql语句结束后返回的结果集
{
printf("Couldn't get result from %s\n", mysql_error(mysql));
return false;
}

//打印数据行数
//printf("number of dataline returned: %d\n", mysql_affected_rows(mysql));
//获取字段的信息
char* str_field[32]; //定义一个字符串数组存储字段信息
for (int i = 0; i < 8; i++) //在已知字段数量的情况下获取字段名
{
str_field[i] = mysql_fetch_field(res)->name;
}
printf("\n");
//打印获取的数据
while (column = mysql_fetch_row(res)) //在已知字段数量情况下，获取并打印下一行
{
//cout << sizeof(column) / sizeof(column[0]) << endl;
y.push_back(column[0]);
u.push_back(column[1]);
ni.push_back(column[2]);
y_b.push_back(column[3]);
u_b.push_back(column[4]);
ni_b.push_back(column[5]);
n.push_back(column[6]);
r.push_back(column[7]);
/*cout << column[0] << endl;
cout << column[1] << endl;
cout << column[2] << endl;
cout << column[3] << endl;
cout << column[4] << endl;
cout << column[5] << endl;
cout << column[6] << endl;
cout << column[7] << endl;*/

}
return true;
}
void showDatabase() {
vector<string> y = {};
vector<string> u = {};
vector<string> ni = {};
vector<string> y_b = {};
vector<string> u_b = {};
vector<string> ni_b = {};
vector<string> n = {};
vector<string> r = {};
getDatabaseMessage(y, u, ni, y_b, u_b, ni_b, n, r, "fifthord");
for (vector<string>::iterator it = y.begin(); it != y.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<string>::iterator it = u.begin(); it != u.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<string>::iterator it = ni.begin(); it != ni.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<string>::iterator it = y_b.begin(); it != y_b.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<string>::iterator it = u_b.begin(); it != u_b.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<string>::iterator it = ni_b.begin(); it != ni_b.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<string>::iterator it = n.begin(); it != n.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<string>::iterator it = r.begin(); it != r.end(); it++) {
cout << *it << "\t";
}
cout << endl;
}
void changeType(vector<string>& y, vector<string>& u, vector<string>& ni, vector<string>& y_b, vector<string>& u_b, vector<string>& ni_b, vector<string>& n, vector<string>& r, vector<double>& sy, vector<double>& su, vector<double>& sni, vector<double>& sy_b, vector<double>& su_b, vector<double>& sni_b, vector<double>& sn, vector<double>& sr) {
for (int i = 0; i < 7; i++) {
//getDatabaseMessage(sy, su, sni, sy_b, su_b, sni_b, sn, sr, "fifthord");
sy.push_back(atof(y[i].c_str()));
su.push_back(atof(u[i].c_str()));
sni.push_back(atof(ni[i].c_str()));
sy_b.push_back(atof(y_b[i].c_str()));
su_b.push_back(atof(u_b[i].c_str()));
sni_b.push_back(atof(ni_b[i].c_str()));
sn.push_back(atof(n[i].c_str()));
sr.push_back(atof(r[i].c_str()));
}
/*for (vector<double>::iterator it = sy.begin(); it != sy.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<double>::iterator it = su.begin(); it != su.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<double>::iterator it = sni.begin(); it != sni.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<double>::iterator it = sy_b.begin(); it != sy_b.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<double>::iterator it = su_b.begin(); it != su_b.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<double>::iterator it = sni_b.begin(); it != sni_b.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<double>::iterator it = sn.begin(); it != sn.end(); it++) {
cout << *it << "\t";
}
cout << endl;
for (vector<double>::iterator it = sr.begin(); it != sr.end(); it++) {
cout << *it << "\t";
}
cout << endl;*/

}
void initializeProject(vector<double>& y, vector<double>& u, vector<double>& ni, vector<double>& y_b, vector<double>& u_b, vector<double>& ni_b, vector<double>& n, vector<double>& r, string databaseName, string tableName) {
ConnextDatabase(databaseName.c_str());
//showDatabaseMessage();
/*string strName[100];
string strNum[100];*/
vector<string> sy = {};
vector<string> su = {};
vector<string> sni = {};
vector<string> sy_b = {};
vector<string> su_b = {};
vector<string> sni_b = {};
vector<string> sn = {};
vector<string> sr = {};
getDatabaseMessage(sy, su, sni, sy_b, su_b, sni_b, sn, sr,tableName);
//for (int i = 0; i < 7; i++) {
// getDatabaseMessage(sy, su, sni, sy_b, su_b, sni_b, sn, sr, "fifthord");
// y.push_back(atof(sy[i].c_str()));
// u.push_back(atof(su[i].c_str()));
// ni.push_back(atof(sni[i].c_str()));
// y_b.push_back(atof(sy_b[i].c_str()));
// u_b.push_back(atof(su_b[i].c_str()));
// ni_b.push_back(atof(sni_b[i].c_str()));
// n.push_back(atof(sn[i].c_str()));
// r.push_back(atof(sr[i].c_str()));
//}
///*for (vector<double>::iterator it = y.begin(); it != y.end(); it++) {
// cout << *it << "\t";
//}
//cout << endl;
//for (vector<double>::iterator it = u.begin(); it != u.end(); it++) {
// cout << *it << "\t";
//}
//cout << endl;
//for (vector<double>::iterator it = ni.begin(); it != ni.end(); it++) {
// cout << *it << "\t";
//}
//cout << endl;
//for (vector<double>::iterator it = y_b.begin(); it != y_b.end(); it++) {
// cout << *it << "\t";
//}
//cout << endl;
//for (vector<double>::iterator it = u_b.begin(); it != u_b.end(); it++) {
// cout << *it << "\t";
//}
//cout << endl;
//for (vector<double>::iterator it = ni_b.begin(); it != ni_b.end(); it++) {
// cout << *it << "\t";
//}
//cout << endl;
//for (vector<double>::iterator it = n.begin(); it != n.end(); it++) {
// cout << *it << "\t";
//}
//cout << endl;
//for (vector<double>::iterator it = r.begin(); it != r.end(); it++) {
// cout << *it << "\t";
//}
//cout << endl;*/
changeType(sy, su, sni, sy_b, su_b, sni_b, sn, sr, y, u, ni, y_b, u_b, ni_b, n, r);//转换类型
}

main():

#include<iostream>
#include"LinkWithMysql.h"

using namespace std;
int main()
{
vector<double> y = {};
vector<double> u = {};
vector<double> ni = {};
vector<double> y_b = {};
vector<double> u_b = {};
vector<double> ni_b = {};
vector<double> n = {};
vector<double> r = {};
initializeProject(y, u, ni, y_b, u_b, ni_b, n, r,"db1","fifthord");//初始化，数据库名，表名
//以上初始化完成
return 0;
}

标签

#mysql #c++