cocos2dx+连接mysql_[转载]cocos2dx  sqlite 数据库 (自我超级优化版)——创建 +...

#include "DB.h"

DB::DB()

{

//=================DB========================[

pDB =NULL;//数据库指针

sqlstr="";//SQL指令

errMsg = NULL;//错误信息

results=-1;//sqlite3_exec返回值

}

DB::~DB()

{

}

DB* DB::sharedDB()

{

static DB sharedDb;

return

&sharedDb;

}

//====================================================================

//============================ 数据库

====================================

//====================================================================

//打开一个数据库,如果该数据库不存在,则创建一个数据库文件

bool

DB::OpenDBWithFileName(char *dbName)

{

bool success=false;

int result = sqlite3_open(dbName,

&pDB);

if( result != SQLITE_OK )

{

CCLog( "open db failed ,error :%d ,cause: %s " , result, errMsg );

success=false;

}

else

{

CCLog( "open db success

");

success=true;

}

return

success;

}

//创建表,设置ID为主键,且自动增加

bool

DB::CreateTableWithContent(char *dbExec)

{

bool success=false;

int result=sqlite3_exec( pDB, dbExec , NULL,

NULL, &errMsg );

if( result != SQLITE_OK )

{

CCLog( "create table failed ,error :%d ,cause: %s " , result,

errMsg );

success=false;

}

else

{

CCLog( "create table success

");

success=true;

}

return success;

}

//判断表是否存在

bool

DB::IsTableExistedWithTableName(std::string

dbExec)

{

bool success=false;

std::string dbExecs="";

dbExecs.append("select count(type) from sqlite_master where

type='table' and name='");

dbExecs.append(dbExec);

dbExecs.append("'");

int result=sqlite3_exec( pDB, dbExecs.c_str() , NULL, NULL,

&errMsg );

if( result != SQLITE_OK )

{

CCLog( "table not exist ");

success=false;

}

else

{

CCLog( "table  is

existed ");

success=true;

}

return success;

}

int isExisted( void * para, int n_column, char **

column_value, char ** column_name )

{

bool *isExisted_=(bool*)para;

*isExisted_=(**column_value)!='0';

return 0;

}

// 获取数据

bool DB::GetTableDataWithContent(std::string dbExec)

{

bool success=false;

int result = sqlite3_exec( pDB, dbExec.c_str() ,

NULL, NULL, &errMsg ); //  loadRecord

if(result != SQLITE_OK )

{

CCLog( "get GetTableDataWithContent failed,error :%d ,cause:%s " ,

result, errMsg );

success=false;

}

else

{

CCLog( "get GetTableDataWithContent success ");

success=true;

}

return success;

}

//插入数据

bool DB::InsertTableDataWithContent(std::string dbExec)

{

bool success=false;

int result = sqlite3_exec( pDB, dbExec.c_str() ,

NULL, NULL, &errMsg );

if(result != SQLITE_OK )

{

CCLog( "insert failed,error :%d ,cause:%s " , result, errMsg );

success=false;

}

else

{

CCLog( "insert success  ");

success=true;

}

return success;

}

//删除数据

bool DB::DeleteTableDataWithContent(std::string dbExec)

{

bool success=false;

int result = sqlite3_exec( pDB, dbExec.c_str() ,

NULL, NULL, &errMsg );

if(result != SQLITE_OK )

{

CCLog( "delete failed,error :%d ,cause:%s " , result, errMsg );

success=false;

}

else

{

CCLog( "delete success  ");

success=true;

}

return success;

}

//更新数据

bool DB::UpdateTableDataWithContent(std::string dbExec)

{

bool success=false;

int result = sqlite3_exec( pDB, dbExec.c_str() ,

NULL, NULL, &errMsg );

if(result != SQLITE_OK )

{

CCLog( "update failed,error :%d ,cause:%s " , result, errMsg );

success=false;

}

else

{

CCLog( "update success ");

success=true;

}

return success;

}

// 清空数据

bool DB::ClearTableData(std::string dbExec)

{

bool success=false;

std::string dbExecs="";

dbExecs.append("delete from  ");

dbExecs.append(dbExec);

dbExecs.append(" ");

int result = sqlite3_exec( pDB, dbExecs.c_str()

, NULL, NULL, &errMsg );

if(result != SQLITE_OK )

{

CCLog( "clear failed,error:%d ,cause :%s " , result, errMsg );

success=false;

}

else

{

CCLog( " clear db success  ");

success=true;

}

return success;

}

//关闭数据库

void DB::CloseDB()

{

sqlite3_close(pDB);

}

//=================================================

int DB::GetPlayerInfoScores(std::string dbExec)

{

bool success=false;

int scores=0;

sqlite3_stmt *statement=NULL;

int result =  sqlite3_prepare(pDB, dbExec.c_str()

, dbExec.length(), &statement, 0);

if(result != SQLITE_OK )

{

CCLog( "get GetPlayerInfo failed,error :%d ,cause:%s " , result,

errMsg );

success=false;

}

else

{

CCLog( "get GetPlayerInfo success

");

success=true;

while(sqlite3_step(statement) == SQLITE_ROW)

{

scores=sqlite3_column_int(statement, 2);

};

}

return scores;

}

bool DB::GetPassInfoIsUnlockedWithIndex(std::string dbExec)

{

bool success=false;

bool isUnlocked=false;

sqlite3_stmt *statement=NULL;

int result =  sqlite3_prepare(pDB, dbExec.c_str()

, dbExec.length(), &statement, 0);

if(result != SQLITE_OK )

{

CCLog( "get GetPlayerInfo failed,error :%d ,cause:%s " , result,

errMsg );

success=false;

}

else

{

CCLog( "get GetPlayerInfo success

");

success=true;

while(sqlite3_step(statement) == SQLITE_ROW)

{

(sqlite3_column_int(statement,

3)==1)?(isUnlocked=true):(isUnlocked=false);

};

}

return isUnlocked;

}

int DB::GetPassInfoStartsWithIndex(std::string dbExec)

{

bool success=false;

int starts=0;

sqlite3_stmt *statement=NULL;

int result =  sqlite3_prepare(pDB, dbExec.c_str()

, dbExec.length(), &statement, 0);

if(result != SQLITE_OK )

{

CCLog( "get GetPlayerInfo failed,error :%d ,cause:%s " , result,

errMsg );

success=false;

}

else

{

CCLog( "get GetPlayerInfo success

");

success=true;

while(sqlite3_step(statement) == SQLITE_ROW)

{

starts=sqlite3_column_int(statement, 3);

};

}

return starts;

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值