packagekvm.blogg.se - Cafeteria management system project in java

In this function, I searched item with one specific id passed as parameter.

If query failed, then it will show the error message.

In this function, I fetched all sold items from the sold table.

If query failed, then it will show the error message.

In this function, I fetched all items from the items table.

After adding new item to sold table, an update query will run to update the quantity of item in items table in Canteen Management System C++ program.

In this function I used stringstream to convert string to integer and integer to string.

In this function I passed two parameter name and quantity of the item stored in canteen.

If insertion query work successfully, then success message will be shown if not then error message will be shown in this Canteen Management System program.

Then run the built in function mysql_query().I took name and quantity input from user.If connection failure, then error message will be shown.In here, I connected with MySql database.In Canteen constructor I created the instance of database.the if statement shows the successful or failed connection.

(MySql server should open while connecting) mysql_real_connect connects to the database.mysql_init is the initializer of mysql_real_connect.This class contains connection of the database.res is for getting all the values form the database.row is for getting the current row of the database.qstate represent the state of the query.Our main class is Canteen class and this class has some public functions like show, allItems, soldItems, addNewItem, editItem, deleteItem, searchById, searchByName, checkQuantity, addNewSale.īelow are the things we can do in this program:Ĭanteen Management System Program Detail: Global variables The program has a database connection class call at the beginning of the program. Canteen Management System Program in C++ and MySQL Description: You can see the full list of items stored in Canteen. The program can store new canteen item, edit them, delete them. C++ Program: Canteen Management System in C++ and MySQL Introduction: