SQL Functionality in OOP C++ (Part 2/4)

1) Create Database-

Using this function of SQL, we can connect to an existing database. SQL library is used.It will create and return a database object if the database does not exist. The following C code snippet is used.

Code-

sqlite3* DB;

int exit = 0;

exit = sqlite3_open("student.db", &DB);

if (exit) {

            std::cerr << "Error open DB " << sqlite3_errmsg(DB) << std::endl;

            return (-1);

            }

else

            std::cout << "Opened Database Successfully!" << std::endl;          

Output-

2)Create Table-

  

Using this function of SQL, we can create a table in the previously created database. SQL library is used. A table to enter student information is created. The following code snippet is will explain this functionality.

Code-

std::string sql = "CREATE TABLE STUDENT("

                                                            "ID INT PRIMARY KEY       NOT NULL, "

                                                            "NAME                       TEXT NOT NULL, "

                                                            "SURNAME               TEXT NOT NULL, "

                                                            "AGE              INT     NOT NULL, "

                                                            "BRANCH      CHAR(50), "

                                                            "CGPA                        REAL );";

            char* messaggeError;

            exit = sqlite3_exec(DB, sql.c_str(), NULL, 0, &messaggeError);

            if (exit != SQLITE_OK) {

                        std::cerr << "Error Create Table" << std::endl;

                        sqlite3_free(messaggeError);

            }

            else

                        std::cout << "Table created Successfully" << std::endl;

Output-

3) Insert Record-

Using this function of SQL, we can create records in the student table. This is done similarly in code blocks using SQLite library. Following code snippet is used to explain this functionality.

Code-

cout << "STATE OF TABLE BEFORE INSERT" << endl;

sqlite3_exec(DB, query.c_str(), callback, NULL, NULL);

string sql(

"INSERT INTO STUDENT VALUES(1, 'STEVE', 'GATES', 19, 'EnTC',10);"

"INSERT INTO STUDENT VALUES(2, 'BILL', 'ALLEN', 20, 'CS',7);"

"INSERT INTO STUDENT VALUES(3, 'PAUL', 'JOBS', 24, 'CS',8);"

"INSERT INTO STUDENT VALUES(4, 'RISHITA', 'JAISWAL', 20,'CS',9);"

"INSERT INTO STUDENT VALUES(5, 'AMARJA', 'CHEDE', 21, 'CHEM',8);"

"INSERT INTO STUDENT VALUES(6, 'SMRUTI', 'KHIRE', 22, 'CHEM',9.5);"

"INSERT INTO STUDENT VALUES(7, 'DIKSHA', 'AVHAD', 20, 'ENTC',9);"

"INSERT INTO STUDENT VALUES(8, 'SHAMLI', 'BAJAD', 19, 'ENTC',8);"

"INSERT INTO STUDENT VALUES(9, 'SAYLI', 'AHER', 20, 'IT',7);"

"INSERT INTO STUDENT VALUES(10, 'JYOTI', 'JAGTAP', 21, 'ENTC',6);"

"INSERT INTO STUDENT VALUES(11, 'NUTAN', 'AHIRE', 18, 'CS',7);"

"INSERT INTO STUDENT VALUES(12, 'PRATIBHA', 'MHASALE', 21, 'CIVIL',9);"

"INSERT INTO STUDENT VALUES(13, 'VRUSHALI', 'PATIL', 19, 'IT',8);"

"INSERT INTO STUDENT VALUES(14, 'AJAY', 'RAJPUT', 20, 'ENTC',9);"

"INSERT INTO STUDENT VALUES(15, 'PRATHAMESH', 'KHAIRNAR', 20, 'ENTC',9);"

"INSERT INTO STUDENT VALUES(16, 'SAGAR', 'PANDEY', 21, 'MECH',7);"

"INSERT INTO STUDENT VALUES(17, 'MAHESH', 'UGALE', 21, 'ELEX',8);"

"INSERT INTO STUDENT VALUES(18, 'SHUBHAM', 'AHIRE', 19, 'CIVIL',7);"

"INSERT INTO STUDENT VALUES(19, 'ASHOK', 'AMBTE', 29, 'IT',8);"

"INSERT INTO STUDENT VALUES(20, 'ANUJ', 'KHAIRNAR', 19, 'CS',8);"

);

exit = sqlite3_exec(DB, sql.c_str(), callback, 0, &messaggeError);

if (exit != SQLITE_OK) {

std::cerr << "Error Insert" << std::endl;

sqlite3_free(messaggeError);

}

else

{

std::cout << "Records created Successfully!" << std::endl;

}

Output-

Rishita Jaiswal
K 28