sqlite数据库

ios中通用的sqlite数据库的版本是sqlite3,它具有移植性强，可靠性高，小而容易使用等特点。在ios工程中如果需要使用sqlite数据库，那么需要添加库 sqlite3.dylib或者 sqlite3.0.dylib。

代码演示：

1、创建表：

-(void) createDB
{
NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask,YES) lastObject];
NSString *DBPath = [documentDirectory stringByAppendingString:@"DB"];
if(sqlite3_open([DBPath UTF8String],&_db) != SQLITE_OK)
{
sqlite3_close(_db);
NSLog(@"数据库打开失败");
}else{
char *err;
NSString *createSQL = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS STU (NO TEXT primary key,name TEXT)"];
if(sqlite3_exec(_db,[createSQL UTF8String],NULL,&err) != SQLITE_OK){
sqlite3_close(_db);
NSLog(@"创建表失败");
}else {
NSLog(@"创建表成功");
}
sqlite3_close(_db);
}
}

2、查询数据

-(Stu *) findByNo:(Stu *) model{
NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,&_db) != SQLITE_OK)
{
sqlite3_close(_db);
NSLog(@"数据可打开失败");
}else{
NSString *qsql = @"select no,name from STU where no = ?";
sqlite3_stmt *statement;
//预处理
if(sqlite3_prepare_v2(_db,[qsql UTF8String],-1,&statement,NULL) == SQLITE_OK){
//绑定参数
sqlite3_bind_text(statement,1,"123",NULL);
}
//开始查询
if(sqlite3_step(statement) == SQLITE_ROW){
char *no = (char *)sqlite3_column_text(statement,0);
NSString *stringNO = [[NSString alloc]initWithUTF8String:no];

char *name = (char *) sqlite3_column_text(statement,1);
NSString *stringName = [[NSString alloc] initWithUTF8String:name];

Stu *s = [[Stu alloc]init];
s.no = stringNO;
s.name = stringName;

sqlite3_finalize(statement);
return s;

}
}
return nil;
}

3、插入式数据

-(void) insertData{
NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,&_db) != SQLITE_OK){
sqlite3_close(_db);
NSLog(@"打开表失败");
}else{
NSString *insetString = @"insert into STU(no,name) values(?,?)";
sqlite3_stmt *statement;
if(sqlite3_prepare_v2(_db,[insetString UTF8String],NULL) == SQLITE_OK){
sqlite3_bind_text(statement,[@"123" UTF8String],NULL);
sqlite3_bind_text(statement,2,[@"xieguangqian" UTF8String],NULL);
if(sqlite3_step(statement) != SQLITE_OK){
NSLog(@"插入数据成功");
}else{
NSLog(@"插入数据失败");
}
sqlite3_close(_db);
}
}
}

4、删除数据

-(void)remove{
NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,YES) lastObject];
NSString *DBPath = [documentDirectory stringByAppendingString:@"DB"];

if(sqlite3_open([DBPath UTF8String],&_db) != SQLITE_OK){
sqlite3_close(_db);
NSLog(@"--remove---打开数据库失败");
}else {
NSString *sqlde = @"delete from STU where no = ?";
sqlite3_stmt *statement;
if(sqlite3_prepare_v2(_db,[sqlde UTF8String],NULL);
if(sqlite3_step(statement) == SQLITE_DONE){
NSLog(@"已删除");
}
}
sqlite3_close(_db);
}
}

5 、修改数据

-(void) modify{ NSString *documentDirectory = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,YES) lastObject]; NSString *DBPath = [documentDirectory stringByAppendingString:@"DB"]; if(sqlite3_open([DBPath UTF8String],&_db) != SQLITE_OK){ sqlite3_close(_db); NSLog(@"数据库打开失败"); }else { NSString *modifySql = @"update STU set name = ? where no = ?"; sqlite3_stmt *statement; if(sqlite3_prepare_v2(_db,[modifySql UTF8String],NULL) == SQLITE_OK){ sqlite3_bind_text(statement,[@"zhangsisi" UTF8String],NULL); sqlite3_bind_text(statement,NULL); if(sqlite3_step(statement) != SQLITE_DONE){ NSLog(@"修改失败"); } sqlite3_finalize(statement); sqlite3_close(_db); }else{ NSLog(@"12345"); } } }

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!