ios - fmdb对象存储

//
//  TYDataBase.h
//  wrxs523
//
//  Created by wbb on 2023/5/29.
//

#import <Foundation/Foundation.h>
#import "TYUserInfo.h"
NS_ASSUME_NONNULL_BEGIN

@interface TYDataBase : NSObject
+(instancetype)shareInstance;

//创建照片标准表
-(void)createStandardsDatabase;
//增
-(BOOL)addPhotoModel:(TYUserInfo *)photoModel;
//删
-(void)deletePhotoModel:(TYUserInfo *)photoModel;
- (void)deleteAll;
- (void)deletetable;
//改
-(void)updatePhotoModel:(TYUserInfo *)photoModel;
//查
-(TYUserInfo *)getPhotoModel:(TYUserInfo *)photoModel;
-(TYUserInfo *)getPhotoModelWithEmail:(NSString *)email;
- (UIImage *)queryImageWithId:(NSString *)email;
@end

NS_ASSUME_NONNULL_END

//
//  TYDataBase.m
//  wrxs523
//
//  Created by wbb on 2023/5/29.
//

#import "TYDataBase.h"
#import "FMDB.h"

@interface TYDataBase ()

@property(nonatomic, strong) NSString *dataBasePath;
@property(nonatomic, strong) FMDatabase *standardDatabase;
@end

@implementation TYDataBase
+(instancetype)shareInstance
{
    static dispatch_once_t onceToken;
    static TYDataBase * standardDatabase = nil;
    dispatch_once(&onceToken, ^{
    
        standardDatabase = [[TYDataBase alloc]init];
    
        [standardDatabase createStandardsDatabase];
    
    });

    return standardDatabase;

}

//数据库地址
-(NSString *)dataBasePath{

    if (_dataBasePath == nil) {
    
        NSString *pathes = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)[0];
//        NSString * pathes = @"/Users/gonganxinxi/Desktop";

        _dataBasePath = [pathes stringByAppendingPathComponent:@"my.sqlite"];
    
    }

    return _dataBasePath;

}

//创建照片标准表
-(void)createStandardsDatabase
{
    self.standardDatabase = [FMDatabase databaseWithPath:self.dataBasePath];

    if ([self.standardDatabase open]) {
    
        NSLog(@"数据库打开成功");
    
        NSString *sqString = @"create table if not exists standard (s_id integer primary key autoincrement not NULL, s_clcsEmail text,s_clcsPassword text,s_clcsNickname text,s_clcsGender text,s_clcsAge text, s_clcsData blob,s_clcxUserInfo blob)";
    
    
        BOOL result = [self.standardDatabase executeUpdate:sqString];
    
        if (result) {
        
            NSLog(@"创建表成功");
        
        }else{
            NSLog(@"创建表失败");
        
        }
    
    }

}

//增
-(BOOL)addPhotoModel:(TYUserInfo *)photoModel
{

//    TYUserInfo * model = photoModel;

//    NSLog(@"数据库%ld, %@, %@, %@, %@, %@, %@", (long)model.ID, model.CSM, model.CSZ, model.CSSM, model.ZPLX,model.DQDM,model.SFYX);
    if ([self isExistDataWithContent:photoModel.email]) {
        [self updatePhotoModel:photoModel];
        return NO;
    }
    
    NSData *data = [NSKeyedArchiver archivedDataWithRootObject:photoModel];

    BOOL result = [self.standardDatabase executeUpdateWithFormat:@"insert into standard (s_clcsEmail, s_clcsPassword, s_clcsNickname, s_clcsGender , s_clcsAge,s_clcsData, s_clcxUserInfo) values (%@, %@, %@, %@, %@,%@, %@)", photoModel.email, photoModel.password, photoModel.nickname, photoModel.gender, photoModel.age,photoModel.imageData,data];


    if (result) {
        NSLog(@"插入数据成功");
    }else{
        NSLog(@"插入数据失败");
    
    }
    return result;
}
//删

-(void)deletePhotoModel:(TYUserInfo *)photoModel
{
    TYUserInfo * model = photoModel;

    BOOL result = [self.standardDatabase executeUpdateWithFormat:@"delete from standard where s_clcsEmail = %@ and s_clcsPassword = %@ ",  photoModel.email,photoModel.password];

    if (result) {
        NSLog(@"删除数据成功");
    }else{
        NSLog(@"删除数据失败");
    }
}

- (void)deleteAll
{
    BOOL result = [self.standardDatabase executeUpdateWithFormat:@"delete from standard"];

    if (result) {
        NSLog(@"删除全部数据成功");
    }else{
        NSLog(@"删除全部数据失败");
    }
}

- (void)deletetable
{
    BOOL result = [self.standardDatabase executeUpdateWithFormat:@"drop table if exists standard"];
    
    if (result) {
        NSLog(@"删除表成功");
    }else{
        NSLog(@"删除表失败");
    }
}

//改
-(void)updatePhotoModel:(TYUserInfo *)photoModel
{
    NSData *data = [NSKeyedArchiver archivedDataWithRootObject:photoModel];

    BOOL result = [self.standardDatabase executeUpdateWithFormat:@"update standard set s_clcsEmail = %@,s_clcsPassword = %@, s_clcsNickname  = %@,s_clcsGender  = %@,s_clcsAge  = %@,s_clcsData  = %@,s_clcxUserInfo = %@ where s_clcsEmail = %@", photoModel.email, photoModel.password, photoModel.nickname, photoModel.gender, photoModel.age,photoModel.imageData,data,photoModel.email];
     
    if (result) {
        NSLog(@"更改数据成功");
    }else{
        NSLog(@"更改数据失败");
    }

}

//查 : 根据需要，查到响应的model返回，我们可以从中获取model的属性值
-(TYUserInfo *)getPhotoModel:(TYUserInfo *)photoModel
{
    TYUserInfo * returnModel = nil;

    FMResultSet *result = [self.standardDatabase executeQueryWithFormat:@"select s_clcxUserInfo from standard where s_clcsEmail = %@ ", photoModel.email];

    while ([result next]) {
    
        NSData *data = [result dataForColumn:@"s_clcxUserInfo"];
    
        returnModel = [NSKeyedUnarchiver unarchiveObjectWithData:data];
           
    }
    
    return returnModel;
}
-(TYUserInfo *)getPhotoModelWithEmail:(NSString *)email
{
    TYUserInfo * returnModel = nil;

    FMResultSet *result = [self.standardDatabase executeQueryWithFormat:@"select s_clcxUserInfo from standard where s_clcsEmail = %@ ", email];

    while ([result next]) {
    
        NSData *data = [result dataForColumn:@"s_clcxUserInfo"];
    
        returnModel = [NSKeyedUnarchiver unarchiveObjectWithData:data];
           
    }
    
    return returnModel;
}
    // 判断数据库中是否已经存在该数据
- (BOOL)isExistDataWithContent:(NSString *)email {
    FMResultSet *set = [self.standardDatabase executeQuery:@"SELECT * FROM standard WHERE s_clcsEmail = ?",email];
    return [set next];
}

// 存储图片
- (BOOL)insertImage:(UIImage *)image withEmail:(NSString *)email {
    NSData *imageData = UIImagePNGRepresentation(image);
    BOOL success = [self.standardDatabase executeUpdate:@"INSERT INTO standard (s_clcsData) VALUES (?) where s_clcsEmail = ?", imageData,email];
    return success;
}

// 查询图片
- (UIImage *)queryImageWithId:(NSString *)email {
    FMResultSet *resultSet = [self.standardDatabase executeQuery:@"SELECT * FROM standard WHERE s_clcsEmail = ?", email];
    UIImage *image = nil;
    if ([resultSet next]) {
        NSData *imageData = [resultSet dataForColumn:@"s_clcsData"];
        image = [UIImage imageWithData:imageData];
    }
    return image;
}
@end

//
//  TYUserInfo.h
//  wrxs523
//
//  Created by wbb on 2023/5/25.
//

#import <Foundation/Foundation.h>

NS_ASSUME_NONNULL_BEGIN

@interface TYUserInfo : NSObject


@property (nonatomic, copy) NSString * email;
@property (nonatomic, copy) NSString * password;
@property (nonatomic, copy) NSString * nickname;
@property (nonatomic, copy) NSString * gender;
@property (nonatomic, copy) NSString * age;
@property (nonatomic, strong) NSData * imageData;
@end

NS_ASSUME_NONNULL_END

#import "TYUserInfo.h"
#import "MJExtension.h"
@implementation TYUserInfo
//一句话将所有的子文件全部归档反归档(MJExtension)
MJCodingImplementation
@end