Implement C ++ operations for SQLite databases step by step

SQLite is a lightweight database and ACID-compliant relational database. It is currently used in many embedded products and occupies very low resources.

SQLite is a lightweight database and ACID-compliant relational database. It is currently used in many embedded products and occupies very low resources.

SQLite relational database is already used in many embedded products. It occupies very low resources. In embedded devices, only a few hundred operating systems are required, the same Code can be compiled across platforms. This database and Microsoft Access.

Due to work needs, these days for sqlite

1: Download and compile the source code

My version is

It is very easy to compile the source code.

My goal is

LIB

FindVSInstallation path of, my isD: \ Program Files \. Use the command line to enter the following path.

D: \ Program Files \ Microsoft Visual Studio 9.0 \ VC \ bin> lib/def: sqlite3.def/machine: ix86

Problem 1: mspdb80.dllCannot be found

The reason is that there is no"Msobj80.dll, mspdb80.dll, mspdbcore.dll, and mspdbsrv.exe.

Solution:

Corresponding generation

Microsoft (R) Library Manager Version 9.00.21022.08

Copyright (C) Microsoft Corporation. All rights reserved.

Creating Database...

2

Problem 2: sqlite3.dll not found, So this application failed to start

I put

Originally required for Program Execution

3: Demo code

The main source code is from the internet. I modified the source code.

4

I operate on the command lineSQLiteWhen you enter the database, you cannot generate a database, and the Table Generation Command is not successful.

Then I finally understood,

SQLite

Finally, a simple SQLite program is completed.