转自:http://blog.csdn.net/zhy_cheng/article/details/8634967
在cocos2d-x中,简单数据存储,可以使用CCUserDefault,大家可以看看我前一篇博文。至于大量,不规则的数据存储,则使用SQLite数据库。SQLite数据库的使用,请参考我的博文C++操作SQLite数据库,在此博文中,主要讲解怎么样使用C++来操作数据库的。SQLite数据库本来就是使用C语言来编写的,所以cocos2d-x使用SQLite也是得心应手。
其实cocos2d-x操作数据库在windows上的使用我早就解决了,主要是在android平台上的使用了。
先来看看代码怎么写,代码就是王道。
首先是要去SQLite官网下载SQLite的源代码。就是两个文件sqlite3.h和sqlite3.c,我在博文的最后会提供下载的。将这两个文件加入工程。
- sqlite3 *pdb=NULL;
- std::string path=CCFileUtils::sharedFileUtils()->getWriteablePath()+"save.db3";
- std::string sql;
- int result;
- result=sqlite3_open(path.c_str(),&pdb);
- if(result!=SQLITE_OK)
- CCLog("open database failed, number%d",result);
sqlite3 *pdb=NULL;
std::string path=CCFileUtils::sharedFileUtils()->getWriteablePath()+"save.db3";
std::string sql;
int result;
result=sqlite3_open(path.c_str(),&pdb);
if(result!=SQLITE_OK)
CCLog("open database failed, number%d",result);
上面的代码就是创建SQLite数据库文件,注意:一定要提供文件的路径。
- result=sqlite3_exec(pdb,"create table student(ID integer primary key autoincrement,name text,sex text)",NULL,NULL,NULL);
- if(result!=SQLITE_OK)
- CCLog("create table failed");
result=sqlite3_exec(pdb,"create table student(ID integer primary key autoincrement,name text,sex text)",NULL,NULL,NULL);
if(result!=SQLITE_OK)
CCLog("create table failed");
这是创建表的SQL语句。
- sql="insert into student values(1,'zhycheng','male')";
- result=sqlite3_exec(pdb,sql.c_str(),NULL,NULL,NULL);
- if(result!=SQLITE_OK)
- CCLog("insert data failed!");
- sql="insert into student values(2,'liuyali','female')";
- result=sqlite3_exec(pdb,sql.c_str(),NULL,NULL,NULL);
- if(result!=SQLITE_OK)
- CCLog("insert data failed!");
- sql="insert into student values(3,'zhy_cheng','male')";
- result=sqlite3_exec(pdb,sql.c_str(),NULL,NULL,NULL);
- if(result!=SQLITE_OK)
- CCLog("insert data failed!");
sql="insert into student values(1,'zhycheng','male')";
result=sqlite3_exec(pdb,sql.c_str(),NULL,NULL,NULL);
if(result!=SQLITE_OK)
CCLog("insert data failed!");
sql="insert into student values(2,'liuyali','female')";
result=sqlite3_exec(pdb,sql.c_str(),NULL,NULL,NULL);
if(result!=SQLITE_OK)
CCLog("insert data failed!");
sql="insert into student values(3,'zhy_cheng','male')";
result=sqlite3_exec(pdb,sql.c_str(),NULL,NULL,NULL);
if(result!=SQLITE_OK)
CCLog("insert data failed!");
插入数据。
- sql="delete from student where ID=1";
- result=sqlite3_exec(pdb,sql.c_str(), ,NULL,NULL);
- if(result!=SQLITE_OK)
- CCLog("delete data failed!");
sql="delete from student where ID=1";
result=sqlite3_exec(pdb,sql.c_str(), ,NULL,NULL);
if(result!=SQLITE_OK)
CCLog("delete data failed!");
删除数据。
- char **re;
- int r,c;
- sqlite3_get_table(pdb,"select * from student",&re,&r,&c,NULL);
- CCLog("row is %d,column is %d",r,c);
- CCLabelTTF *liu=CCLabelTTF::create(re[2*c+1],"Arial",24);
- liu->setPosition(ccp(200,200));
- addChild(liu,1);
- CCLog(re[2*c+1]);
- sqlite3_free_table(re);
- sqlite3_close(pdb);
char **re;
int r,c;
sqlite3_get_table(pdb,"select * from student",&re,&r,&c,NULL);
CCLog("row is %d,column is %d",r,c);
CCLabelTTF *liu=CCLabelTTF::create(re[2*c+1],"Arial",24);
liu->setPosition(ccp(200,200));
addChild(liu,1);
CCLog(re[2*c+1]);
sqlite3_free_table(re);
sqlite3_close(pdb);
查询数据。
这里数据查出后,使用一个文本在屏幕上显示,这是为了在Android手机上看到效果。
最后要注意,在发布到Android手机上的时候一定要修改MK文件,该文件是proj.android/jin/Android.mk。添加对sqlite3.c的编译,改成如下:
- LOCAL_PATH := $(call my-dir)
- include $(CLEAR_VARS)
- LOCAL_MODULE := game_shared
- LOCAL_MODULE_FILENAME := libgame
- LOCAL_SRC_FILES := hellocpp/main.cpp \
- ../../Classes/AppDelegate.cpp \
- ../../Classes/HelloWorldScene.cpp\
- ../../Classes/sqlite3.c
- LOCAL_C_INCLUDES := $(LOCAL_PATH)/../../Classes
- LOCAL_WHOLE_STATIC_LIBRARIES := cocos2dx_static cocosdenshion_static cocos_extension_static
- include $(BUILD_SHARED_LIBRARY)
- $(call import-module,CocosDenshion/android) \
- $(call import-module,cocos2dx) \
- $(call import-module,extensions)
LOCAL_PATH := $(call my-dir)
include $(CLEAR_VARS)
LOCAL_MODULE := game_shared
LOCAL_MODULE_FILENAME := libgame
LOCAL_SRC_FILES := hellocpp/main.cpp \
../../Classes/AppDelegate.cpp \
../../Classes/HelloWorldScene.cpp\
../../Classes/sqlite3.c
LOCAL_C_INCLUDES := $(LOCAL_PATH)/../../Classes
LOCAL_WHOLE_STATIC_LIBRARIES := cocos2dx_static cocosdenshion_static cocos_extension_static
include $(BUILD_SHARED_LIBRARY)
$(call import-module,CocosDenshion/android) \
$(call import-module,cocos2dx) \
$(call import-module,extensions)
好了,在我的手机上的运行效果如下:
数据库文件保存的位置是/data/data/com.zhycheng.SQLiteTest/save.db3。
最后提供Android的源代码下载:点击打开链接。