# STDbObject

**Repository Path**: studio.ace/STDbObject

## Basic Information

- **Project Name**: STDbObject
- **Description**: 简单实用的object-c封装的sqlite类
- **Primary Language**: Unknown
- **License**: GPL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 46
- **Created**: 2013-12-04
- **Last Updated**: 2020-12-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#STDbObject

    对于小型数据很方便

2. 使用方法
   1) 引入STDbKit.framework
   2) 引入依赖库sqlite3.dylib
   3) 创建需要保存的数据类，该类需继承类STDbObject

3. 示例
   1) 声明一个类，这里新建类User
     #import <STDbKit/STDbObject.h>

	 @interface User : STDbObject

	 @property (strong, nonatomic) NSString *name;
	 @property (assign, nonatomic) NSInteger age;
	 @property (strong, nonatomic) NSNumber *sex;
	 @property (assign, nonatomic) NSTimeInterval time;
	 @property (assign, nonatomic) int _id;

	 @end
    
   2) 插入到数据库
      // 初始化
 	  User *defaultUser = [[User alloc] init];
       defaultUser.name = @"admin";
       defaultUser.age = 20;
       defaultUser.sex = @1;
       defaultUser._id = 0;
       // 插入到数据库
       [defaultUser insertToDb]; 
   3) 查询
      // 取出所有用户
      NSArray *users = [User allDbObjects];

	  // 按条件取出数据
      NSArray *users = [User dbObjectsWhere:@"_id=11" orderby:nil];

   4) 修改
       // 首先从数据库中取出要修改的对象
       NSArray *users = [User dbObjectsWhere:@"_id=11" orderby:nil];
       if ([users count] > 0) {
		   User *user = users[0];
           user.name = @"学长";
           // 更新到数据库
           [user updateToDbsWhere:@"_id=11"];
       }
   5) 删除
      // 要删除的数据
      User *user = _users[row];
      NSString *where = [NSString stringWithFormat:@"uid__=%d", user.uid__];
      // 从数据库中删除数据
      [User removeDbObjectsWhere:where];

注意：一旦修改了数据类，请删除原来的应用重新运行.