在.h中
#import <Foundation/Foundation.h>
#import <sqlite3.h>
@interface DataBase : NSObject
-(void)craeteTable:(NSString *)sql;
//插入数据,修改数据,删除数据
//参数:sql:sql语句
//返回值,是否执行成功
-(BOOL)dealData:(NSString *)sql paramsarray:(NSArray *)parame;
/*
查询数据
参数: sql:SQL语句
返回值[“1”,“2”, “3”]
*/
-(NSMutableArray *)selectData:(NSString *)sql columns:(int)number;
.m
#import "DataBase.h"
#define kfileName @"data.sqlite"
@implementation DataBase
-(NSString *)filePath{
NSString *filePath = [NSHomeDirectory()stringByAppendingFormat:@"/Documents/%@",kfileName];
return filePath;
}
-(void)craeteTable:(NSString *)sql{
sqlite3 *sqlite =nil;
//打开数据库
if (sqlite3_open([self.filePathUTF8String], &sqlite) != SQLITE_OK) {
NSLog(@"打开数据库失败");
}
sqlite3_close(sqlite);
return;
//创建表
char *errmsg =nil;
if (sqlite3_exec(sqlite, [sqlUTF8String],nil,nil, &errmsg) !=SQLITE_OK) {
NSLog(@"创建表失败%s",errmsg);
}
sqlite3_close(sqlite);
}
-(<