Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the implementation method of embedded MYSQL server". In the daily operation, I believe that many people have doubts about the implementation method of embedded MYSQL server. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubts about "implementation method of embedded MYSQL server". Next, please follow the editor to study!

/ / embedded MYSQL server

Class CEmbeddedMySQL {public: CEmbeddedMySQL (); virtual ~ CEmbeddedMySQL (); static bool StartupEmbeddedServer (); static void ShutdownEmbeddedServer (); bool Open (const string & svr, const string & usr, const string & pwd, const string & db); void Close (); bool ResetDB (); void Set (const string & sField, const string & sValue); void Set (const string & sField, double dValue); void Set (const string & sField, long nValue); void Set (const string & sField, int nValue) Void Set (const string & sField, BYTE * pBuf, int nLen); void SetNull (const string & sField); void registerOutParameter (const string & sField, char cType); / / void SetRecord (const string & sField, const string & sTableName, const string & sTypeName, CStdRecord & Record); void Cmd (const char * cmd,...); bool More (); long Exec (); / / bool SelectInto (CStdRecord * pRecord,bool bCreateHead=true); double GetDouble (int id) Double GetDouble (const string & name); long GetLong (int id); long GetLong (const string & name); string Get (int id); string Get (const string & name); string GetLastErrMsg (); char* GetSql (); bool MoreForUpdate (); bool SetBuffer (int nFieldIndex, BYTE * pBuf, long nSize); bool SetBuffer (const string & sField, BYTE * pBuf, long nSize); bool GetBuffer (const string & sField, BYTE * pBuf, long & nSize) Bool GetBuffer (int nFieldIndex, BYTE * pBuf, long & nSize); long GetDataSize (const string & sField); long GetDataSize (int nFieldIndex); long GetActualSize (const string & sField); long GetActualSize (int nFieldIndex); void ClearSql (); long GetColIndex (const string & sField); string GetColName (int nFiledIndex); string GetColType (int index); int GetNumCols (); string GetHeadScript (); int row_getsize (); bool row_gethead (string & sHead) Bool row_more (char * pData, int & nSize); void SetAutoCommit (bool autoCommit); void RollBack (); void Commit (); bool IsDead (); bool SetParam (int nType, const string & sVal); protected: void WriteSQLErrLog (); / / get process return value string GetStorageProReturnValue (const string & name); void CopyRowData (char * pData,MYSQL_ROW row); / / added by cailei CStdString GetCurTime (time_t nTime=0); long GetCurDate (time_t nTime=0) MYSQL * mSecrethMySQL; MYSQL_RES * mroompRes. MYSQL_ROW masks Row. MYSQL_FIELD * mroompFields; long mleavnRowSize; bool msRegParam; / / whether the procedure return variable protected: string mSecretsSvr; string mSecretsUsersPwd; string mblsDBs; string mdistribusUserMode; bool mblbReopen; / / whether the system reopens the connection to SQL / / 0: SQL idle status 1: there are SQL statements waiting for execution 2: there are result data waiting to be fetched; / / the number of result set records is int mblnCode; / / the error code is 16K string mssErr by default; / / error message char * mSecretpSQL; / / SQL statement string mSecretsSrc; / / calling source bool m_bError. / / whether there is an error in the execution of the statement int mSecretnDBType; / / driver type void * mroompUniDBRecv; / / keep bool mSecretbTrann; / / transaction flag void * mroompReqBuf; int mSecretnReqSize; bool mSecretbDebug;} # endif / /! defined (AFX_EMBEDDEDMYSQL_H__516724E2_889C_4899_9DAE_330CD4C5954F__INCLUDED_) at this point, the study on "the implementation of embedded MYSQL server" is over. I hope I can solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.