C++ call sqlite3 interface

女爷i 2021-11-10 00:34 194阅读 0赞

Note: Remember to include sqlite source code in your project.   
 1 \#include "sqlite3.h"  
 2 \#include <iostream>  
 3 usingnamespace std;  
 4   
 5 sqlite3\* db;  
 6 char\* err;  
 7   
 8   
 9 int CallResult(void\*data, int n\_columns, char\*\*column\_values, char\*\*column\_names)  
10 \{  
11 for(int i=0; i<n\_columns; i\++)  
12  \{  
13  cout <<\*(column\_names\+i) <<" : ";  
14  cout <<\*(column\_values\+i) << endl;  
15  \}  
16   
17 return0;  
18 \}  
19   
20 int main()  
21 \{  
22 int res = sqlite3\_open("E:\\\\sql.db", &db);  
23   
24 string strQuery ="create table person(name text, age int);";  
25   
26  res = sqlite3\_exec(db, strQuery.c\_str(), 0, 0, &err);  
27   
28  res = sqlite3\_exec(db, "insert into person values('ray', '24');", 0, 0, &err);  
29   
30  res = sqlite3\_exec(db, "insert into person values('summmer', '24');", 0, 0, &err);  
31   
32  res = sqlite3\_exec(db, "select \* from person", CallResult, NULL, &err);  
33   
34  cin.get();  
35   
36 return0;  
37 \}

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][] Code   
 1 \#include "sqlite3.h"  
 2 \#include <iostream>  
 3 usingnamespace std;  
 4   
 5 sqlite3\* db;  
 6 char\* err;  
 7   
 8   
 9 int CallResult(void\*data, int n\_columns, char\*\*column\_values, char\*\*column\_names)  
10 \{  
11 for(int i=0; i<n\_columns; i\++)  
12  \{  
13  cout <<\*(column\_names\+i) <<" : ";  
14  cout <<\*(column\_values\+i) << endl;  
15  \}  
16   
17 return0;  
18 \}  
19   
20 int main()  
21 \{  
22 int res = sqlite3\_open("E:\\\\sql.db", &db);  
23   
24 string strQuery ="create table person(name text, age int);";  
25   
26  res = sqlite3\_exec(db, strQuery.c\_str(), 0, 0, &err);  
27   
28  res = sqlite3\_exec(db, "insert into person values('ray', '24');", 0, 0, &err);  
29   
30  res = sqlite3\_exec(db, "insert into person values('summmer', '24');", 0, 0, &err);  
31   
32  res = sqlite3\_exec(db, "select \* from person", CallResult, NULL, &err);  
33   
34  cin.get();  
35   
36 return0;  
37 \}

![ContractedBlock.gif][]

转载于:https://www.cnblogs.com/zhtf2014/archive/2009/08/12/1544774.html

[ContractedBlock.gif]: /images/20211109/8ed254ffc14243aa8cb4fcbfd9236c3e.png
[ExpandedBlockStart.gif]: /images/20211109/e3bee5018ec948bf8e5e1788b923d4f7.png