Codeblocks MySQL Tutorial

You can conenct to MySQL and manipulate its data in Code::Blocks.

Code::Block is an open source C++ IDE built to meet the complicated development aims of the users. It is developed to be very extensible and configurable. The IDE has the following features: rapid custom build system, support for parallel builds, multi-target projects, user-defined watches, call stack, switch between threads, class browsing and smart indent. MySQL is a popular open source database management system. You can connect to MySQL database in Code::Block and manipulate the data such as retrieve, update, insert and delete.

Step 1

Download Code::Blocks setup file from its official website (see resources.) Double-click the setup file to start the installation. Follow the installation wizard until completion.

Step 2

Double-click the Code::Blocks icon to enter the development interface. Click "Settings," "Compiler and Debugger" and "Linker Settings." Click "Link Library" tab to open the dialog window. Click "Add" button and input "/usr/lib/"

Step 3

Click "Settings," "Compiler and Debugger" and "Search directories." Select "Compiler" and input "/usr/include/mysql." The development environment with MySQL is properly configured.

Step 4

Include the following files in your application:

#include <mysql.h> #include <MySQLManager.h>

Step 5

Connect to MySQL using the MySQLManager function:

MySQLManager::MySQLManager(string hosts, string userName, string password, string dbName, unsigned int port)
IsConnected = false;
this ->setHosts(hosts);
this ->setUserName(username);
this ->setPassword(password);
this ->setDBName(database);
this ->setPort(port); }

Step 6

Conduct SQL queries via function runSQLCommand:

bool MySQLManager::runSQLCommand(string sql)
mysql_real_query(&mySQLClient,sql.c_str(),(unsigned int)strlen(sql.c_str())); }

Step 7

Define your Main function using the said functions:

int main(){ MySQLManager sqlres("","root","search1","HR",3306); sqlres.initConnection(); sqlres.runSQLCommand("select * from employee"); sqlres.destroyConnection(); return 0; }

references & resources