# sqliteDemo

**Repository Path**: rang/sqliteDemo

## Basic Information

- **Project Name**: sqliteDemo
- **Description**: 基于FMDB编写的数据库处理
- **Primary Language**: Objective-C
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-03-29
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

基于FMDB库编写的统一数据库操作管理类:SQLDBManager

 **一.创建数据库** 

```
BOOL success = [[SQLDBManager shareInstance] createDBWithName:@"book.sqlite" sqlTables:@[book_table_sql,catalog_table_sql,chapter_table_sql]];
if(success){
  NSLog(@"创建db成功!");
}else{
  NSLog(@"创建db失败!");
}
```

 **二.新增数据** 

```
[self.dbService addBookName:@"蛮慌纪" author:@"我吃西红柿"];
```

 **三.修改数据** 

```
Book *book = [[Book alloc] init];
book.bId = 1;
book.status = BookStatusCatalog;
book.mtime = [NSDate date];
    
[self.dbService Update:book];
```

 **四.查询数据** 

```
Book *book = [self.dbService Entity:[NSNumber numberWithInteger:1]];
if (book) {
   NSLog(@"书籍名称：%@",book.name);
}else{
   NSLog(@"查询不存在!");
}
```