cocos2d-x中使用sqlite

　　      #include "sqlite/sqlite3.h"
　　　　　 m_pDb = NULL;  //sqlite3 *m_pDb;

	String path = "infor\\data.db";  //创建的txt文本，随便改个后缀名
#if CC_TARGET_PLATFORM != CC_PLATFORM_WIN32
	path = CCFileUtils::sharedFileUtils()->getWritablePath()+"infor\\data.db"; 
#endif

	CCString sql;  
	int result;  
	result = sqlite3_open(path.c_str(),&m_pDb);  
	if(result != @R_47_5607@OK)  
	{
		CCLog("open database failed,number%d",result);  
		m_pDb = NULL;
		return;
	}

	// Help map
	sql = "create table Help_map(ID INTEGER PRIMARY KEY,count IntegeR DEFAULT 0)";
	result = sqlite3_exec(m_pDb,sql.getCString(),NULL,null); 
	if(result != @R_47_5607@OK)  
		CCLog("create table failed"); 
	for (int i=0; i<100; ++i)
	{
		sql.initWithFormat("insert into Help_map values(%d,0)",i+1);  
		result = sqlite3_exec(m_pDb,null);  
		if(result != @R_47_5607@OK)  
			CCLog("insert data failed!"); 
	}

	// special tool
	sql = "create table special_tool(ID INTEGER PRIMARY KEY,state IntegeR DEFAULT 0,null);
	if(result != @R_47_5607@OK)  
		CCLog("create table failed");  
	for (int i=0; i<20; ++i)
	{
		sql.initWithFormat("insert into special_tool values(%d,null);  
		if(result != @R_47_5607@OK)  
			CCLog("insert data failed!"); 
	}

	//SELEct
	char **re;  
	int r,c;  
	{
		//第3个参数是查询结果，它依然一维数组（不要以为是二维数组，更不要以为是三维数组）。
		//它内存布局是：第一行是字段名称，后面是紧接着是每个字段的值
		// col个数据之后才是表数据，之前的是列名字
		result = sqlite3_get_table(m_pDb,"SELEct * from Help_map",&re,&r,&c,null);  
		CCLog("Help_map: row is %d,column is %d",r,c); 

		m_HelpMap.clear();
		for (int i=0; i< 100; ++i)
		{
			CCLog("row %d ---> id = %s,count = %s",i+1,re[c + i*c],re[c + i*c +1]);
			int val = CCString(re[c + i*c +1]).intValue();
			m_HelpMap.push_BACk(val);
		}
		sqlite3_free_table(rE); 
	}


	{
		result = sqlite3_get_table(m_pDb,"SELEct * from special_tool",null);  
		CCLog("special_tool row is %d,c);  

		m_specialItemState.clear();
		m_specialItem.clear();
		for (int i=0; i< 20; ++i)
		{
			CCLog("row %d ---> id = %s,state = %s,re[c + i*c +1],re[c + i*c + 2]);
			
			int val = CCString(re[c + i*c +1]).intValue();
			m_specialItemState.push_BACk(val);
			val = CCString(re[c + i*c +2]).intValue();
			m_specialItem.push_BACk(val);
		}
		sqlite3_free_table(rE); 
	}