void CTempretureImpl::InsertDataToMySql(vector<CTempData*> tempvec) { CDatabase *db = CDbConnect::GetInstance()->getDatabase(); if (!db->BeginTrans()) return; for (int i = 0; i < tempvec.size(); i++){ CString sql; sql.Format(_T("insert into tempreture(tempreture,time) values('%s','%s')"), tempvec.at(i)->GetTemperature(), tempvec.at(i)->GetTime()); db->ExecuteSQL(sql); } db->CommitTrans(); }
//定义的删除数据的函数 _declspec(dllexport) int WINAPI deldata(void *res) { AFX_MANAGE_STATE(AfxGetStaticModuleState()); if(res==NULL) return 1; whichtab=1; CString str,conn; crt_conn(conn); CDatabase db; if(db.IsOpen()) db.Close(); try {db.Open(NULL,false,false,conn);} catch(CDBException *ep) { MessageBox(NULL,ep->m_strError,"from dll-008",0); return 1; } str.Format("%s",(char*)res); myrecord mrd(&db); if(mrd.IsOpen()) mrd.Close(); try {mrd.Open(AFX_DB_USE_DEFAULT_TYPE,str);} catch(CDBException *ep) { db.Close(); MessageBox(NULL,ep->m_strError,"from dll-010",0); return 1; } if(mrd.IsEOF() || !mrd.CanUpdate() || !mrd.CanTransact()) { MessageBox(NULL,"delete result error!","from dll-009",0); mrd.Close(); db.Close(); return 1; } /* mrd.MoveFirst(); while(!mrd.IsEOF()) { mrd.Delete(); mrd.MoveNext(); } */ mrd.Delete(); db.CommitTrans(); mrd.Close(); db.Close(); return 0; };
void CTempretureImpl::InsertDataToMySql(CTempData* temp) { CDatabase *db = CDbConnect::GetInstance()->getDatabase(); if (!db->BeginTrans()) return; int n = 3; while (n--) { CString sql; sql.Format(_T("insert into tempreture(tempreture,time) values('%s','%s')"), temp->GetTemperature(), temp->GetTime()); db->ExecuteSQL(sql); } db->CommitTrans(); }