int main(int argc, char *argv[]) { int err = 0; char path[] = "database.sqlite3"; sqlite3 * db; err = sqlite3_open(path, &db); if(SQLITE_OK != err) { return -1; } SelectDB(db, "select str from xx"); InsertDB(db, "insert or replace into xx values ('007','kkk','5pp')"); UpdateDB(db, "update xx set str='007' where sss='lll'"); DeleteDB(db, "delete from xx where str='789'"); printf("----------!!----------\n"); OperateDB(db, "create table if not exists nimei(woqu TEXT)"); SelectDB(db, "select * from xx"); return 0; }
void AddToDB(CppSQLite3DB* m_db,CLOUD_MEIDA_METADATA_STRUCT* incmd) { //Create db item DbItem item; memset(&item, 0, sizeof(item)); //Title wcscpy(item.szTitle, incmd->Title); //Resource Uri wcscpy(item.szResourceUri, incmd->Location); //Media Type item.nMediaType = incmd->MediaType; //Size wcscpy(item.szSize, incmd->Size); //item.szSize = incmd->Size; //CreateDate item.nCreateDate = incmd->Date; ////AddedDate //FileTimeToInt(fd.ftCreationTime, item.nAddedDate); //Save to DB InsertDB(m_db,item); }
int CWorldDbmgr::FromRpcCall(CPluto& u, CDbOper& db) { //printf("CWorldDbmgr::from_rpc_call\n"); //print_hex_pluto(u); pluto_msgid_t msg_id = -1; T_VECTOR_OBJECT* p = NULL; //这一段要加锁(2012/02/15改为不加锁) { //CMutexGuard _g(m_rpcMutex); msg_id = u.GetMsgId(); if(!CheckClientRpc(u)) { LogWarning("from_rpc_call", "invalid rpcall error.unknown msgid:%d\n", msg_id); return -1; } p = m_rpc.Decode(u); if(p == NULL) { LogWarning("from_rpc_call", "rpc Decode error.unknown msgid:%d\n", msg_id); return -1; } if(u.GetDecodeErrIdx() > 0) { ClearTListObject(p); //PrintHexPluto(u); LogWarning("from_rpc_call", "rpc Decode error.msgid:%d;pluto err idx=%d\n", msg_id, u.GetDecodeErrIdx()); return -2; } } //这一段不用加锁 int nRet = -1; switch(msg_id) { case MSGID_DBMGR_INSERT_ENTITY: { nRet = InsertDB(p, db); break; } case MSGID_DBMGR_SELECT_ENTITY: { nRet = LookupEntityByDbId(p, db); break; } case MSGID_DBMGR_UPDATE_ENTITY: { nRet = UpdateEntity(p, db); break; } case MSGID_DBMGR_UPDATE_ENTITY_REDIS: { nRet = UpdateEntityToRedis(p, db); break; } case MSGID_DBMGR_SELECT_ACCOUNT: { nRet = SelectAccount(p, db); break; } case MSGID_DBMGR_RAW_MODIFY_NORESP: { nRet = QueryModifyNoResp(p, db); break; } case MSGID_DBMGR_CREATEBASE_FROM_NAME: { nRet = LookupEntityByName(p, db); break; } case MSGID_DBMGR_LOAD_ALL_AVATAR: { nRet = LoadAllAvatars(p, db); break; } case MSGID_DBMGR_LOAD_ENTITIES_OF_TYPE: { nRet = LoadEntitiesOfType(p, db); break; } case MSGID_DBMGR_SHUTDOWN_SERVER: { nRet = ShutdownServer(p); break; } case MSGID_DBMGR_REDIS_HASH_LOAD: { nRet = RedisHashLoad(p, db); break; } case MSGID_DBMGR_REDIS_HASH_SET: { nRet = RedisHashSet(p, db); break; } case MSGID_DBMGR_REDIS_HASH_DEL: { nRet = RedisHashDel(p, db); break; } case MSGID_DBMGR_DEL_ACCOUNT_CACHE: { nRet = DestroyAccountCache(p); break; } case MSGID_DBMGR_UPDATE_ITEMS: { nRet = UpdateArrayItemsToDb(p, db); break; } case MSGID_DBMGR_LOADING_ITEMS: { nRet = LoadingArrayItemsToInventory(p, db); break; } case MSGID_DBMGR_INCREMENTAL_UPDATE_ITEMS: { nRet = IncremantalUpdateItems(p, db); break; } case MSGID_DBMGR_TABLE_SELECT: { nRet = TableSelect(p, db); break; } case MSGID_DBMGR_UPDATE_BATCH: { nRet = TableUpdateBatch(p, db); break; } case MSGID_DBMGR_TABLE_INSERT: { nRet = TableInsert(p, db); break; } case MSGID_DBMGR_TABLE_EXCUTE: { nRet = TableExcute(p, db); break; } case MSGID_DBMGR_TABLE2_SELECT: { nRet = Table2Select(p, db); break; } case MSGID_DBMGR_TABLE2_INSERT: { nRet = Table2Insert(p, db); break; } case MSGID_DBMGR_TABLE2_EXCUTE: { nRet = Table2Excute(p, db); break; } default: { break; } } if(nRet != 0) { LogWarning("from_rpc_call", "rpc error.msg_id=%d;ret=%d\n", msg_id, nRet); } ClearTListObject(p); return 0; }
void ManagerMessage::on_pushButton_clicked() //修改基本信息 { if(MS) { static bool tf = true; if(tf) { if(super) //超级管理员 { ui->no->setEnabled(true); ui->major->setEnabled(true); } ui->name->setEnabled(true); ui->email->setEnabled(true); ui->pushButton->setText("保存信息"); tf = false; } else { if(ui->no->text().isEmpty() || ui->name->text().isEmpty() || ui->email->text().isEmpty()) { Error("请完善信息!"); return; } if(super) { //判断当前工号是否存在 if(ui->no->text().trimmed() != teacherNo) { QString sql1 = "select TName from MANAGER where TeacherNo='" + ui->no->text() + "'"; QString name = selectDB(sql1); if(name != WRONG) { Error("当前工号已存在!"); return; } } //删除原记录 QString sql = "delete from MANAGER where TeacherNo='" + teacherNo + "'"; QString del = selectDB(sql); if(del != WRONG) { Error(WRONG); return; } QString sql2 = "insert into MANAGER(TeacherNo, TPassword, TName, TEmail, TMajor, TManager, TSuperManager) values(?,?,?,?,?,?,?)"; if(InsertDB(sql2, NULL)) { Error("保存成功!"); } else { Error(WRONG); return; } ui->no->setEnabled(false); ui->major->setEnabled(false); } else { QString sql = tr("update MANAGER set TName='%1', TEmail='%2' where TeacherNo='%3'").arg(ui->name->text().trimmed()).arg(ui->email->text().trimmed()).arg(ui->no->text().trimmed()); QString up = selectDB(sql); if(up != WRONG) { Error(WRONG); return; } Error("保存成功!"); } ui->name->setEnabled(false); ui->email->setEnabled(false); ui->pushButton->setText("修改基本信息"); tf = true; } } else { if(ui->no->text().isEmpty() || ui->name->text().isEmpty() || ui->email->text().isEmpty()) { Error("请完善信息!"); add = false; return; } QString sql2 = "insert into MANAGER(TeacherNo, TPassword, TName, TEmail, TMajor, TManager, TSuperManager) values(?,?,?,?,?,?,?)"; if(InsertDB(sql2, "ADD")) { Error(tr("新增成功!默认密码%1").arg("csl123456")); add = true; } else { Error(WRONG); false; return; } this->close(); } }
int CWorldOther::FromRpcCall(CPluto& u, CDbOper& db) { //printf("CWorldOther::from_rpc_call\n"); //print_hex_pluto(u); pluto_msgid_t msg_id = -1; T_VECTOR_OBJECT* p = NULL; //这一段要加锁(2012/02/15改为不加锁) { //CMutexGuard _g(m_rpcMutex); msg_id = u.GetMsgId(); if(!CheckClientRpc(u)) { LogWarning("from_rpc_call", "invalid rpcall error.unknown msgid:%d\n", msg_id); return -1; } p = m_rpc.Decode(u); if(p == NULL) { LogWarning("from_rpc_call", "rpc Decode error.unknown msgid:%d\n", msg_id); return -1; } if(u.GetDecodeErrIdx() > 0) { ClearTListObject(p); //PrintHexPluto(u); LogWarning("from_rpc_call", "rpc Decode error.msgid:%d;pluto err idx=%d\n", msg_id, u.GetDecodeErrIdx()); return -2; } } //这一段不用加锁 int nRet = -1; switch(msg_id) { case MSGID_LOG_INSERT: { nRet = InsertDB(p, db); break; } case MSGID_OTHER_HTTP_REQ: { nRet = ReqUrl(p); break; } case MSGID_ALLAPP_SHUTDOWN_SERVER: { nRet = ShutdownServer(p); break; } case MSGID_OTHER_ADD_GLOBALBASE: { nRet = RegisterGlobally(p); break; } case MSGID_OTHER_YUNYING_API: { nRet = SupportApi(p, u.GetMailbox(), db); break; } case MSGID_OTHER_CLIENT_RESPONSE: { nRet = Response2Browser(p); PrintHexPluto(u); break; } //case MSGID_OTHER_LOGIN_VERIFY: //{ // //todo:verify // nRet = SdkServerVerify(p, u); // break; //} // case MSGID_OTHER_PLAT_API: // { // nRet = PlatApi(p, u.GetMailbox(), db); // break; // } default: { LogWarning("from_rpc_call", "rpc unkown msg_id = %d\n", msg_id, nRet); break; } } if(nRet != 0) { LogWarning("from_rpc_call", "rpc error.msg_id=%d;ret=%d\n", msg_id, nRet); } ClearTListObject(p); return 0; }