自己写了一个iphone应用
sqlite的DEMO;
if(sqlite3_open([[selfdatabasePath]UTF8String],&database) !=sqlITE_OK) {
@H_
301_37@
sqlite3_close(database);
@H_301_37@
NSAssert(0,@"open database faild!");
@H_301_37@
}
@H_301_37@
@H_301_37@
char*erroMsg;
@H_301_37@
NSString*createsql = [NSStringstringWithFormat:@"CREATE TABLE IF NOT EXISTS %@(ROW INTEGER PRIMARY KEY,NAME TEXT,AGE TEXT,SEX TEXT)"301_37@
sqlite3_exec(database,[createsqlNULL,&erroMsg) !=sqlITE_OK) {
@H_301_37@
sqlite3_close(database);
@H_301_37@
NSAssert1(0,@"create table %@ faild",TableName);
@H_301_37@
NSAssert1(@"the error is %s",erroMsg);
@H_301_37@
}
@H_301_37@
NSString*insertUser = [NSStringstringWithFormat:@"INSERT INTO %@(NAME,AGE,SEX) VALUES('%@','%@','%@')",TableName,new_user.name,new_user.age,new_user.sex];
@H_301_37@
NSLog(@"%@",insertUser);
@H_301_37@
sqlite3_exec(database,[insertUsersqlITE_OK)
@H_301_37@
{
@H_301_37@
NSAssert1(301_37@
}
@H_301_37@
User *user = [[Useralloc]init];
@H_301_37@
*countsql = [:@"SELECT ROW,NAME,SEX FROM UserTable WHERE ROW = %i"id];
@H_301_37@
sqlite3_stmt*statement;
@H_301_37@
sqlite3_prepare_v2(database,[countsql1,&statement,162);">nil) ==sqlITE_OK) {
@H_301_37@
@H_301_37@
@H_301_37@
while(sqlite3_step(statement)==sqlITE_ROW) {
@H_301_37@
@H_301_37@
@H_301_37@
user.= [stringWithFormat:@"%d"sqlite3_column_int(statement,0);">)];
@H_301_37@
@H_301_37@
@H_301_37@
name@"%s"sqlite3_column_text1 user.age =[2 user.sex = [3)];
@H_301_37@
}
@H_301_37@
sqlite3_finalize(statement);
@H_301_37@
returnuser;
}
希望对大家有用:sqliteDEMO