sqlite3* pdb = NULL;
char* msg;
char* sql;
bool b ;
sql = "select * from SCORE_TBL";
sqlite3_stmt* stmt = NULL;
int sqlLen = strlen(sql);
string path =
CCFileUtils::sharedFileUtils()->getWritablePath()
+"save.db";
int resultINT = sqlite3_open(path.c_str(),&pdb);
//打开名为save.db的数据库文件
if(resultINT!=SQLITE_OK)
{
CCLog("open sqlite file %s ERROR in SAVE",
"save.db");
sqlite3_close(pdb);
return;
}
//loadRecord
sqlite3_exec( pdb, sql, HelloWorld::callback123,
NULL, &msg );
//回调处理函数(静态)
int HelloWorld::callback123( void* para,
int n_column,
char** column_value, char** column_name )
{
CCLog("ID=%s,value=%s",column_value[0],
column_value[1]);
return 0;
}
//建表
//3.使用sqlite数据库
sqlite3* pdb = NULL;//数据库文件指针
char* msg;//错误信息
char* sql= NULL;//sql 语句
int result= NULL;//返回值
string path =
CCFileUtils::sharedFileUtils()->getWritablePath()
+"save.db";
result = sqlite3_open(path.c_str(),&pdb);
//打开名为save.db的数据库文件
if(result!=SQLITE_OK)
{
CCLog("open sqlite file %s error","save.db");
sqlite3_close(pdb);
return;
}
//建表
sql = "create table SCORE_TBL(_ID integer primary key autoincrement,score integer)";
result = sqlite3_exec(pdb,sql,NULL,NULL,&msg);
if(result!=SQLITE_OK)
{
CCLog("create table ERROR");
CCLog(msg);
sqlite3_close(pdb);
}
sqlite3_close(pdb);
//插入
//插入数据
char* msg1=NULL;
char sql2[100]= {""};
result = sqlite3_open(path.c_str(),&pdb);
//打开名为save.db的数据库文件
if(result!=SQLITE_OK)
{
CCLog("open sqlite file %s ERROR in INSERT",
"save.db");
sqlite3_close(pdb);
return;
}
sprintf(sql2,
"insert into SCORE_TBL(score)values(%d)",score);
result = sqlite3_exec(pdb,sql2,NULL,NULL,&msg1);
sqlite3_close(pdb);
if(result!=SQLITE_OK)
{
CCLog("insert into table SCORE_TBL ERROR");
CCLog(msg1);
sqlite3_close(pdb);
return;
}
CCLog("---Insert into db SUCCESS---");
CCLog(sql2);
sqlite3_close(pdb);