1: //------------------------------------------------------------------------------
2: // Copyright (c) 2012 eryar All Rights Reserved.
3: //
4: // File : Main.cpp
5: // Author : eryar@163.com
6: // Date : 2012-10-27 23:01
7: // Version : 0.1v
8: //
9: // Description : Test SQLite program.
10: //
11: //==============================================================================
12:
13: #include <stdio.h>
14: #include "sqlite3.h"
15:
16: // Query callback function.
17: int QueryCallback(void* data, int colCount, char** colValues, char** colName);
18:
19: int main(int argc, char* argv[])
20: {
21: int iResultCode = 0;
22: char* szErrorMsg = NULL;
23: const char* szCreateTableSQL = "create table users(name varchar(20) primary key, age int, birthday datetime);";
24:
25: // Connect to the database.
26: sqlite3* pDB = NULL;
27:
28: iResultCode = sqlite3_open("test.db", &pDB);
29:
30: if (iResultCode != SQLITE_OK)
31: {
32: fprintf(stderr, "Cann't open database: %s\n", sqlite3_errmsg(pDB));
33: return 1;
34: }
35:
36: printf("Connected to the database successfully!\n");
37:
38:
39: // Execute the create table command.
40: iResultCode = sqlite3_exec(pDB, szCreateTableSQL, 0, 0, &szErrorMsg);
41: if (iResultCode != SQLITE_OK)
42: {
43: fprintf(stderr, "SQL error: %s! \n", szErrorMsg);
44:
45: sqlite3_free(szErrorMsg);
46: }
47:
48: // Insert records to the database.
49: iResultCode = sqlite3_exec(pDB, "insert into users values('張三', 20, '2012-10-27');", 0, 0, &szErrorMsg);
50: if (iResultCode)
51: {
52: printf("Insert a record to the database.\n");
53: }
54:
55: // Query the database.
56: iResultCode = sqlite3_exec(pDB, "select * from users;", QueryCallback, 0, &szErrorMsg);
57:
58: sqlite3_close(pDB);
59:
60: return 0;
61: }
62:
63: // For every record will call the callback function.
64: // N records will call the callback function N times.
65: int QueryCallback( void* data, int colCount, char** colValues, char** colName )
66: {
67: for (int i = 0; i < colCount; i++)
68: {
69: printf("%s = %s\n", colName[i], colValues[i] == 0 ? "NULL":colValues[i]);
70: }
71:
72: return 0;
73: }
74:
輸出結果:
1: Connected to the database successfully!
2: name = 張三
3: age = 20
4: birthday = 2012-10-27
5: Press any key to continue