OOP concepts in Java: SQL Functionalities in OOP C++ (Part 4/4)

Order by increasing CGPA:

If we want to sort our data in ascending or descending order according to a particular column then Order by statement we can use in SQL. We can use the keyword DSC to sort in descending and ASC to sort in ascending order.Here in our project we sort in ascending order using keyword ASC with a particular column of CGPA from our created table.

Code:

cout<<”order by inc order of CGPA”;

query=”SELECT *FROM STUDENT ORDER BY CGPA ASC; ”;

/*execute sql statement*/ rc=sqlite3_exec(DB,query.c_str(),callback,NULL,&messageError); if(rc!=SQLITE_OK

{

fprintf(stderr,”SQL error:%s\n”),messageError); sqlite3_free(messageError);

else

{

fprintf(stdout,”operation successful”);

}

Output:

Group names by CGPA:

The group by statement groups the rows that have the same values into summary rows.in our project we group the names according to CGPA at output we get name and CGPA of that particular student.

Code:

cout<<”\n Group by CGPA\n”;

query=”SELECT NAME,SUM(CGPA) FROM STUDENT GROUP BY NAME;”;

rc=sqlite3_exec(DB,query.c_str(),callback,NULL,&messageError); if(rc!=SQLITE_OK

{

fprintf(stderr,”SQL error:%s\n”),messageError); sqlite3_free(messageError);

else

{

fprintf(stdout,”operation successful”);

}

Output:

Applications:

The project finds the application for managing the large database like Employee records,Student records,Library management system etc.

Conclusion:

In our project we have performed various functions of SQL like create a table,delete,insert,sort,search,modify and group by using C++.And came to know how large data can be easily managed by SQL functions.

Amarja Chede

K10

With this we conclude our Blog series!

You can find all documents related to our Course Project in the links given below.

CP Title : SQL functionalitiy in OOP C++

Description:
Implementation of the following SQL functions in OOP C++ on a database of Student Information
1.Insert Record
2.Delete Record
3.Search Record
4.Modify Record
5.Group by
6.Order by

CP Report: https://drive.google.com/file/d/1WlW7a_UtouBB0UZIJA-nlN1nlJYl1vRB/view?usp=sharing

CP PPT:https://drive.google.com/file/d/1WoGqFIV-r0vN_WFaiBBwr-klj0tUfQrq/view?usp=sharing

Topic1

Smruti Khire

TY K

Roll no:38