Library Management System Project in C++

   January 8, 2023

In this article, we will build Library Management System Project in C++ and MySQL with source code. This project is a console application written entirely in C++ language and for the database, we have used the MySQL database with the help of Xampp software.

Features

  • The admin can log in to the system to manage the book stocks and view the students’ logs to check the issued and deposited books
  • The student can register and login into the system to view all books, search for a book, issue a book, return a book and view his account details

Setup the Development Environment

To successfully develop and run the application you will need to install the following software and follow the below step.

Now you need to set up the Code::Blocks IDE to be able to connect your C++ application to the MySQL database. You can follow this tutorial.

NOTE: Use Code::Blocks 16.x version to connect to the database as the latest version has some issues with connecting to the database.

MySQL setup

We will use Xampp software to easily manage and use MySql on the system. 

  • Open the Xampp software and run Apache and MySql. 
  • Go to your browser window and search for localhost/phpmyadmin/
  • Run the following SQL command. These commands will create a database with the name library and two tables within this database with the names, users and book.
  • The default login credential for Admin is username admin and password admin
CREATE DATABASE library; 

use library; 

CREATE TABLE users (
 username varchar(30),
 password varchar(30) 
); 

INSERT INTO users (username, password) VALUES ('admin', 'admin');

CREATE TABLE book (
 BookNo int, 
Book_Name varchar(30), 
Author varchar(30), 
Issued_By varchar(30) 
);

Complete Code for Library Management System Project in C++

Open Code::Blocks IDE and create a new project with the name LibraryManagement. Now copy the below code in the main.cpp file and run it.

#include <iostream>
#include<winsock.h>
#include<windows.h>
#include<sstream>
#include<ctime>
#include<string>
#include<mysql.h>
#include<cstring>
#include<conio.h>
#include<cstring>
#include<map>
using namespace std;


int users =0;
int count_attempt=0;
int curr_user=0;
int user_no=0;
map <string,string> issued;
string loggedin_user="";

void showtime()
{
	time_t now = time(0);
	char *dt = ctime(&now);
	cout<<" \t \t \t \t \t " << dt;
	cout<<endl<<endl;
}

class user
{
private:
string username;
string password;
public:
void adduser()
{
	MYSQL *conn;
	conn = mysql_init(0);
	conn = mysql_real_connect(conn ,"localhost" ,"root", "", "library" ,0,NULL,0);
	if(conn)
        cout<<"connected"<<endl;
    else cout<<"not connected"<<endl;

	cout<<"Username:";
	cin>>username;
	cout<<"Password:";
	cin>>password;

	int qstate =0;
	stringstream ss;
	ss<<"INSERT INTO users(username,password) VALUES('"<<username<<"','"<<password<<"')";
	string query =  ss.str();
        const char* q= query.c_str();
        qstate = mysql_query(conn,q);
        if(qstate==0)
            cout<<" \t \t \t \t \t Record Inserted Successfully"<<endl;
        else cout<<"Failed"<<endl;

	users++;
}

// This method is protected for admin use only
void no_users()
{

   if(loggedin_user!="admin")
    {
        cout<<" \t \t \t \t \t Not Authorized. Only admin can view all users details"<<endl;
        return ;
    }

	cout<<"The users are:  "<<endl;
	MYSQL* conn;
	MYSQL_ROW row;
	MYSQL_RES* res;
	conn = mysql_init(0);
	conn = mysql_real_connect(conn ,"localhost" ,"root", "", "library" ,0,NULL,0);
	if(conn)
    {
        int qstate = mysql_query(conn,"SELECT username FROM users");
    //    bool flag=false;
        if(!qstate)
        {
            res = mysql_store_result(conn);
            int i=1;
            while(row = mysql_fetch_row(res))
                {
                    cout<<i<<"."<<row[0]<<endl;
                    i++;
                }
        }
    }


}

// This method is used to take user input and check against the data in the database to login to the system
void login()
{
	if(curr_user==1)
	{
	cout<<" \t \t \t \t \t Already logged in";
	return;
	}
	if(count_attempt==3)
	{
		cout<<endl<<endl;
		cout<<" \t \t \t \t \t No more attempts";
		exit(0);
	}
	cout<<"Enter Username and Password to Login"<<endl;
	string user_name;
	string pass_word;

	cout<<"Username:";
	cin>>user_name;
	cout<<"Password:";
	cin>>pass_word;
	cin.ignore();
	system("cls");


	MYSQL* conn;
	MYSQL_ROW row;
	MYSQL_RES* res;
	conn = mysql_init(0);
	conn = mysql_real_connect(conn ,"localhost" ,"root", "", "library" ,0,NULL,0);
	if(conn)
    {
        int qstate = mysql_query(conn,"SELECT username,password FROM users");
        bool flag=false;
        if(!qstate)
        {
            res = mysql_store_result(conn);
            while(row = mysql_fetch_row(res))
                {
                if(row[0]==user_name && row[1]==pass_word)
                {
                        loggedin_user = row[0];
                        cout<<" \t \t \t \t \t \t Login Successful"<<endl;
                        cout<<" \t \t \t \t \t \t WELCOME "<< loggedin_user<<endl;
                        curr_user=1;
                        flag=true;
                        break;
                }
                }
                if(!flag)
                {
                    cout<<" \t \t \t \t \t \t Incorrect Username or Password"<<endl;
                    cout<<" \t \t \t \t \t \t Press Enter and Try again"<<endl;
                    cin.ignore();
                    system("cls");
                    count_attempt++;
                    login();
                }


        }
        else
        {
            cout<<" \t \t \t \t \t No Accounts Registered";
        }

    }
}

	void logout()
	{
		curr_user=0;
	}


};
class book : public user
{
	long long int bno;
	string bookname;
	string aname;
	string default_issed = "None";
	public:
	    // This method is protected for admin use only
		void addbook()
		{
			if(loggedin_user=="")
			{
				cout<<" \t \t \t \t \t Please Login"<<endl;
				return ;
			}
            if(loggedin_user!="admin")
			{
				cout<<" \t \t \t \t \t Not Authorized. Only admin can add new books"<<endl;
				return ;
			}

			cout<<"Enter book number \n";
			cin>>bno;
            cin.ignore();
			cout<<"Enter bookname: \n";
			cin>>bookname;
            cin.ignore();
			cout<<"Enter author name: \n";
			cin>>aname;
            string nul="";
			MYSQL* conn;
			conn = mysql_init(0);
			conn = mysql_real_connect(conn ,"localhost" ,"root", "", "library" ,0,NULL,0);
			stringstream ss;
			ss<<"INSERT INTO book(BookNo,Book_Name,Author,Issued_By) VALUES('"<<bno<<"','"<<bookname<<"','"<<aname<<"','"<<default_issed<<"')";
			int qstate=0;
			string query =  ss.str();
            const char* q= query.c_str();
            qstate = mysql_query(conn,q);
            if(qstate==0)
            {
            cout<<" \t \t \t \t \t Book Added Successfully!"<<endl;
            return;
            }
            else
            {
                cout<<" \t \t \t \t \t Failed"<<endl;
                return;
            }

		}
        
        // This method is used to search for a particular book in the database
		bool searchbook(string no)
		{
			if(loggedin_user=="")
			{
				 cout<<" \t \t \t \t \t Please Login"<<endl;
				 return false;
			}

			bool flag=false;
			MYSQL* conn;
            MYSQL_ROW row;
            MYSQL_RES* res;
            conn = mysql_init(0);
            conn = mysql_real_connect(conn ,"localhost" ,"root", "", "library" ,0,NULL,0);
            if(conn)
            {
            int qstate = mysql_query(conn,"SELECT BookNo,Book_Name,Author from book");
            if(!qstate)
            {
                res = mysql_store_result(conn);
                while(row = mysql_fetch_row(res))
                {
                        if(row[0]== no)
                        {
                            cout<<"Book Details are"<<endl;
                            cout<<row[0]<<"  "<<row[1]<<"  "<<row[2]<<"  "<<row[3]<<endl;
                            flag=true;
                            return true;
                        }
                }
            }
            else cout<<"Failed"<<endl;
            if(!flag)
                {
                    cout<<"Book Not Found"<<endl;
                    return false;
                }
            }
		}
		
        // This method is used to view all the books in the database
		void allbooks()
		{
			MYSQL* conn;
            MYSQL_ROW row;
            MYSQL_RES* res;
            conn = mysql_init(0);
            conn = mysql_real_connect(conn ,"localhost" ,"root", "", "library" ,0,NULL,0);
            if(conn)
            {
            int qstate = mysql_query(conn,"SELECT BookNo,Book_Name,Author,Issued_By from book");
            if(!qstate)
            {
                res = mysql_store_result(conn);
                while(row = mysql_fetch_row(res))
                {
                        cout<<" \t \t \t \t \t "<<row[0] <<"(No)"<<" "<<row[1]<<"(Name)"<<"  "<<row[2]<<"(Author)"<<" "<<row[3]<<"(Issued by)"<<endl;
                }

            }
            }
            else cout<<"Failed"<<endl;
		}

    // This method is used to update the issue column of book table in database
	void issue()
	{
		if(loggedin_user=="")
		{
			cout<<"Please Login"<<endl;
			return ;
		}
		string bno;
		cout<<" \t Enter book number to be issued"<<endl;
		cin>>bno;
		bool found = searchbook(bno);
		if(found)
		{
            MYSQL* conn;
            MYSQL_ROW row;
            MYSQL_RES* res;
            conn = mysql_init(0);
            conn = mysql_real_connect(conn ,"localhost" ,"root", "", "library" ,0,NULL,0);
            stringstream ss;
            int qstate=0;
            if(conn)
            {
            int qstate = mysql_query(conn,"SELECT BookNo, Book_Name, Author, Issued_By from book");
            if(!qstate)
            {
                res = mysql_store_result(conn);
                while(row = mysql_fetch_row(res))
                {
                        if(bno==row[0])
                        {
                            ss<<"UPDATE book SET Issued_By=('"<<loggedin_user<<"')";
                            string query =  ss.str();
                              const char* q= query.c_str();
                              qstate = mysql_query(conn,q);
                              if(qstate==0){
                                cout<<" \t \t \t \t \t Book Issued Successfully "<<endl;
                                cout<<" \t \t \t Please Return the book within 15 days otherwise fine of Rs 150 will be applied"<<endl;
                              }
                              else cout<<"Failed"<<endl;
                              issued.insert({loggedin_user, bno});
                              return;
                        }
                }

            }
		}
    }
	else cout<<" \t \t \t \t \t Book Not Found"<<endl;

}
    // This method is used to return an issued book 
	void deposit()
	{
		map<string ,string>::iterator itr;
		for(itr=issued.begin();itr!=issued.end();itr++)
		{
			if(itr->first==loggedin_user)
			{
			issued.erase(loggedin_user);
			cout<<" \t \t \t \t \t Book Returned Successfully";
			return ;
			}
		}
	}
    
    // This method is used to print the current user details
	void print_user()
	{
		 map<string ,string>:: iterator itr;
		 bool flag=false;
				 for(itr=issued.begin();itr!=issued.end();itr++)
				 {
				 	if(itr->first==loggedin_user )
				 	{
					 cout<<" \t \t \t \t \t Current user "<<itr->first<<"   has issued book no:   "<<itr->second;
					 flag=true;
					 }

				}
				if(!flag)
					cout<<" \t \t \t \t \t "<<loggedin_user<<" has issued no book";
				 	cout<<endl;
	}

};


int main()
{
  showtime();
	cout<<" \t \t \t \t \t Library Management System "<<endl<<endl<<endl<<endl;
	user u1;
	int x;
	int choice=0;
	book b1;
	do
	{
		cout<<endl;
		cout<<"Menu:"<<endl;
		cout<<"1. Login"<<endl;
		cout<<"2. Register"<<endl;
		cout<<"3. All Books"<<endl;
		cout<<"4. Search Book"<<endl;
		cout<<"5. Issue Book"<<endl;
		cout<<"6. Return Book"<<endl;
		cout<<"7. Get all users"<<endl;
		cout<<"8. Add Book"<<endl;
		cout<<"9. Current user details"<<endl;
		cout<<"10. Logout"<<endl;
		cout<<"0 to exit"<<endl;
		cin>>x;
	string no2;
	switch(x)
	{
		case 1 : u1.login();
				 break;
		case 2 : u1.adduser();
				 u1.login();
				 break;
		case 3 : b1.allbooks();
				 break;
		case 4 : cout<<"Enter book no";
				 cin>>no2;
				 b1.searchbook(no2);
		case 5 : b1.issue();
				 break;
		case 6 : b1.deposit();
				 break;
		case 7 : u1.no_users();
				 break;
				 break;
		case 8 :  b1.addbook();
				 break;
		case 9 : b1.print_user();
				 break;
		case 10:  u1.logout();
				 break;
		case 0 : choice=1;

	}
	}
	while(choice==0);

}

Output for Library Management System Project in C++

Image Output:

image output for Library Management System Project in C++

Video Output:

Thank you for visiting our website.

Also Read:

Share:

Author: Ayush Purawr