ios数据库

最新推荐文章于 2024-05-13 11:59:19 发布

张流程

最新推荐文章于 2024-05-13 11:59:19 发布

阅读量530

点赞数

CC 4.0 BY-SA版权

分类专栏： ios

本文链接：https://blog.youkuaiyun.com/xizhao88/article/details/21331293

ios 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一个用于操作SQLite数据库的Objective-C类库，包括创建、插入、查询和删除等基本操作，并提供了一个具体的使用示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

#import <Foundation/Foundation.h>
#import <sqlite3.h>

@interface SqliteManager : NSObject

+ (sqlite3 *)getSqlite;

+ (void)closeSqlite:(sqlite3 *)sqlite;

+ (NSString *)createSql:(NSString *)tableName params:(NSArray *)params;
+ (NSString *)insertSql:(NSString *)tableName params:(NSDictionary *)params;
+ (NSString *)fetchSql:(NSString *)tableName params:(NSDictionary *)params;
+ (NSString *)deleteSql:(NSString *)tableName params:(NSDictionary *)params;

+ (NSString *)stringFromChar:(const char*)val;

@end

#import "SqliteManager.h"

#define DATABASE_NAME @"JieLi.db"

@implementation SqliteManager

+ (sqlite3 *)getSqlite
{
    sqlite3 *database = nil;
    NSArray *paths =  NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
    NSString *documentDirectory = [paths objectAtIndex:0];
    NSString *path = [documentDirectory stringByAppendingPathComponent:DATABASE_NAME];

    sqlite3_open([path UTF8String], &database);
    return database;
}

+ (void)closeSqlite:(sqlite3 *)sqlite
{
    sqlite3_close(sqlite);
}

+ (NSString *)createSql:(NSString *)tableName params:(NSArray *)params
{    
    NSMutableString *sql = [[[NSMutableString alloc] init] autorelease];
    [sql appendFormat:@"create table if not exists %@ (id integer primary key autoincrement,", tableName];
    
    for (NSString *val in params) {
        [sql appendFormat:@" %@ text,", val];
    }
    
    [self deleteStringLastCode:sql];
    [sql appendString:@")"];
    return sql;
}

+ (NSString *)insertSql:(NSString *)tableName params:(NSDictionary *)params
{
    NSMutableString *sql = [[[NSMutableString alloc] init] autorelease];
    [sql appendFormat:@"insert into %@ (", tableName];
    
    for (NSString *val in [params allKeys]) {
        [sql appendFormat:@" %@,", val];
    }
    
    [self deleteStringLastCode:sql];
    [sql appendString:@") values ("];
    
    for (NSString *val in [params allKeys]) {
        [sql appendFormat:@"'%@',", [params objectForKey:val]];
    }
    
    [self deleteStringLastCode:sql];
    [sql appendString:@")"];
    return sql;
}

+ (NSString *)fetchSql:(NSString *)tableName params:(NSDictionary *)params
{
    NSMutableString *sql = [[[NSMutableString alloc] init] autorelease];
    [sql appendFormat:@"select * from %@ ", tableName];
    
    if (nil != params && [params count] > 0) {
        [sql appendString:@"where "];
        for (NSString *key in [params allKeys]) {
            [sql appendFormat:@"%@ = %@,", key, [params objectForKey:key]];
        }
        [self deleteStringLastCode:sql];
    }
    return sql;
}

+ (NSString *)deleteSql:(NSString *)tableName params:(NSDictionary *)params
{
    NSMutableString *sql = [[[NSMutableString alloc] init] autorelease];
    [sql appendFormat:@"delete from %@ ", tableName];
    
    if (nil != params && [params count] > 0) {
        [sql appendString:@"where "];
        for (NSString *key in [params allKeys]) {
            [sql appendFormat:@"%@ = %@,", key, [params objectForKey:key]];
        }
        [self deleteStringLastCode:sql];
    }
    return sql;
}

+ (NSString *)stringFromChar:(const char*)val
{
    if (val != NULL) {
        return [NSString stringWithUTF8String:val];
    }
    return nil;
}

+ (void)deleteStringLastCode:(NSMutableString *)val
{
    NSRange range = NSMakeRange([val length] - 1, 1);
    [val deleteCharactersInRange: range];
}

@end

用法

#define TABLE_NAME      @"book"
#define TABLE_COLUMN    @[@"bookId", @"thumb", @"author", @"publish", @"price", @"bookName", @"brief"]
NSString *createSql = [SqliteManager createSql:TABLE_NAME params:TABLE_COLUMN];		//获取创建数据库sql