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

• C++ Program for Converting Decimals to Binary
• C++ program to Convert Decimal to Octal
• Program for Decimal to Hexadecimal Conversion in C++
• Program to Convert Binary To Decimal Conversion in C++
• Program to convert hexadecimal to decimal conversion in C++
• C++ Program to convert hex string to signed integer
• Convert an Integer into a String in C++
• Convert a String into an Integer Data in C++
• Convert a string into the ASCII Format in C++
• C++ program to Convert Character into Integer
• Convert Character into a String in C++
• Convert String to Date in C++
• Convert double to string in C++
• C++ CONVERT CHARACTER TO INTEGER USING ASCII
• FUNCTION TO CONVERT CHARACTER INTO INTEGER IN C++
• C++ program to convert string to float
• C++ program to convert string to Double
• CONVERTING NUMBERS INTO THEIR WORDS EQUIVALENT IN C++
• C++ Program to convert a Decimal int to Hexadecimal
• C++ Program to convert HEX to ASCII String
• HOW TO WRITE A C++ PROGRAM TO CONVERT A DECIMAL INT TO HEXADECIMAL 
• WRITE A C++ PROGRAM TO CONVERT HEX TO ASCII STRING
• How to use Xerces Library to parse the XML file with Visual C++ Project
• 
  

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



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

Browse More Articles

Tweet

Written by Unknown

We are one of the initiators of the development of information technology in understanding the need for a solution that is familiar and close to us.