IPhone MySQL数据库操作代码例子
2010-10-21 01:38:52 来源:WEB开发网}
插入表
- (BOOL)insertOneChannel:(NSString*)stime mytitle:(NSString*)stitle mycal:(NSString*)scal myruntime:(NSString*)sruntime
{
sqlite3_stmt *statement;
staticchar*sql = "INSERT INTO reports (id,stime,stitle,scal,sruntime) VALUES(NULL,?,?,?,?)";
//问号的个数要和(cid,title,imageData,imageLen)里面字段的个数匹配,代表未知的值,将在下面将值和字段关 联。
int success =sqlite3_prepare_v2(database_, sql, -1, &statement,NULL);
if (success !=SQLITE_OK) {
NSLog(@"Error: failed to insert:channels");
return NO;
}
//这里的数字1,2,3,4代表第几个问号
//sqlite3_bind_text(statement, 1, stime, -1, SQLITE_TRANSIENT);
char*p = [stime cStringUsingEncoding:1];
sqlite3_bind_text(statement,1, [stime cStringUsingEncoding:1], -1,SQLITE_TRANSIENT);
sqlite3_bind_text(statement,2, [stitle cStringUsingEncoding:1], -1,SQLITE_TRANSIENT);
sqlite3_bind_text(statement,3, [scal cStringUsingEncoding:1], -1,SQLITE_TRANSIENT);
sqlite3_bind_text(statement,4, [sruntime cStringUsingEncoding:1], -1,SQLITE_TRANSIENT);
success =sqlite3_step(statement);
sqlite3_finalize(statement);
if (success ==SQLITE_ERROR) {
NSLog(@"Error: failed to insert into the database with message.");
return NO;
}
NSLog(@"Insert One Channel#############:id = _");
return YES;
}
查询表
- (void) getChannels:(NSMutableArray*)fChannels{
sqlite3_stmt *statement =nil;
char*sql = "SELECT * FROM reports";
if (sqlite3_prepare_v2(database_, sql, -1, &statement,NULL) !=SQLITE_OK) {
NSLog(@"Error: failed to prepare statement with message:get channels.");
}
//查询结果集中一条一条的遍历所有的记录,这里的数字对应的是列值。
更多精彩
赞助商链接