C++ & GUI: Manage SQLite Database

In this video we will create a small app to manage a basic SQLite database,

and we will play with it to do the following items:

- CREATE A TABLE
 CREATE TABLE user (Name TEXT, Age INT, Country TEXT);

- INSERT DATA
 INSERT INTO user (Name, Age, Country) VALUES ('Itokiana', 5, 'Madagascar');
 INSERT INTO user (Name, Age, Country) VALUES ('John', 26, 'USA') ;
 INSERT INTO user (Name, Age, Country) VALUES ('Louis', 34, 'France') ;
 INSERT INTO user (Name, Age, Country) VALUES ('Lee', 22, 'Japan') ;
 INSERT INTO user (Name, Age, Country) VALUES ('Chris', 19, 'Canada') ;
 INSERT INTO user (Name, Age, Country) VALUES ('Unknown', 10, 'Anywhere') ;

- UPDATE DATA
 UPDATE user SET Name="Njaka" WHERE Name="Itokiana";

- DELETE DATA
 DELETE FROM user WHERE Name='Unknown';

- SELECT DATA
 SELECT * FROM user ORDER BY Name ASC;



Source code: https://drive.google.com/file/d/0B1Jtvy4Ey-uwZXRqeVFVa0xLeHM/edit?usp=sharing
Exe file: https://drive.google.com/file/d/0B1Jtvy4Ey-uwajZUUHpKczZ5bDg/edit?usp=sharing

SQLite tutos: http://www.tutorialspoint.com/sqlite/

Read More