Getting Started with Cocos2d-x (13) saving data using SQLite

First download SQLite source code, a total of 4 files, added to the project

Include header file:

#include "Sqlite3.h"

To create or open a database:

Open a database file and, if not, create a database file   
int result=sqlite3_open ("game.db", &pdb);  
If (Result!= sqlite_ok)   
{  
    cclog ("Open database failed, error code:%d, error reason:%s\n", cause, errmsg);   
}  
      
Creates a table, sets the ID as the primary key, and automatically increases   
sqlite3_exec (PDB, CREATE TABLE htable (HID integer PRIMARY key autoincrement, name text), NUL L, NULL, &errmsg);

In the resources directory, you can see a game.db database file appears.

Inserting data

Insert Data   
sqlstr= "insert into htable (name) VALUES (' Henn ')";   
Sqlite3_exec (PDB, sqlstr, NULL, NULL, &ERRMSG);

Open game.db look to see: