User.h文件
#import <Foundation/Foundation.h>
@interface User : NSObject
@property (nonatomic, copy) NSString *username;
@property (nonatomic, copy) NSString *password;
@property (nonatomic, assign) NSUInteger age;
@end
DataBaseManager.h文件
#import <Foundation/Foundation.h>
#import "User.h"
@interface DataBaseManager : NSObject
+ (instancetype)shareManager;
- (BOOL)addUser:(User *)user;
- (BOOL)updateUser:(User *)user;
- (BOOL)deleteUser:(User *)user;
- (User *)searchUser:(NSString *)username;
- (NSArray *)searchuserFromAge:(NSUInteger)fAge toAge:(NSUInteger)tAge;
- (NSArray *)allUsers;
- (BOOL)logInWithUsername:(NSString *)username Password:(NSString *)password;
- (NSUInteger)userCount;
@end
DataBaseManager.h.m文件
#import "DataBaseManager.h"
#import <sqlite3.h>
#define kDataBaseFilePath [NSHomeDirectory() stringByAppendingPathComponent:@"Documents/User.sqlite"]
单例实现
+ (instancetype)shareManager