if (sqlite3_open([[self databasePath] UTF8String],&database) != SQLITE_OK) {
sqlite3_close(database);
NSAssert(0,@"open database faild!");
}
char *erroMsg;
NSString *createSQL = [NSString stringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(ROW INTEGER PRIMARY KEY,NAME TEXT,AGE TEXT,SEX TEXT)",TableName];
if (sqlite3_exec(database, [createSQL UTF8String], NULL, NULL, &erroMsg) != SQLITE_OK) {
sqlite3_close(database);
NSAssert1(0,@"create table %@ faild",TableName);
NSAssert1(0,@"the error is %s",erroMsg);
}
NSString *insertUser = [NSString stringWithFormat:@"INSERT INTO %@(NAME,AGE,SEX) VALUES('%@','%@','%@')",TableName,new_user.name,new_user.age,new_user.sex];
NSLog(@"%@",insertUser);
if (sqlite3_exec (database, [insertUser UTF8String], NULL, NULL, &erroMsg) != SQLITE_OK)
{
NSAssert1(0, @"Error updating tables: %s", erroMsg);
}
User *user = [[User alloc] init];
NSString *countSQL = [NSString stringWithFormat:@"SELECT ROW,NAME,AGE,SEX FROM UserTable WHERE ROW = %i",id];
sqlite3_stmt *statement;
if (sqlite3_prepare_v2(database, [countSQL UTF8String], -1, &statement, nil) == SQLITE_OK) {
while (sqlite3_step(statement)==SQLITE_ROW) {
user.id = [NSString stringWithFormat:@"%d",sqlite3_column_int(statement,0)];
user.name = [NSString stringWithFormat:@"%s",sqlite3_column_text(statement,1)];
user.age =[NSString stringWithFormat:@"%s",sqlite3_column_text(statement,2)];
user.sex = [NSString stringWithFormat:@"%s",sqlite3_column_text(statement,3)];
}
sqlite3_finalize(statement);
return user;
}
希望对大家有用:SQLiteDEMO