SQLite3简单使用的详解.doc

SQLite3返回值的意思：#defineSQLITE_OK0/*Successfulresult*//*beginning-of-error-codes*/#defineSQLITE_ERROR1/*SQLerrorormissingdatabase*/#defineSQLITE_INTERNAL2/*InternallogicerrorinSQLite*/#defineSQLITE_PERM3/*Accesspermissiondenied*/#defineSQLITE_ABORT4/*Callbackroutinerequestedanabort*/#defineSQLITE_BUSY5/*Thedatabasefileislocked*/#defineSQLITE_LOCKED6/*Atableinthedatabaseislocked*/#defineSQLITE_NOMEM7/*Amalloc()failed*/#defineSQLITE_READONLY8/*Attempttowriteareadonlydatabase*/#defineSQLITE_INTERRUPT9/*Operationterminatedbysqlite3_interrupt()*/#defineSQLITE_IOERR10/*SomekindofdiskI/Oerroroccurred*/#defineSQLITE_CORRUPT11/*Thedatabasediskimageismalformed*/#defineSQLITE_NOTFOUND12/*Unknownopcodeinsqlite3_file_control()*/#defineSQLITE_FULL13/*Insertionfailedbecausedatabaseisfull*/#defineSQLITE_CANTOPEN14/*Unabletoopenthedatabasefile*/#defineSQLITE_PROTOCOL15/*Databaselockprotocolerror*/#defineSQLITE_EMPTY16/*Databaseisempty*/#defineSQLITE_SCHEMA17/*Thedatabaseschemachanged*/#defineSQLITE_TOOBIG18/*StringorBLOBexceedssizelimit*/#defineSQLITE_CONSTRAINT19/*Abortduetoconstraintviolation*/#defineSQLITE_MISMATCH20/*Datatypemismatch*/#defineSQLITE_MISUSE21/*Libraryusedincorrectly*/#defineSQLITE_NOLFS22/*UsesOSfeaturesnotsupportedonhost*/#defineSQLITE_AUTH23/*Authorizationdenied*/#defineSQLITE_FORMAT24/*Auxiliarydatabaseformaterror*/#defineSQLITE_RANGE25/*2ndparametertosqlite3_bindoutofrange*/#defineSQLITE_NOTADB26/*Fileopenedthatisnotadatabasefile*/#defineSQLITE_ROW100/*sqlite3_step()hasanotherrowready*/#defineSQLITE_DONE101/*sqlite3_step()hasfinishedexecuting*//*end-of-error-codes*/关于事物intresult;result=sqlite3_exec(db,"begintransaction",0,0,&zErrorMsg);//开始一个事务result=sqlite3_exec(db,"committransaction",0,0,&zErrorMsg);//提交事务result=sqlite3_exec(db,"rollbacktransaction",0,0,&zErrorMsg);//回滚事务关于SQLite3和标准sql之间的差异和用法（不全）1.sql语句中不能使用top关键字，比如：SELECTTOPx*FROMtable_nameWHERE....ORDERBY....DESC检索到的记录按降序排，取其前x条记录。在sqlite中应该这样写：SELECT*FROMtable_nameWHERE....ORDERBY....DESCLIMIT0,x2.拷贝表数据，拷