iphone mysql數(shù)據(jù)庫操作代碼例子
來源:易賢網(wǎng) 閱讀:730 次 日期:2015-02-02 13:50:30
溫馨提示:易賢網(wǎng)小編為您整理了“iphone mysql數(shù)據(jù)庫操作代碼例子”,方便廣大網(wǎng)友查閱!

//database operation

打開數(shù)據(jù)庫

-(bool) opendatabase{

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

nsstring *documentsdirectory = [pathsobjectatindex:0];

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

nsfilemanager*filemanager = [nsfilemanagerdefaultmanager];

bool find = [filemanagerfileexistsatpath:path];

//找到數(shù)據(jù)庫文件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_];//在后面實現(xiàn)函數(shù)createchannelstable

return yes;

}else {

sqlite3_close(database_);

nslog(@error: open database file.);

return no;

}

return no;

}

創(chuàng)建表

- (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,?,?,?,?);

//問號的個數(shù)要和(cid,title,imagedata,imagelen)里面字段的個數(shù)匹配,代表未知的值,將在下面將值和字段關(guān) 聯(lián)。

int success =sqlite3_prepare_v2(database_, sql, -1, &statement,null);

if (success !=sqlite_ok) {

nslog(@error: failed to insert:channels);

return no;

}

//這里的數(shù)字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.);

}

//查詢結(jié)果集中一條一條的遍歷所有的記錄,這里的數(shù)字對應(yīng)的是列值。

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技術(shù)專欄

更多信息請查看技術(shù)文章
易賢網(wǎng)手機網(wǎng)站地址:iphone mysql數(shù)據(jù)庫操作代碼例子
由于各方面情況的不斷調(diào)整與變化,易賢網(wǎng)提供的所有考試信息和咨詢回復(fù)僅供參考,敬請考生以權(quán)威部門公布的正式信息和咨詢?yōu)闇?zhǔn)!
關(guān)于我們 | 聯(lián)系我們 | 人才招聘 | 網(wǎng)站聲明 | 網(wǎng)站幫助 | 非正式的簡要咨詢 | 簡要咨詢須知 | 加入群交流 | 手機站點 | 投訴建議
工業(yè)和信息化部備案號:滇ICP備2023014141號-1 云南省教育廳備案號:云教ICP備0901021 滇公網(wǎng)安備53010202001879號 人力資源服務(wù)許可證:(云)人服證字(2023)第0102001523號
云南網(wǎng)警備案專用圖標(biāo)
聯(lián)系電話:0871-65317125(9:00—18:00) 獲取招聘考試信息及咨詢關(guān)注公眾號:hfpxwx
咨詢QQ:526150442(9:00—18:00)版權(quán)所有:易賢網(wǎng)
云南網(wǎng)警報警專用圖標(biāo)