足球游戏_中国足彩网¥体育资讯$

iphone mysql数据库操作代码例子
来源:易贤网 阅读:763 次 日期:2015-02-02 13:50:30
温馨提示:易贤网小编为您整理了“iphone mysql数据库操作代码例子”,方便广大网友查阅!

//database operation

打开数据库

-(bool) opendatabase{

nsarray*paths = nssearchpathfordirectoriesindomains(nsdocumentdirectory, nsuserdomainmask,yes);

nsstring *documentsdirectory = [pathsobjectatindex:0];

nsstring *path = [documentsdirectorystringbyappendingpathcomponent:@mydb.sql];

nsfilemanager*filemanager = [nsfilemanagerdefaultmanager];

bool find = [filemanagerfileexistsatpath:path];

//找到数据库文件mydb.sql

if (find) {

nslog(@database file have already existed.);

if(sqlite3_open([pathutf8string], &database_) !=sqlite_ok) {

sqlite3_close(database_);

nslog(@error: open database file.);

return no;

}

return yes;

}

if(sqlite3_open([path utf8string], &database_) ==sqlite_ok) {

//bfirstcreate_ = yes;

[selfcreatechannelstable:database_];//在后面实现函数createchannelstable

return yes;

}else {

sqlite3_close(database_);

nslog(@error: open database file.);

return no;

}

return no;

}

创建表

- (bool) createchannelstable:(sqlite3*)db{

char*sql = create table reports (id integer primary key,stime text,stitle text,scal text,sruntime text);

sqlite3_stmt *statement;

if(sqlite3_prepare_v2(db, sql, -1, &statement,nil) !=sqlite_ok) {

nslog(@error: failed to prepare statement:create reports table);

return no;

}

int success =sqlite3_step(statement);

sqlite3_finalize(statement);

if ( success !=sqlite_done) {

nslog(@error: failed to dehydrate:create table reports);

return no;

}

nslog(@create table 'reports' successed.);

return yes;

}

插入表

- (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.);

}

//查询结果集中一条一条的遍历所有的记录,这里的数字对应的是列值。

while (sqlite3_step(statement) ==sqlite_row) {

//char* cid = (char*)sqlite3_column_text(statement, 1);

char* stime = (char*)sqlite3_column_text(statement,1);

char* stitle =(char*)sqlite3_column_text(statement,2);

char* scal = (char*)sqlite3_column_text(statement,3);

char* sruntime= (char*)sqlite3_column_text(statement,4);

//nsstring *tmp = [nsstring stringwithcstring:stitle encoding:1];

myreportitem* ri = [[myreportitemalloc]init];

ri.mytime= [nsstring stringwithcstring:stime encoding:1];

中国足彩网信息请查看IT技术专栏

中国足彩网信息请查看技术文章
易贤网手机网站地址:iphone mysql数据库操作代码例子
由于各方面情况的不断调整与变化,易贤网提供的所有考试信息和咨询回复仅供参考,敬请考生以权威部门公布的正式信息和咨询为准!
关于我们 | 联系我们 | 人才招聘 | 网站声明 | 网站帮助 | 非正式的简要咨询 | 简要咨询须知 | 加入群交流 | 手机站点 | 投诉建议
工业和信息化部备案号:滇ICP备2023014141号-1 足球游戏_中国足彩网¥体育资讯$ 滇公网安备53010202001879号 人力资源服务许可证:(云)人服证字(2023)第0102001523号
云南网警备案专用图标
联系电话:0871-65317125(9:00—18:00) 获取招聘考试信息及咨询关注公众号:hfpxwx
咨询QQ:526150442(9:00—18:00)版权所有:易贤网
云南网警报警专用图标