{"id":4466,"date":"2023-09-21T05:15:49","date_gmt":"2023-09-21T05:15:49","guid":{"rendered":"https:\/\/truelogic.org\/wordpress\/?p=4466"},"modified":"2023-09-21T05:15:49","modified_gmt":"2023-09-21T05:15:49","slug":"working-with-mysql-in-vc","status":"publish","type":"post","link":"https:\/\/truelogic.org\/wordpress\/2023\/09\/21\/working-with-mysql-in-vc\/","title":{"rendered":"Working with MySQL in VC++"},"content":{"rendered":"\n

OVERVIEW<\/strong><\/p>\n\n\n\n

One of the chief advantages of using Mysql databases in VC++ is that it is incredibly fast. Since almost every application which uses MySQL uses a server language or a high-level language which goes through several layers of the software stack to work with MySQL, the resulting execution is not really fast. In fact, it is well known that database operations are among the slowest parts of any application. But since modern hardware is cheap and fast and so are network speeds, users and developers never really feel that the database is slow and in most cases, the speed is perfectly fine for most use-cases. But the first time you run an SQL query in C++, you find out how fast the database can actually be. Queries which would take a few seconds to run on a server, execute almost instantly when using VC++. <\/p>\n\n\n\n

SETTING IT UP<\/strong><\/p>\n\n\n\n

As with all things related to C++ , setting up the whole MySQL Connector library is a little messy and it took me a couple of days to get it right, because there is so much conflicting info on the net regarding this. <\/p>\n\n\n\n

Download in the C++ connector library from https:\/\/dev.mysql.com\/downloads\/connector\/cpp\/<\/a><\/p>\n\n\n\n

Choose the Windows (x86, 64-bit) ZIP Archive for Release builds or Windows (x86, 64-bit) ZIP Archive Debug Binaries for Debug builds. This post assumes that we are using the Debug version. The only difference between the two zip files is that the file and folders will be slightly different. The process will remain the same.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Unzip the file into a folder. This will contain all the include,lib and DLL files required to build applications for MySQL. Assume the folder is d:\\mysql-connector-c++-8.1.0-winx64<\/em>. You can have your own folder, Just use your own folder name wherever it is mentioned below.<\/p>\n\n\n\n

Now we will create an Empty C\/C++ project for Console. Create an empty file called main.cpp. We will add the code later. The most important thing is to set up the correct folders and libraries. Note that we will be setting up the MySQL Connector library for static linking and not dynamic linking. That means we will link with the lib files. But during runtime we still need the supporting DLL files. The content below assumes you are doing a Debug build. Just change the folders as required for a Release Build.<\/p>\n\n\n\n

Go to Project->Properties->VC++ Directories<\/strong> and add a new entry to Include Directories<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Go to Project->Properties->C++->Preprocessor<\/strong> and add the following entry to Preprocessor Definitions<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

In Project->Properties->C++->Code Generation <\/strong>make sure Runtime Library<\/strong> is set to (\/MDd) for Debug builds or (\/MD) for Release builds.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Go to Project->Properties->Linker->General <\/strong>and add a new entry in Additional Library Directories<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Go to Project->Properties->Linker->Input <\/strong>and add a new entry in Additional Dependencies<\/strong><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

TESTING WITH CODE<\/strong><\/p>\n\n\n\n

In main.cpp, use the sample code below. You will have to change the mysql server connection details and the sql query as required for your database. <\/p>\n\n\n

\n#include <stdlib.h>\n#include <iostream>\n\nusing namespace std;\n\n\n\n#include <jdbc\/mysql_connection.h>\n#include <jdbc\/cppconn\/connection.h>\n#include <jdbc\/cppconn\/driver.h>\n#include <jdbc\/cppconn\/resultset.h>\n#include <jdbc\/cppconn\/statement.h>\n#include <jdbc\/cppconn\/prepared_statement.h>\n\n\nconst std::string HOST = "localhost";\nconst std::string DB = "test-db";\nconst std::string USER = "root";\nconst std::string PWD = "password";\n\nint main(int argc, char** argv) {\n\t\n\tcout << "Starting.." << endl;\n\n\ttry {\n\t\tsql::Driver *driver = NULL;\n\t\tsql::Connection* conn = NULL;\n\t\tsql::Statement* stmt = NULL;\n\t\tsql::ResultSet* rst = NULL;\n\n\t\tdriver = get_driver_instance();\n\t\tstd::string connString = "tcp:\/\/" + HOST + ":3306";\n\t\tconn = driver->connect(connString, USER, PWD);\n\t\tcout << "Database server connected" << endl;\n\n\t\tconn->setSchema(DB);\n\t\tstmt = conn->createStatement();\n\t\trst = stmt->executeQuery("select * from Graph");\n\t\twhile (rst->next()) {\n\t\t\tcout << "ID=" << rst->getInt("id") << "," << rst->getString("name") << endl;\n\t\t}\n\n\t\tdelete rst;\n\t\tdelete stmt;\n\t\tdelete conn;\n\t\tcout << "Closed connection" << endl;\n\t}\n\tcatch (sql::SQLException& ex) {\n\t\tcout << "Error:" << ex.what() << " Code: " << ex.getErrorCode() << endl;\n\n\t\treturn EXIT_FAILURE;\n\t}\n\tcout << "Ending" << endl;\n\n\treturn EXIT_SUCCESS;\n\n\n<\/pre><\/div>\n\n\n
CONCLUSION<\/strong><\/p>\n\n\n\n
If everything is fine, the code will compile and run. You can find several code samples in https:\/\/dev.mysql.com\/doc\/connector-cpp\/1.1\/en\/connector-cpp-examples-results.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
OVERVIEW One of the chief advantages of using Mysql databases in VC++ is that it is incredibly fast. Since almost every application which uses MySQL […]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":1087,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[302,278],"tags":[],"class_list":["post-4466","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cc","category-mysql-2"],"_links":{"self":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts\/4466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/comments?post=4466"}],"version-history":[{"count":24,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts\/4466\/revisions"}],"predecessor-version":[{"id":4500,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/posts\/4466\/revisions\/4500"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/media\/1087"}],"wp:attachment":[{"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/media?parent=4466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/categories?post=4466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/truelogic.org\/wordpress\/wp-json\/wp\/v2\/tags?post=4466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}