Tuesday, May 21, 2013

How to Install SqLite in Ubuntu and Run The First C++ Program With Sqlite.


Step1- Install Sqlite With the following command

$ sudo apt-get install sqlite3 libsqlite3-dev 

Now Run the following command to chack that Sqlite is really installed and working.

$ sqlite3 

and You will see the following Response.

SQLite version 3.7.13 2012-06-11 02:05:22 
Enter ".help" for instructions 
Enter SQL statements terminated with a ";" 
sqlite> 




Now make a C++ Program and Name it as SqLite_Test.cpp and write the following C++ Code


//=========================================================
// Name        : SqLite_Test.cpp
// Author      : 
// Version     :
// Copyright   : Your copyright notice
// Description : SqLite_Test.cpp in C++, Ansi-style
//=========================================================

#include <iostream>
#include <sqlite3.h>
using namespace std;


// This is the callback function to display the select data in the table
static int callback(void *NotUsed, int argc, char **argv, char **szColName)
{
  for(int i = 0; i < argc; i++)
  {
    std::cout << szColName[i] << " = " << argv[i] << std::endl;
  }

  std::cout << "\n";

  return 0;
}

int main()
{
  sqlite3 *db;
  char *szErrMsg = 0;

  // open database
  int rc = sqlite3_open("Sqlite_Test.db", &db);

  if(rc)
  {
    std::cout << "Can't open database\n";
  } else {
    std::cout << "Open database successfully\n";
  }

  // prepare our sql statements
  const char *pSQL[6];
  pSQL[0] = "CREATE TABLE Employee(Firstname varchar(30), Lastname varchar(30), Age smallint)";
  pSQL[1] = "INSERT INTO Employee(Firstname, Lastname, Age) VALUES ('Woody', 'Alan', 45)";
  pSQL[2] = "INSERT INTO Employee(Firstname, Lastname, Age) VALUES ('Micheal', 'Bay', 38)";
  pSQL[3] = "SELECT * FROM Employee";

  // execute sql
  for(int i = 3; i < 4; i++)
  {
    rc = sqlite3_exec(db, pSQL[i], callback, 0, &szErrMsg);
    if(rc != SQLITE_OK)
    {
      std::cout << "SQL Error: " << szErrMsg << std::endl;
      sqlite3_free(szErrMsg);
      break;
    }
  }

  // close database
  if(db)
  {
    sqlite3_close(db);
  }

  return 0;
}




Now Compile the C++ Program with following g++ command

g++ -L/usr/include -o "SqLite_Test"  ./src/SqLite_Test.o   -lsqlite3

If the Program is compiled successfully You are good to go.

The Output will Look like below

OUTPUT:

Open database successfully
Firstname = Woody
Lastname = Alan
Age = 45

Firstname = Micheal
Lastname = Bay
Age = 38


If you want to run the C++ Program on Eclipse then Write the same program in eclipse IDE and follow the following steps
step 1 – Rigth click your Project → properties → C/C++ Build ->Settings->Cross G++ Linker->Libraries and add the Library and library search path as shown in the picture.




Now compile and Run the program.

















C++

  1. Write a C++ program to Make Simple calculator
  2. Write a C++ program to arrange 10 numbers in ascending order
  3. Write a C++ program to calculates the following equation for entered numbers (n, x). 1+ (nx/1!) - (n(n-1)x^2/2!)
  4. Write a C++ program to 1. Initialize Matrices 2. Print Matrices 3. Multiply Matrices 4. Transpose of 2nd Matrix 5. Move Row and Column of 2nd Matrix 6. Quit
  5. Write the C++ program for processing of the students structure
  6. Write a C++ program that gets two strings from input and stores them in variables such as str1 and str2
  7. Write a C++ program that gets one text with the maximum of 256 characters from input and converts it to standard format based on the following rules and prints the final standardized text
  8. C++ Mini-Project: Human Resource Management Program
  9. Write a C++ program to Solve Quadratic equation
  10. C++ program for Calculation of the surface and the volume of a cone
  11. C++ Program to show Fibonacci Series
  12. C++ Program for Decimal to Hexadecimal Conversion
  13. C++ program to convert decimal number into binary
  14. C++ PROGRAM TO CHECK WHETHER A NUMBER IS NOT A PERFECT NUMBER OR NOT
  15. C++ program to find prime numbers in a given range
  16. C++ program to find Armstrong number
  17. C++ program to find prime number
  18. C++ program to convert a string into upper-case or lower-case
  19. C++ program to concatenate strings
  20. How to Run and install the mongo c++ drivers (MongoDB) On Ubuntu Linux
  21. How to Install Crypto++ Library with the Eclipse IDE on UBUNTU12.10 OS.
  22. Build and Run Sample Code Using Log4Cpp from Source Code on Ubuntu
  23. C++ counting the number of lines in a text file
  24. How do you implement the factorial function in C++
  25. C++ program to find HCF n LCM of two numbers
  26. The most elegant way to split a string in C++
  27. C++ Program for Printing 1 to 1000 without loop
  28. PASS BY REFERENCE C++ EXAMPLE
  29. C++ PROGRAM TO FIND WHETHER A NUMBER IS EVEN OR ODD
  30. C++ code to print all odd and even numbers in given range
  31. C++ Program to Check Palindrome Number
  32. C++ code to get sum of all odd numbers in given range
  33. C++ program to find ASCII Code for Characters and numbers
  34. Compiling and Integrating Crypto++ into the Microsoft Visual C++ Environment + Running Sample program
  35. Write a c++ program that calculates the average of three numbers
  36. C++ program compute hourly pay taking overtime into account
  37. C++ program to print 5 rows of 10 stars
  38. Write a C++ program that can print a temperature conversion
  39. Write a C++ program to construct a pyramid of stars
  40. C++ PROGRAM FOR RANDOM NUMBER GENERATOR
  41. Program for climbing worm program in c++
  42. C++ Program to display current date and time
  43. A C++ program to print the half pyramid
  44. C++ program to print pyramid of numbers







C++ Conversion











-----------------------------------------------------------------



Searches related to sqlite c++ example
sqlite java example
sqlite python example
mysql c++ example
sqlite c++ example linux
c++ tutorials
help for setting up sqlite on eclipse on ubuntu
C/C++ Interface Spec
sqlite c++ tutorial
How to use SQLite with c++ on Ubuntu?
SQLite3, C++ & Ubuntu
sqlite c++ example code
sqlite3_step example
c++ - How to read data from SQLite database?
Accessing a SQLite Database with C++
Starting with SQLite in C++
Installing sqlite headers on ubuntu
An Introduction To The SQLite C/C++
SQLite In C++ - C++ Tutorials
SQLite C example
SQLite C/C++ Tutorial

2 comments:

  1. Hello,

    Thank you for the interesting post. It helped me, to get a running mini-compilable prototype of an application. Unfortunately I found a little typo in the for-loop in the main method. The integer variable "i" is initialized with 3, where it must be "int i = 0". Therefore it isn't, one will get an error, telling that there is no Table called Employee. Nonetheless I would like to thank you.

    Best regards,
    The Council

    ReplyDelete
  2. Another small change: "g++ -L/usr/include -o "SqLite_Test" ./src/SqLite_Test.o -lsqlite3" should be "g++ -I/usr/include -o "SqLite_Test" ./src/SqLite_Test.o -lsqlite3". That is what I had to do. Still, this is an excellent post. Thank you very much.

    ReplyDelete