iOS数据持久化之数据库：SQLite和FMDB

时间：2024-06-20 13:04:14

SQLite：

　　SQLite是一款轻量级型的数据库，资源占用少、性能良好和零管理成本，具有零配置（无需安装和管理配置）、独立（没有额外依赖）、储存在单一磁盘文件中的一个完整的数据库、源码完全的开源、比一些流行的数据库在大部分普通数据库操作要快……功能特性；在大型系统和处理大批量数据时不适用

     SQLite引擎不是程序与之通信的独立进程，而是连接到程序中成为它的一个主要部分，所以主要的通信协议是在编程语言内的直接API调用；在APP开发中将SQLite集成到应用的沙盒目录下（SQLite是以文件形式存在），用于缓存数据到本地，通过Objective-C可以直接调用SQLite的API来访问本地数据

SQLite在iOS开发通常不直接使用，API代码调用很繁琐，因此一般使用第三方框架FMDB或iOS封装的原生的CoreData；使用SQLite需要导入最新SQLite 3.0/SQLite 3框架，而且可以通过代码直接创建SQLite文件和表，需要注意的是数据库每次操作前都需要开库，在每次操作完毕后都需要关闭数据库；如果直接使用SQLite还需要通过FireFox的SQLite Manager创建SQLite文件和表

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAi4AAAA9CAIAAAAF9XWUAAAgAElEQVR4nO3daXAb14EncE9V1lMTJTOJ452yZ6qcZLJVuzvzYXc2s5PZSSbxxE7sWLYTX7KjWJZv67BkybYsWZYs66BO3hLvCyBIgAAJniBxEwABkOAJXiBBEvd930A3ul/32w8gKeq0LOui837FKlFgo/EewOo/X7/rPoggCIIgd9V9d7sACIIgyJ+75SgiEQRBkD8HgCLxZHq4IKU5ntLekS/N8fREJZHNkCS4sjg3GUUAQRAEWb8oCNIBWHofPH0fPHNHvk7dB+sfILEYCahbE0WRSMThcDgRBEGQdcrlctpNbvkJt+gzt/jQHfhyCQ/6taUEfutaRTiOpxEEQZD1LZMG8E5+ZcA1U+ZmouhuNywRBEGQdelWRtFdBACg1rjbxbkZa6twnQ8GQRDkz8d6iiKKonAcj0ajgUAgGAwmEgmSJNfR1Tz3R0E6nQ6Hw4FAIBwOp1Kp6/+lgCAI8udg3UQRACAUCtntdo/H4/f7/X6/y+Wy2+2pVGq9NI8IgvB4PA6Hw+/zBQMBv9+Xqw5BECiNEAT5c3Ybo4iCEEJIUbl/IU3TuXtTNE2vPkJT1I1cgwEAgUDAarWmUqnVp+fCyWKx5NoWaw9fPWYVSZIUDSGkl+tMUyRJAmrNETR9yQFXxFvuWdTKmXMFh8uPUhBC+suq4nA43G43TRIXX5NcDieCINaWH14NoC6v1OUHAAAhBCQJAHXlp5mrHVit8/I7QOXqkjv3DXwUCIIgt97tiiIAQMLrWDT7MCzjdZpm5hcjiRSeJZKJWDQWs5sXJmeWwpFoNBbHsytPuUb3DwAglUpZrVYcxy9m2EokRCIRm812yROyWCQcNhlnBoYnlxYXpg3TRrMHQJiKuM2uCITQ77J4IxiEkIh5JSKpUDFisVnswTiW9FmdEQihz2HzxdNrr/I0BaymRX8sg6fibpfH7QumMjhFUx7r/IIjRBCYy2oOxAkIr94+y6Wmw+GAEMZwwJ4Jfa5wNU2HojiAEDocTr/fv5KmAJCZ+akxoVQp6R8Qy1W9YnlHj0g1vpQI+WQyhUiu7BHKRHJVn2Rg3uWeHtd19clnlmzzS06KpuYXFgENs+mEyeIGlyZX0u+as/kpivD7vA63NxxPkYAikrHpGWMcJ1Jhv9nhzSUZgiDIHXa7oogiibn+bmZDR0dLC5NZX1ZV08RkavTOOb1OJle0NFQcP32hTyhVqEeCMZwCgCRJLJNKptLE1c7m9/uj0ehqCF3G7XYnEoncpRxQVCroZDPqDp2q6h8cY9bWdSsHugX9Sx4Pr67s82LmoH6KXVt2gdHWLdct6tVnSmrL6hvLi0sruQJGbenhfPaS09nL5XQPzcaTySG1oq2rTzw4nQwHxWKJVNZ3oayhVazisDk82RiksPZmzuD0FKuFy2IxewcXgpHYVctPEITD4SCyWYykPxBaHy6c+K/54w8VTOzss6YJiiCydrs9m13JZDIb8DjGxsYV6qFh/dz0pPJsYcOMMxYy6s6WNysV8qPH89v6NU3VdWylisNqKCljVTNq8i6wenoEH+w/2q+3mQ2TFQ2djkDcbTJ09Qj5gn5LMDQ9NCBSaBuZ1TXNYolQWFbH82Zp1/xIc4e0Xyxq5bbWtghsbn8Kz6I0QhDkDrs9UQQAgaWHelpqKpnV5VWN7BYGg1FfUSZQarlNrO6O1vOl5d2igRHNAIfJmF5wQUjTgJwfELVJNckrbtkRBOF2u7PZ7FWjCEIYjUaDwWAuiigAon6PXCI6fqa8W6oqKsiv4oq6+2QK7WBTh9g8NXb82KmaVoXX42xmsJUa5ZnTRaWshoOfHq/gCntF/AauyrIwU3wmP6+ooozVXt7Ypp+aq2HyRgeUBedrGtgtxcUVXJm6ubGRKRi0jiuPFrIkgvbSen5JSfGFJsHwrJm42uytTCbjcrkghBp74ielk48U6/+hdPKRYv2PS/T9ljiE0O12ZzKZ5SpQdMJnZzCb2ntEF+q4i9ZpNkcUJ2FsaeRcOUsiER/LK+CKFcyqOp5ay22qKihpzjt16lhhnVw5UlxWs2APSrtZB46WFlcymPWsDuWQqLejd0BZX1dfVs+rrSsvZYjlYuGZUoYl6Ksvv9DYK66qYzAbmHlFNQKZzpfKUKjjCkGQO+s2tYoAIDGjqreujisTitq4zAuVtT1CqdFm18kFF87lnSltUA+p2nh8hVrj8kdz6YNjmQyGXdmqyGazLpeLIAiapqkrQAjj8XggEFi+wQUAgWMuq6GoqKJHOSrpFfaqtGKFzu+2VVTVc9gtlU3dGo1qdGJe2CkYHVSdr2DWtfN53KaqmqZqdlOnzAAh1Pb19mvVLXwBq6M/Hk/z23uWjPr8wirdxCyjqrZNMcjjsJu6VAN9fcVV3O5exbzF3tPKFo+Y/IFQhri8BrlRc26XC0LYvRB5pET/45LJfyid/HHJ5CPFev5cKBdF6XR6NYqC9oUO8SCEsKO1bcIwwmruC+PLUSQWiY6dKGwR9TMq63hqTTuvqaqmndPRU9VQV8vsqGTykiRMBKc5rQMKaT+7uXvYZJ/Tq1SThuaGGq58VNnTXMaSDsilRRWscdN4fVkVq7uvf3hmfkTDbBU5PL5IPI2SCEGQO+x2tYqyWHSwm8PmD4wopQ0MJqe5icnri2VJx6Q87+ixwqKS2sbmc6dONnSIQ0k8N78mGQkFI/Gr3uDyer3pdPqqUUTTdDAYjEajqzfokmG/Qtp35jzbaHZ2Mmp2fFE2rNMrBwaaO0WGUR2vdwDDE7aFBX5bj2FIWVzRVMVmcdgtIwarXMTj9U2TeLS1tXt2apLbLmjky4LBGLety2mxtLTwmjj88+U17cqhVg6b1TuEp+L8NuHgyJRYLisuLCpv7lXqpmNZ4sorOY7jLpcL0pQ9iv2KMfe3+RN/X6T/2/yJXzQYTOEMpCmX04njeO5giqbDjoXi85UcvqCcyTc7ZlhNvWEc2sYUHNGo12qsrGjQO7y6vu7WATWP01RZ3VLH5XWpRuenxs/XsOI4tEz0t8kmtAoZu6lbazRPjciVM3NamaiWzWc01FQ2ywf6pYVlLGcGWxhSdCrUGo2W38w6UVTbLVEtukI3NpQEQRDklrmdfUWKHm6vVq+WVZRXVZafb2iV+LzeSY2Kz+/p6eaU13UPKfp75SpHOEZRFA0Io1rSoxpNg8svhACASCTi8XiujCKapnEct9lsq9dxkiQBwB2Lhga2oF+m6hJJuC1djQ1cdpe4oqahubG5hicJBYPzM1MVja2L4+pj+TXDxoUuXotm2qGStXfKZhamtKw2kVYh4XTKKytqmOz2s5Uci8Xar9L1dXaeLKzSLtpU4p7SJkE8GubyhBEcQgi1ku4pR+Za3f4AALfbnevukpljL/AWf1Y7+xx3QWyK5m4wulyu1UGAAIBMIjI3v+j2Bpx2+4hOUtXYl8Sy4rbWCXcaZsJsVsukzSrkcbu02sbaaq54ckgpbRWprfMzpQ3cSDTEZ7WIh0f5re1tLW2l9U0XKmtEYzNjw8MqZX9pUUGTcMY6P1VcVKn3RucG+6V6C4QwY5/rko2sjqxDEAS5k25jX5F5YX7RbjJMT9s94XDANTU1ZTObTSZ7OOCfnp40OYI0AC6b1RmKkgCQJJnFsQyGX6fbPxwO5zqHVnuJSJJ0Op2rHUW51yay8Ynh4TGjLZpMQQhTfvvA0KQvGDGZrG6n02x3e21L8n712IIjFQ2Y3CEIaafNYpxfUA6OekMxp8Nms9uGBodMzpDZZHF7fMYlayKZTGFEwGWVKwbkA1q5Ut2vm4zGEzabK4UDiiI8Tlsghl2rOZG7R2exWDLpNIQwmQXmMJbASQhhJpO5cjw6WB4BT4ddln6VZtbiBQS2ZLJkSACwtMVsMsxP92tGPcGg3e7EKRgP+cymJZ12SG9yp1PBhQXbvGFqUG90u51mu8tqtbiD4VgyTaWiQ1qtVKntH9BKFYOLnlAk4HUHY4CisFjI5vRdtaMLQRDkdrtdraLLJsfQV/mezs2DoVcGcANAXavDHACAYZjD4fB4PKlUKpvN5pZdsNlsF3uJrnjp3KSl1WlNVxaGopbzbE3hLplqBC8eCSjqstHRkMrN4wHL7+P15xUBABKJhNVqDQWDJI5BiiRxLBQMWq3WeDx+rVm6q1OJci9BAZIEa95Yms49uHbGEbhkttTFelGrs4fWPkivTjCic3OqEARB7rzcNWl9rLaQzWbD4bDX63W73R6Px+fzXecifg+iKCqdTgcCAY/Hk6uC3+9Pp9PrqAoIgiC3w7qJInJlIVEAQG5tgtx/73ahvprLyowWoEMQBCHXVxSt+gZcwdd7+REEQW6hm4mi3NA1BEEQBLlx17mP9ZWjKDe02ul0uhAEQRDkhvl8PuKKRQBuvlWUyWTiCIIgCPJVJJPJW9YqIq/YShVBEARBvtQ3Z0NxBEEQ5JsHRRGCIAhyl6EoQhAEuaOufZ8KrL2Zddlz1t7ouv1lvNPupSha2W6cWrMwKEXTaz+USz8hcOXndY0Tg0vHEQKKutG9zBEEQb7U6qpaAKwsJEaD3CJkNEWRK8txUQCsrDB5cfmt1R+RJIljmWQymUymssTF0+auVFg6nUwmk8kknr36ILR17V6Jotw7Ti1v2EORJJn7YHMbP+Q+scufsoqi4Zq17K75EmC50wwAtDkcgiC3DAAAiwcnhgcnZs0kBX32ucHBkWCcgDQIeV3+SJJIRWcmRnQjk2GMjHlmOdz2wZERnU43PKYPhGP2hZnRCUMqSwcsUxxOi1Ao6u1q7xAOZkgIsKTD7sIA8JgmeFxOV3dPZzuP19kfz9DfsIvYrYwiQJI0BSC82nKcEEJ47XYlAABLqAXsAx/ueued987WtGcAzISdnOrCXTve27lnH7NDHscokPXWF5yo6VDhNE3TdNA0cmj/AfmUnQaZReN8MJamKYoEIDeXavVzoml6VtP90QfvHy9h+pIETdNhiz7vs737viixRFL0ymxdamW7o9xOFDRNg4uP0PTKWqerDSx6pVkFwPIBuR/TNJ372dd8MxEEWS8oGvitc1qdprm6SjU+x26oE/B5PIHWPKc7c/SocMqatOiLi84rh6Zi6bism9veK2oozy+tZSvUg3a7c3pirLWhtn/GbZ9WFpfXyPsVEgG/itEVz2SlvKrjBTX+LGmaUPaoNG6fz2WZ43K7A/Evv6sDVi6GdwD1ta94tyyKIEVCSJEk4QklBue9Er1LOO7sG3WIxp2ySdeEKRCOpyENIIRXvoU0pBeHOjb97jevbdv7+cF9n+SVR6OB8sPbHn3sqd37Duzd8cZvHn+yqEmexuwHXn/hw2IuBiFN0xGr/uyJU4NGl21UsHXr2/JxU64hhWfS6Qy+2qqFEGraLvzy3/7vo0+9Ip9xQwjVraW//vd/ffS5d6f8CUjTWCaVTGUoCGkK4DiGZ0maAjiezaURIIlUMpnBCbiy6HUWxwEARBbH8WyuwZZOJbEsCSEks1kMx4ksnk5nvoFNaARBroGCEGb9nOoqUXc3u1eHJ311DKbT4ehrZgj15mTAym9p4rR0GE1OKZ/N65Kyqgov1HM1urFwImlb0Lc1N49ags5ZzYXqBoVSJevrrGsWxDOkbVJbU9fkxgjLZH9VXV1Xj6CzjV1Wywslr78TAEmSJI7jfr/fe0fE4/Gv+QbemiiiAOmIkSW9lqcPi/9pe/tDr7V8bzPnrzdz/vqPLX+zmfvAq9xH3mn/Px/2vlGqbRRPJlPpy3rtIKSnJPVP/PI/Tzf0xjGSJEnbcNdTj/1nQZOchBCk/CWfvvOHrR/PO4xHt7/6aRkfg5CmYdwydujAwS5Rz6dvvfAfv3z0+VffVxrMIzLuJ3t379qzj98/RVJ0roba9sqXXnjxpZdeOMWQgmy06NNtm155+fk/7Z6PJqZVrfs/3Ltr957zrN44DsTsCwc/P3H2xOE33tzOEY/j2Qj7wsk9H3ywZ98h6agJgqy2m7ntzdf3Hz56YN9HTMEQnY13M0p27dz54afHh4xe92T/R7t3H9h/4Fw1L0RcsQkggiDfRICi4j57Xxd/bDEYMWgYPdpM3F3DYGEEPSnkC8aMub+SR4W8pk55R2P5hfr2+rJzxVUsiVg6vWj3e+xKAV+sM9omVSUVdX0isbC7tYbVkyQhjLqbmc0ujLBMDQ4tWiGEEKQkfbIvbRVRFOX1en0+XzQajdx+l+1fehNuTRRBimxyge80B/7qmP5bu4b+8t2Bv3xD9pdb+u7f3HX/nzrv39z5rU38v3iefd8TZd/5+fvzi+bLtsYBFIVHPQ1nDz771O82v71HMmEdEdT99qk/aJcyuYL1N+c/+eLrw7Mjx3ZuWY4iCEOzsj889QyzS1ib9+ETTz594OQFmaz9zT++eKa+rankyDMv7zSG0zRNQQg1bWVb3tp9+ov9b+7NGx+W73j37byTB1545f25SMI6OySRKTgVJzY+96rG4G4tPfj4k89+euTIluee2PR+nj8W0cjFAyr5oR2b3zxQsmTQvPncE5vf3XP88L7fPPbYuSbxtJTxzLMvcgSS/APvvLm/aFzBe/qxx78o51hcga/1sSAIsn5ASA71ME4V1ohkiiWzqa25pqmBJR6eo2hqQtwpnbKE/Q6ZoL2xvnliyW4xL5lNpq6mSma73GQyL83PSITdzQymamxO1MWbtAZpkHUtTrM43QkCkiEHl93qwcmlcUlFfX2fSNzbySutYAcSX9IqoijK4XBkMhn6is2vbzmapp1OZyaT+TqrPN+iKAJkY5h6xA1/kYY/HoI/aIYPFFMP56UfOep78OP572zXbXhDsuFl9n95LO+v//kVw/zCVV4LUBDCgG3m5Iev/e7F9/m8hicee7y+bxJCCCFWn7f7mVc/mLXNHd3+6ue1fbnSxo2KF595rnPI5B/rfuGl12d8Ketw0zOPP/nOrj27d777yqvbNEvh3PZ3mrayLe/sl4p73vrTlgP7du05WtzDLX7+5Z2zgYiyvWbX+zt2bnvjqd+/Ihtbai87tHn7kUAKCC8cfHHbIfPSQvnpw++/v2vrH59/be9JhZD5+6c3yYwhiDt3b3mpqKlPUP75Y0/8fu9HH217e+u2j07KpZxNL20ZMLjhNXYWRxDkmweQZCIStFnNi0umSApLR/0WqxMnaUCS6WQiieFYKm4xLbr8kdXNK302o8UThRBCQHgdVpsrgGWiM4Z5DNBE3CvqbFeMzRMURWbxeDyRBSDoWhrV6xdNpkXjrG50Ool9yVWfoiin05lOX34L6jrHrz0w17F/40OU76EoYkWoH7rgr3D43/TwwTb4g3L4o3zynwriDx9Y/O625Si6//GT3/vp5iujiIZgVtd+7IuTDYy6fe+9/Ojvto7Mzx/f/vKjT75wpqQi//j+3z3+xOkGcQpzHH7npU1v7ymvqqxh8CbUfc8/9XSb2ujU8Tf++vF9pyolouZXnn32dF3bxNiQRD4YTZG5jWIHuMUvbtk7Z3We+/C1n/38sVrRyGBX0cbnto1bJ9/7/a/3nqnv5hT+buMLklETr/jAH7d94U+QvaUHXth+WMyr+PWvN7JF8lMfb3155/Hh4d4/bnzivY+PFJ354vdPbyxiS4bbz//2yefZfQNjOrV62GBQcp/9/cv9eivaERVB/qxQK/tEU8tDemGu1bK8x9ryYG569VJNXxwVvLwvc+6Yi2OGly+SgKZpQJKX7cD8pdf8G4+iXMFxLLO8TTVNQwjxTAbQkMAzJH2V0cuXuZeiiCI5fvLHZuqXaeon4/SDbfAHZfBH58h/LEg8dGDpu9uHN7wh3bCp+f7H8x742etLZttlV2qapmwzst2vv7Jx48bNb+xo6h0kIQxap84e+mDj47/8l//36Ok6AQ4hpLznj+x58bnnnt741B9efk8ile7Ztl04as6EFs98su35P23vn5qXtlbuePfdbdu3FzWKMgQEgKRperSvcfe+E9ZIVtdZ+daO/QZfVC+rf3fn5wvBYGfNybfe2Xbw8KfvbN+rnbEJG/M/OnI+kCAUjefe/7x4yag/tm/nzj0f7/9w90fHKjzRALfi9NYtr+3Zu/eFPzxzrklOJHyMgi/efvvdnbs+bFVM28bFO3bsHTI4URQhCHIX3WAUAUBGA54F43x3UzWDLzWaTL6Q3zw7LRZ06efm2hlVAu2EPxwnv+Qk91IUsVzkw0Pgf45k/o4X/F6h6W8OGx/ab/zhPv0D70i+vbn12y81/dVztff/9vT3f/HelX1FucrgWDqRSKSxLIQw15qBkPYaRz7Yumn3F6Vjs/Murz+dSiUSiUQikUymcBxPJpMYnqUomsxiyWSKABSEMJ2IRaIxnCBX3xUcyyRTKYIgSQJPZzIAgCyWSSZTBAkgTcZjsTSGp1MpPJvFMulUKk2QJJ5JJ1NpioYEno7FEziOpzM4GXJWnfniwGeH33/rT799+hXBiCX3B0o8GonGEgQARBb7pk5AQxBkHbmxKAIQZiR8RjOvncNqbO0U8NmMdqFG1tb4xYnTjYzqPe+99dGR08pJC3XdhtG9FEWAZIWpR2zw3/z0I3LyBw2ZBwrSDx2NPHLY+uCeye+8q9mwVbhhE/v+35763r9snp6Zu1pfEaBXmodr1lagIYSLI71vbdr477/89dHKjjWNVJqiKLg6K5amIaQBIAFYbmWuHV8CKArSNLjsG7j6DaRpmoY0AMuTiMjclFuaXj0zTdMQQirhZxYe2bJly3u7PuYKdRmCWj0DhDRYaYajHVoRBLm7biiKACCJpFrWN6CWsVi8WZN1ekQr7O7lcznlhfn7P91/5lxBQfH5QYOToq93m+feiqLGCPVDF3x0pa/oweUbdLm+ouENb0o3vMK5/zcnv/fTP149iq4FAAhpt3lWLBJNGm13/ypPEBiGZQlyNQURBEHuNTcYRQSOGUb6j+7fc+R0YUnR6fM13JHRcZW0O//kFx99crAo/9zpM+dHzR5w3Rms91YUsf3kj0z0fyTAT0bJB9vggxXwRwXUPxWmHv7U/N0doxveEG94iXX/b/K+/7Ot8wumr9iVAlabQjddwluFWl18AcUQgiD3qhvsK6Jo4LPNs6pKzp7LLyjIb+lRubwutbQn/8zJ+hrWhdJz1U1dNn90/UQRRbI95N8NUv9dHXu42f7ABff3TzgfPmT+8UHDgzs0G7b2fntT8189W3b/b05+/+fvzS9cva9odekIcN0dlr6+5cV7VtajW7OET+5Vwerol2s8f2Wgy038dJ0DgIQQQJhb3glAuDyNd/lBikSzehHkXnCDfUUURbjNBt3QiNnhS8ejM3q9zRdKp1O2xXm7N0oSydmJkSVnYP1EUW5ekRX+q4f+oQL8oCb+/RPehz6z//BTw4M7td95XbThtZ4NL3Pu/+3pa/UVEdlsliABBUgASILI3r6efwBoioyEQ6kMTkNIkVgwEEhhJIR0rggEHl+Ym4+lr5EoAGSTUbPZmlrZoT3XObXmpzGT2ZpaDyMXcmNOv8LxgEwkMKk1IbAkOpYSPZakxJ4KYySkwbwrqXRlQhkiga+DiiPIN95XGMy92v1Or/bCUyvf0bl/r3+GeyuKGGHq753wV1n43ybgg23wwXL4o3zqHwuSD39q/u72kQ1vSTe8zP7W43nf/l+bpqYN8PJ5RbRlUlpS0ehLk5DCOuqLRcMmeAUKrNypoy+uuLq6xPrykP2VY+hLh+HTucdpCpD4mFrGbWnpH5pJRX3drc2trS0cXqfdGx9SCmesAYqIjo2M+n0hq91DrnmZiycP25obWz3ZlbH/2fDSkmu1QIRnkclqC0MIVyYKQAip1XXg10w+IEkS0Kunv1ij1YkFF+u7XKPlMRFrH1s59pIq05fNQbj0LKsnyabiFrtzzbGrZbv6pwwAmUniZbrgXlXgmVb3TlWwQB/3x/F+Y+yUOnhEF3xb6OVZUzRqGCHI3fZVp7h+HfdWFLVHyP9hB/8cI/92DG7gwe+UwodOkT85E//+x0vfenv4L16T3fc0875ffP7If76zZLbCS8dj0JA2jrTv//BT2bQn7jWcOnygc9AYcZnlcrnR7reZZuQSsVQ1nEhjjjm9TKb2JDLOxfE+gUChGQ+lE8YJnUI95AtjFAVIPDM7MSRXj4QjnlGtqlfYNzVnNkzNRLOEY2neHYwDLMyoLptY9JIkqROyeeIJGtLGIQGLK+1qa9bNOSFIW5eW9BL+J4dPTlvd5ulRuULtCqcpQAESM4yr2xtrzpWxnBH/qFqp0xtnB9s+/vjkpMVtnNQp1KM+80JdWVlrr2B4ahHPxPW6AeXgRDwW06ml2vG5ZDw6olFoxqYTWJaiKDzqU0mEPbKBRCI5Pa6TCAXqMSMBKCIRnp6aTRJZ88K812EdkAgFcnUsFjfMzmZSyYW5ebt1SSmTTps8gKKyWFAj7ZNr9bGYWyns6+0fjCbihtFBiVis0Y33S0TTi27XokEplwgkKm84YjAYMqnUknFOLW//7PO8GXPANDfRr9Q6AqGZCY1MqQtn8Kv+RgFAUnj2tNi/VxV4ocOzWxH4bCDmDmR65qL149GaqVCnOUmie3QIcg9YXfgH5kYA304Qwtxr3f0oAiSZypLjCbzGE3pD6/g5x/7TyuC/lYR+Vez66dGp//2J8t/3dW09I7jQOjC7ZCcI4rLy0pAyjglZ9az6xlZuC5vH5kh1s/Mj4sJTnxfU8NtZ1azWPk59rWbGoBW3Hz90qL69raGWOTs7XX62qE/RfeL48VNnjrcKpwCEWMgl4DE/O3iwS9p79kSpQiOprGnqa2VLtGO8puYFXxLStGNhuKmGoZo0CDiVgwtJCGHCO1PfwOto4+lNAUj6Whobh6Sykmr2+LD0+LFj5/KON3QPURC6F3UMFl+vkZfVNs+aZtk1pZ8cPqvR9RQWNtrcTgGPefjQke5eSW1F5aB+nNvcODGh726uOTM8EsYAAAYKSURBVPDJEblWmX86Xz23qOisP3789PGT5waNTkgTUn6TWD0x2Mvl9UhLCvLEMnXlhWpzIkvhUUFLo2p4pIXFbmTU9w9OagWcpnZhZV1DOhLhMhr7ultKals8kRSkiME+NqdX6fF7hdxa0ZBBLeC1dQiqS4u6enuLCi5IRMKGRl4rs7KxVzUs7Wps7a6sq09HIlwGU6aRl9cw9SOKs3knTp48Vd/aU1p4WjaxSF+jZQQASWH4QYFnpzLwTKvnDYlvlywy580wx4O7xZ5nulz7hkPNC8lUlkRhhCB3FwAgFArZbDbX7ed0Oh0ORzab/ToFvjVRRJIkRZIQkBAAkIjHorFQNOEPJ3zhuD8cC0djiVgE0tnlG1BXJCcNqZnB9nbhcAez8FhJy+SghN8nriw808xmnCysamtp1C84J3rb6jjs8+WV9ZVFJTUXKi7UL5mW6orPC2T8ovMN/QMDBqsXQjij4Z8vZ5SfO9rAa62rE8Sioeq6eod5ujAvjy0aIWhIYFGjYW5qTFNUXjs2LGU0tVvsNmUPW6Sc7uHWdfePuB3TzLrG2bGJWkbr2JAov7BKqVVNLzggpG0GaWUd3zCiPl9Wy2ysrG9inzhycsAwUF3eopN3nTtfW1uS38BuLS+rGjXMclmM5rrK6gZ2wfHPe/onNMKOgsJyZlN1NatDM6B1BtM0hQlbGiSD0+OStuZ2YUVtTSwWaauqngwmIIRu4+DpY6cE6sk+HlOmmx0TtzZ1iivLSwaHBooKzgt72luVehpCSGU1XSy+bNTuWuLXXRCPLg2L+bzWzsZGjtVj4zBaFm1zbGYzt6m2rX94VMJjd4orK0oGh1SFBWXj89OMRvaETl5UWt2vUOon52pqa4LR1IRKaYmnrzpGEAJSNBnaI3LvVIWWwtiEK+MKpatGAicU3kMjgYP9vqaFJHH9mdkIgtwpqVQqHo8nbr+vuSw3eTt2caUpCtIUpFfHWeW+rre3EqBAwLmwYAkEnCaD2RP2WJes9nGVpEcgGhqfWpib9QQi7iWjccmokgj7hKKZJcukTt7V2px3smQxHNarZEKZ1h/HKIqKeEyi3l6RSDa3uDA1tZhKJiZnZrGor6rg3IQzAmkKEBnjuLajs3ts1kxDsDChZpWd/uxk5ZIzOK/X8tvapArV6PhsOBpWy4SzC9ZpbX+3WOlLZiiKIrLxYaWws7NrYHR6fn60r6dHrNB4IxG1tE89phP39oilcsOiaXigv7OTr5syeS0LvX09QrHSYrWrZX0qnSESDslFXQPD01gWUBSVCdiFXR1dElUsnpic1KeSyfnJKX8KoyHE/EslBSWmcIYIOnq72rukAykcN44r+fwO+eCY1bQwb/OQFAUoCou5pV1dijFDNGDt5bd3y7TJWNQwNRuKhg0zc8FwwGiYFTbXlzGYnSJFIoMtTKj4/HaZdjwSC2ll4qkF19SIqlei8PrDM9NTqWRyXKmyxjNXRhEFSE8oxZiMntSECkdDNTOxRmNcbY7nj4WLh4M1szF7nLiBxbEQBLlDciOT74Cv3yN166Po5tBr+t2v0ue+ZpxCrmd9dkzb2cHrFA3gF4cyADK3gdUagKIgpEb7e9vEGoKmV8dqr9Q39z0+M6pWaPX42he4tOefXtmw9cqiweuMEbiyHivH5j446uLjF4ck0AAALDHQ19mrHgf0xZpTFLjsbLm37uLYh4slouHKWInc80dFgjF3BF46PuLyOq4dFnG1XyxAkqlM1hzFAU1BQJjC2FIECyRwSxTzYwSEFERb1yIIclNyV6G7H0VfCQAAT8e9Xn+WvIFFzIlsLBrByWvvNLUSMPfQn/NZPBaJZsEtm0ibxfEscQuGWQNAQmp5yD2kAKQATZGQAvfSe4cgyPqzLqOIXFn57QYv1dQ6XB3h1pYZ3Ni+IwiCIHfFeo0iBEEQ5BvjJqMIIAiCIMjV3KEoIggCw7AMgiAIglyB+Oo90zcTRTiO56Y1IQiCIMhlUqnUV20b3XxfEYEgCIIgV/hKUfJ1owhBEARBbgkURQiCIMhddkkUIQiCIMjdgqIIQRAEucv+P+4g9gFHNmXQAAAAAElFTkSuQmCC" alt="" />

FMDB：

12.00

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

　　FMDB是对操作SQLite的封装，框架实现了通过代码直接创建表的功能，建表前判断表是否存在，不存在才创建，因此开库操作就是调用建表方法；FMDB将对数据库的操作分为两类：修改（update）和查询（query）

FMDB只是封装了对SQLite的操作，因此在使用时还需要创建数据库管理类：DBManager，其对建表（开库）、操作类型（每次操作完后关库）进行封装；当数据库和模型绑定时，需要在数据库的操作类型中进行数据的模型化操作，操作模型即能实现和数据库的关联，而且每一种操作类型都能被够复用

1. FMDB的下载地址 https://github.com/ccgus/fmdb

2. 在FMDB下载文件后，工程中必须导入如下文件，并使用 libsqlite3.dylib 依赖包

3. FMDB常用类

　　FMDatabase ： 一个单一的SQLite数据库，用于执行SQL语句。

　　FMResultSet ：执行查询一个FMDatabase结果集。

　　FMDatabaseQueue ：在多个线程来执行查询和更新时会使用这个类

对FMDB操作类型的封装，DMManager类封装的对数据的增删改查、指定查询、建表（开库）、模型转换操作

#import "DBMamager.h"

#import "FMDB.h"

// 宏定义表的关键字

#define TABNAME @"MEMBER"

#define ID      @"MEMID"

#define NAME    @"MEMNAME"

#define SEX     @"MEMSEX"

#define TEL     @"MEMTEL"

#define QQ      @"MEMQQ"

#define DB      @"member.sqlite"

@interface DBMamager ()

@property (nonatomic, strong)FMDatabase *db;

@property (nonatomic, strong)NSString *pathDB;

@end

@implementation DBMamager

// 建表

- (void)createDB

{

    _pathDB = [[NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES) objectAtIndex:] stringByAppendingPathComponent:DB];

    _db = [FMDatabase databaseWithPath:_pathDB];

    if ([_db open])

    {

        NSString *sql  = [NSString stringWithFormat:@"create table if not exists '%@' ('%@' integer primary key autoincrement, '%@' varchar(20), '%@' varchar(10),'%@' varchar(20),'%@' varchar(20))", TABNAME, ID, NAME, SEX, QQ, TEL];

        [_db executeUpdate:sql];

    }

    [_db close];

}

// 查询所有

- (NSMutableArray *)getallMember

{

    NSMutableArray *stus = [NSMutableArray array];

    if ([_db open])

    {

        NSString *sql = [NSString stringWithFormat:@"select * from %@", TABNAME];

        FMResultSet *resultSet = [_db executeQuery:sql];

        while (resultSet.next)

        {

            Member *mem = [[Member alloc] initWithDic:

                           @{@"memid":@([resultSet intForColumn:ID]),

                             @"name":[resultSet stringForColumn:NAME],

                             @"sex":[resultSet stringForColumn:SEX],

                             @"qq":[resultSet stringForColumn:QQ],

                             @"tel":[resultSet stringForColumn:TEL]

                             }];

            [stus addObject:mem];

        }

    }

    [_db close];

    return stus;

}

// 增加

- (BOOL)insertMember:(Member *)mem

{

    if ([_db open])

    {

        NSString *sql = [NSString stringWithFormat:@"insert into %@(%@, %@, %@, %@) values('%@', '%@', '%@', '%@')", TABNAME, NAME, SEX, QQ, TEL, mem.name, mem.sex, mem.qq, mem.tel];

        return [_db executeUpdate:sql];

    }

    [_db close];

    return NO;

}

// 删除

- (BOOL)deleteMember:(NSInteger)memid

{

    if ([_db open])

    {

        NSString *sql = [NSString stringWithFormat:@"delete from %@ where %@ = %lu", TABNAME, ID, memid];

        return [_db executeUpdate:sql];

    }

    [_db close];

    return NO;

}

// 修改

- (BOOL)updateMember:(Member *)mem

{

    if ([_db open])

    {

        NSString *sql = [NSString stringWithFormat:@"update %@ set %@ = '%@', %@ = '%@', %@ = '%@', %@ = '%@' where %@ = %lu", TABNAME, NAME, mem.name, SEX, mem.sex, QQ, mem.qq, TEL, mem.tel, ID, mem.memid];

        return [_db executeUpdate:sql];

    }

    [_db close];

    return NO;

}

// 指定memid查询

- (Member *)selectMember:(NSInteger)memid

{

    if ([_db open])

    {

        NSString *sql = [NSString stringWithFormat:@"select * from %@ where %@ = %lu", TABNAME, ID, memid];

        FMResultSet *resultSet = [_db executeQuery:sql];

        while (resultSet.next)

        {

            Member *mem = [[Member alloc] initWithDic:

                           @{@"memid":@([resultSet intForColumn:ID]),

                             @"name":[resultSet stringForColumn:NAME],

                             @"sex":[resultSet stringForColumn:SEX],

                             @"qq":[resultSet stringForColumn:QQ],

                             @"tel":[resultSet stringForColumn:TEL]

                             }];

            return mem;

        }

    }

    return nil;

}

@end

4. 如果应用中使用了多线程操作数据库，那么就需要使用FMDatabaseQueue来保证线程安全了。 应用中不可在多个线程*同使用一个FMDatabase对象操作数据库，这样会引起数据库数据混乱。 为了多线程操作数据库安全，FMDB使用了FMDatabaseQueue，使用FMDatabaseQueue很简单，首先用一个数据库文件地址来初使 化FMDatabaseQueue，然后就可以将一个闭包(block)传入inDatabase方法中。 在闭包中操作数据库，而不直接参与FMDatabase的管理

//2多线程操作

      NSString *path=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)[0];

    path=[path stringByAppendingPathComponent:@"test.sqlite"];

    FMDatabaseQueue * queue=[FMDatabaseQueue databaseQueueWithPath:path];

    [queue inDatabase:^(FMDatabase *db) {

        NSString * create=@"create table if not exists t_book(id integer,name varchar)";

        BOOL c1= [db executeUpdate:create];

        if(c1){

            NSLog(@"成功");

        }

    }];

    [queue inDatabase:^(FMDatabase *db) {

            NSString * insertSql=@"insert into t_book(id,name) values(?,?)";

          //插入语句1

            bool inflag=[db executeUpdate:insertSql,@(2),@"admin"];

           if(inflag){

               NSLog(@"插入成功");

           }

    }];

    [queue inDatabase:^(FMDatabase *db) {

        FMResultSet * data=[db executeQuery:@" select * from t_book "];

        while (data.next) {

            int ids=[data intForColumn:@"id"];

            NSString *name=[data stringForColumn:@"name"];

            NSLog(@"%@",name);

            NSLog(@"%i",ids);

        }

    }];

12.00

FMDB是对操作SQLite的封装，框架实现了通过代码直接创建表的功能，建表前判断表是否存在，不存在才创建，因此开库操作就是调用建表方法；FMDB将对数据库的操作分为两类：修改（update）和查询（query）

FMDB只是封装了对SQLite的操作，因此在使用时还需要创建数据库管理类：DBManager，其对建表（开库）、操作类型（每次操作完后关库）进行封装；当数据库和模型绑定时，需要在数据库的操作类型中进行数据的模型化操作，操作模型即能实现和数据库的关联，而且每一种操作类型都能被够复用

Normal
0

7.8 磅
0
2

false
false
false

EN-US
ZH-CN
X-NONE

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:普通表格;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.5pt;
mso-bidi-font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-font-kerning:1.0pt;}

相关文章