iOS 使用FMDB进行数据库操作

曾经终败给现在 2022-08-25 14:58 197阅读 0赞

# iOS 使用FMDB进行数据库操作 #

1、首先要先导入第三方类库FMdatabase。

2、获得存放数据库文件的沙盒地址。

[View Row Code][]

3、创建数据库的操作

[View Row Code][]

4、创建表

[View Row Code][]

5、增加表数据

[View Row Code][]

<table style="margin:0px!important; padding:0px!important; border:1px solid rgb(170,170,170); font-family:Menlo,Monaco,Consolas,monospace; line-height:1.5em; border-collapse:collapse; background-color:rgb(240,240,240); width:603px"> 
 <tbody> 
 <tr> 
 <td style="">1</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> +(void)insertPeople:(People *)aPeople</td> 
 </tr> 
 <tr> 
 <td style="">2</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> { </td> 
 </tr> 
 <tr> 
 <td style="">3</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> if (!db) { </td> 
 </tr> 
 <tr> 
 <td style="">4</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> [selfcreatDatabase];</td> 
 </tr> 
 <tr> 
 <td style="">5</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> }</td> 
 </tr> 
 <tr> 
 <td style="">6</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> </td> 
 </tr> 
 <tr> 
 <td style="">7</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> if (![db open]) { </td> 
 </tr> 
 <tr> 
 <td style="">8</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> NSLog(@"数据库打开失败");</td> 
 </tr> 
 <tr> 
 <td style="">9</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> return;</td> 
 </tr> 
 <tr> 
 <td style="">10</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> }</td> 
 </tr> 
 <tr> 
 <td style="">11</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> </td> 
 </tr> 
 <tr> 
 <td style="">12</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> [dbsetShouldCacheStatements:YES];</td> 
 </tr> 
 <tr> 
 <td style="">13</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> </td> 
 </tr> 
 <tr> 
 <td style="">14</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> if(![dbtableExists:@"people"])</td> 
 </tr> 
 <tr> 
 <td style="">15</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> { </td> 
 </tr> 
 <tr> 
 <td style="">16</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> [selfcreatTable];</td> 
 </tr> 
 <tr> 
 <td style="">17</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> }</td> 
 </tr> 
 <tr> 
 <td style="">18</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> //以上操作与创建表是做的判断逻辑相同</td> 
 </tr> 
 <tr> 
 <td style="">19</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> //现在表中查询有没有相同的元素，如果有，做修改操作 </td> 
 </tr> 
 <tr> 
 <td style="">20</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> FMResultSet *rs = [dbexecuteQuery:@"select * from people where people_id = ?",[NSStringstringWithFormat:@"%d",aPeople.peopleID]];</td> 
 </tr> 
 <tr> 
 <td style="">21</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> if([rs next]) </td> 
 </tr> 
 <tr> 
 <td style="">22</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> { </td> 
 </tr> 
 <tr> 
 <td style="">23</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> NSLog(@"dddddslsdkien");</td> 
 </tr> 
 <tr> 
 <td style="">24</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> [dbexecuteUpdate:@"update people set name = ?, age = ? where people_id = 1",aPeople.name,[NSStringstringWithFormat:@"%d",aPeople.age]];</td> 
 </tr> 
 <tr> 
 <td style="">25</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> }</td> 
 </tr> 
 <tr> 
 <td style="">26</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> //向数据库中插入一条数据 </td> 
 </tr> 
 <tr> 
 <td style="">27</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> else{ </td> 
 </tr> 
 <tr> 
 <td style="">28</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> [dbexecuteUpdate:@"INSERT INTO people (name, age) VALUES (?,?)",aPeople.name,[NSStringstringWithFormat:@"%d",aPeople.age]];</td> 
 </tr> 
 <tr> 
 <td style="">29</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> } </td> 
 </tr> 
 <tr> 
 <td style="">30</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> </td> 
 </tr> 
 <tr> 
 <td style="">31</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> }</td> 
 </tr> 
 </tbody> 
</table>

6、删除数据

[View Row Code][]

7、修改操作与增加操作的步骤一致

8、查询

[View Row Code][]

<table style="margin:0px!important; padding:0px!important; border:1px solid rgb(170,170,170); font-family:Menlo,Monaco,Consolas,monospace; line-height:1.5em; border-collapse:collapse; background-color:rgb(240,240,240); width:603px"> 
 <tbody> 
 <tr> 
 <td style="">1</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> +(NSArray *)getAllPeople</td> 
 </tr> 
 <tr> 
 <td style="">2</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> { </td> 
 </tr> 
 <tr> 
 <td style="">3</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> </td> 
 </tr> 
 <tr> 
 <td style="">4</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> if (!db) { </td> 
 </tr> 
 <tr> 
 <td style="">5</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> [selfcreatDatabase];</td> 
 </tr> 
 <tr> 
 <td style="">6</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> }</td> 
 </tr> 
 <tr> 
 <td style="">7</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> </td> 
 </tr> 
 <tr> 
 <td style="">8</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> if (![db open]) { </td> 
 </tr> 
 <tr> 
 <td style="">9</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> NSLog(@"数据库打开失败");</td> 
 </tr> 
 <tr> 
 <td style="">10</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> return nil;</td> 
 </tr> 
 <tr> 
 <td style="">11</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> }</td> 
 </tr> 
 <tr> 
 <td style="">12</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> </td> 
 </tr> 
 <tr> 
 <td style="">13</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> [dbsetShouldCacheStatements:YES];</td> 
 </tr> 
 <tr> 
 <td style="">14</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> </td> 
 </tr> 
 <tr> 
 <td style="">15</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> if(![dbtableExists:@"people"])</td> 
 </tr> 
 <tr> 
 <td style="">16</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> { </td> 
 </tr> 
 <tr> 
 <td style="">17</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> return nil;</td> 
 </tr> 
 <tr> 
 <td style="">18</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> }</td> 
 </tr> 
 <tr> 
 <td style="">19</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> </td> 
 </tr> 
 <tr> 
 <td style="">20</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> //定义一个可变数组，用来存放查询的结果，返回给调用者 </td> 
 </tr> 
 <tr> 
 <td style="">21</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> NSMutableArray *peopleArray = [[NSMutableArrayalloc] initWithArray:0];</td> 
 </tr> 
 <tr> 
 <td style="">22</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> //定义一个结果集，存放查询的数据</td> 
 </tr> 
 <tr> 
 <td style="">23</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> FMResultSet *rs = [dbexecuteQuery:@"select * from people"];</td> 
 </tr> 
 <tr> 
 <td style="">24</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> //判断结果集中是否有数据，如果有则取出数据</td> 
 </tr> 
 <tr> 
 <td style="">25</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> while ([rs next]) { </td> 
 </tr> 
 <tr> 
 <td style="">26</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> People *aPeople = [[People alloc] init];</td> 
 </tr> 
 <tr> 
 <td style="">27</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> </td> 
 </tr> 
 <tr> 
 <td style="">28</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> aPeople.peopleID = [rs intForColumn:@"people_id"];</td> 
 </tr> 
 <tr> 
 <td style="">29</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> aPeople.name = [rs stringForColumn:@"name"];</td> 
 </tr> 
 <tr> 
 <td style="">30</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> aPeople.age = [rs intForColumn:@"age"];</td> 
 </tr> 
 <tr> 
 <td style="">31</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> //将查询到的数据放入数组中。 </td> 
 </tr> 
 <tr> 
 <td style="">32</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> [peopleArray addObject:aPeople];</td> 
 </tr> 
 <tr> 
 <td style="">33</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> }</td> 
 </tr> 
 <tr> 
 <td style="">34</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word"> return [peopleArray autorelease];</td> 
 </tr> 
 <tr> 
 <td style="">35</td> 
 <td style="margin:0px; padding:0px 0.4em; border:0px; border-collapse:collapse; color:rgb(51,51,51); white-space:pre-wrap; word-wrap:break-word; background-color:rgb(245,245,245)"> }</td> 
 </tr> 
 </tbody> 
</table>

[View Row Code]: http://mobile.9sssd.com/ios/art/1050#