C++ mysql read table
2022/6/16 6:21:07
本文主要是介绍C++ mysql read table,对大家解决编程问题具有一定的参考价值,需要的程序猿们随着小编来一起学习吧!
//Utill.h #ifndef Util_H #define Util_H #include <chrono> #include <ctime> #include <fstream> #include <iostream> #include "mysql_connection.h" #include <cppconn/driver.h> #include <cppconn/exception.h> #include <cppconn/resultset.h> #include <cppconn/statement.h> #include <cppconn/prepared_statement.h> #include <sstream> #include <stdlib.h> #include <thread> #include <unistd.h> #include <uuid/uuid.h> #include <vector> using namespace std; class Util { public: static char *uuidValue; static char *dtValue; char *getTime(); char *getUuid(); void readSQL5(); }; #endif //Util.cpp #include "Model/Util.h" char *Util::dtValue = (char *)malloc(20); char *Util::uuidValue = (char *)malloc(40); void Util::readSQL5() { try { sql::Driver *driver; sql::Connection *conn; sql::Statement *stmt; sql::PreparedStatement *pstmt; sql::ResultSet *res; sql::PreparedStatement *tablePstmt; sql::ResultSet *tableRes; driver = get_driver_instance(); conn = driver->connect("tcp://127.0.0.1:3306", "root", "Root0001!"); conn->setSchema("db"); string selectTable = "select table_name from information_schema.tables where table_schema='db'"; pstmt = conn->prepareStatement(selectTable); res = pstmt->executeQuery(); vector<string> tableVec; while (res->next()) { tableVec.push_back(res->getString(1)); } vector<string>::iterator itr = tableVec.begin(); cout << "Table:"; while (itr != tableVec.end()) { cout << *itr << "\t"; itr++; } cout << endl << endl; uint64_t num = 0; int loop = 0; for (auto &tableName : tableVec) { string sql = "select * from " + tableName; tablePstmt = conn->prepareStatement(sql); tableRes = tablePstmt->executeQuery(); while (tableRes->next()) { if (++num % 500000 == 0) { cout <<"Loop="<<++loop << ",Num=" << num << ",Index=" << tableRes->getInt(1) << ",Id=" << tableRes->getInt64(2) << ",Name=" << tableRes->getString(3) << ",Title=" << tableRes->getString(4) << endl; } } cout << getTime() << ",finished in retrieving from " << tableName << endl<<endl; } conn->close(); cout << "IsClosed=" << conn->isClosed() << endl; cout << getTime() << ",finished in void Util::readSQL5()!" << endl; } catch (sql::SQLException &ex) { cout << "#ERR: SQLException in " << __FILE__ << "," << __FUNCTION__ << "," << __LINE__ << endl; cout << ex.what() << endl; cout << "Error code:" << ex.getErrorCode() << ",state:" << ex.getSQLState() << endl; return; } } char *Util::getTime() { time_t rawTime = time(NULL); struct tm tmInfo = *localtime(&rawTime); strftime(dtValue, 20, "%Y%m%d%H%M%S", &tmInfo); return dtValue; } char *Util::getUuid() { uuid_t newUUID; uuid_generate(newUUID); uuid_unparse(newUUID, uuidValue); return uuidValue; }
//main.cpp #include "Model/Util.h" void readTable5(); int main(int args,char **argv) { try { readTable5(); } catch(const std::exception& e) { std::cerr << e.what() << '\n'; } } void readTable5() { Util ul; ul.readSQL5(); }
Compile:
g++ -g -std=c++2a -I. *.cpp ./Model/*.cpp -o h1 -luuid -lpthread -lmysqlcppconn;
Run
time ./h1 -1;
这篇关于C++ mysql read table的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!
- 2024-04-26MySQL查出时间比实际晚8小时的解决方案
- 2024-04-01JPA不识别MySQL的枚举类型
- 2024-03-30mysql数据库表卡死解决方法
- 2024-03-15MySQL多数据源笔记5-ShardingJDBC实战
- 2024-03-11natural join mysql
- 2024-03-11关于VS2017,VS2015 中利用 EF使用Mysql 不显示数据源问题解决方案
- 2024-02-26mysql 阿里云xb后缀备份文件恢复-icode9专业技术文章分享
- 2024-02-22docker mysql 5.7
- 2024-02-18从 20 多套 MySQL 到 1 套 TiDB丨骏伯网络综合运营管理平台应用实践
- 2024-02-07mysql 外键索引入门介绍,为什么工作中很少有人使用?