#ifndef __sqlitetest__Top__
#define __sqlitetest__Top__
 
#include <iostream>
 
#include "cocos2d.h"
#include "sqlite3.h"
 
class Top : public cocos2d::Layer
{
 
public:
    static cocos2d::Scene* createScene();
    virtual bool init();
    void menuCloseCallback(cocos2d::Ref* pSender);
    CREATE_FUNC(Top);
 
    //sqlite3
    sqlite3* useDataBase = NULL;
    char* errorMessage = NULL;
 
};
 
#endif /* defined(__sqlitetest__Top__) */

#include "Top.h"
 
USING_NS_CC;
 
Scene* Top::createScene()
{
    auto scene = Scene::create();
    auto layer = Top::create();
    scene->addChild(layer);
    return scene;
}
 
// on "init" you need to initialize your instance
bool Top::init()
{
    if ( !Layer::init() ) return false;
 
    //DBファイルの保存先のパス
    auto filePath = FileUtils::getInstance()->getWritablePath();
    filePath.append("Test.db");
 
    //OPEN
    auto status = sqlite3_open(filePath.c_str(), &useDataBase);
 
    //ステータスが0以外の場合はエラーを表示
    if (status != SQLITE_OK){
        CCLOG("opne failed : %s", errorMessage);
    }else{
        CCLOG("open sucessed");
    }
 
    //テーブル作成
    auto create_sql = "CREATE TABLE user( id integer primary key autoincrement, name nvarchar(32), age int(2) )";
    status = sqlite3_exec(useDataBase, create_sql, NULL, NULL, &errorMessage );
    if( status != SQLITE_OK ) CCLOG("create table failed : %s", errorMessage);
 
    //インサート
    auto insert_sql = "INSERT INTO user(name, age) VALUES('raharu', 29)";
    status = sqlite3_exec(useDataBase, insert_sql , NULL, NULL, &errorMessage);
 
    //Close
    sqlite3_close(useDataBase);
 
    return true;
}

Undefined symbols for architecture i386:
  "_sqlite3_exec", referenced from:
      Top::init() in Top.o
  "_sqlite3_open", referenced from:
      Top::init() in Top.o
ld: symbol(s) not found for architecture i386
clang: error: linker command failed with exit code 1 (use -v to see invocation)

    //DBファイルの保存先のパス
    auto filePath = FileUtils::getInstance()->getWritablePath();
    filePath.append("Test.db");
 
    CCLOG("%s", filePath.c_str());