iphone - making map coordinates(lan,& long)storing in sqlite database -

-

how created application records series of longitude , latitude values in sqlite database , display them coloured track on mapactivity.

i need help. how can store map coordinates in sqlite database , display journey details in table .for example have done 1 journey mumbai pune .then how can store data database can available future reference .when user click on journey name should give details

if new sqlite class data base create 2 database file following

---->>>> database.h

write following code in file

#import <foundation/foundation.h> #import <sqlite3.h>   @interface database : nsobject {      sqlite3 *database;  }  +(database *) sharedatabase;  -(bool) createdatabase:(nsstring *)databasename;  -(nsstring*) getdatabasepath:(nsstring *)database;  -(nsmutablearray *) getalldataforquery:(nsstring *)sql  fordatabase:(nsstring *)database; -(void) inseryquery:(nsstring *) insertsql fordatabase:(nsstring *)database1; -(void) deletequery:(nsstring *) deletesql fordatabase:(nsstring *)database1; -(void) updatequery:(nsstring *) updatesql fordatabase:(nsstring *)database1;  @end

---->>>> database.m

write following code in file

#import "database.h"   @implementation database  static database *sampledatabase =nil;   +(database*) sharedatabase{      if(!sampledatabase){         sampledatabase = [[database alloc] init];     }      return sampledatabase;  }   -(nsstring *) getdatabasepath:(nsstring *)database1{       [self createdatabase:database1];      nsarray *paths = nssearchpathfordirectoriesindomains(nsdocumentdirectory, nsuserdomainmask, yes);     nsstring *documentsdirectory = [paths objectatindex:0];     return [documentsdirectory stringbyappendingpathcomponent:database1]; }   -(bool) createdatabase:(nsstring *)databasename{     bool success;       nsfilemanager *filemanager = [nsfilemanager defaultmanager];     nserror *error;     nsarray *paths = nssearchpathfordirectoriesindomains(nsdocumentdirectory, nsuserdomainmask, yes);     nsstring *documentsdirectory = [paths objectatindex:0];     nsstring *writabledbpath = [documentsdirectory stringbyappendingpathcomponent:databasename];      success = [filemanager fileexistsatpath:writabledbpath];     if (success) return success;     nsstring *defaultdbpath = [[[nsbundle mainbundle] resourcepath] stringbyappendingpathcomponent:databasename];     success = [filemanager copyitematpath:defaultdbpath topath:writabledbpath error:&error];      if (!success) {         uialertview *alert = [[uialertview alloc] initwithtitle:@"error!!!" message:@"failed create writable database" delegate:self cancelbuttontitle:@"cancel" otherbuttontitles:nil];         [alert show];         [alert release];      }     return success; }    -(nsmutablearray *) getalldataforquery:(nsstring *)sql  fordatabase:(nsstring *)database1{      sqlite3_stmt *statement = nil ;      nsstring *path = [self getdatabasepath:database1];      nsmutablearray *alldata;     alldata = [[nsmutablearray alloc] init];      if(sqlite3_open([path utf8string],&database) == sqlite_ok )     {         nsstring *query = sql;          if((sqlite3_prepare_v2(database,[query utf8string],-1, &statement, null)) == sqlite_ok)         {             while(sqlite3_step(statement) == sqlite_row)             {                     nsmutabledictionary *currentrow = [[nsmutabledictionary alloc] init];                  int count = sqlite3_column_count(statement);                  (int i=0; < count; i++) {                      char *name = (char*) sqlite3_column_name(statement, i);                     char *data = (char*) sqlite3_column_text(statement, i);                      nsstring *columndata;                     nsstring *columnname = [nsstring stringwithcstring:name encoding:nsutf8stringencoding];                       if(data != nil)                         columndata = [nsstring stringwithcstring:data encoding:nsutf8stringencoding];                     else {                         columndata = @"";                     }                      [currentrow setobject:columndata forkey:columnname];                 }                  [alldata addobject:currentrow];             }         }         sqlite3_finalize(statement);      }     sqlite3_close(database);      return alldata;  }  -(void) inseryquery:(nsstring *) insertsql fordatabase:(nsstring *)database1{      sqlite3_stmt *statement = nil ;      nsstring *path = [self getdatabasepath:database1];      if(sqlite3_open([path utf8string],&database) == sqlite_ok )     {         if((sqlite3_prepare_v2(database,[insertsql utf8string],-1, &statement, null)) == sqlite_ok)         {             if(sqlite3_step(statement) == sqlite_ok){             }         }         sqlite3_finalize(statement);      }     sqlite3_close(database);  }  -(void) updatequery:(nsstring *) updatesql fordatabase:(nsstring *)database1{      sqlite3_stmt *statement = nil ;      nsstring *path = [self getdatabasepath:database1];      if(sqlite3_open([path utf8string],&database) == sqlite_ok )     {         if((sqlite3_prepare_v2(database,[updatesql utf8string],-1, &statement, null)) == sqlite_ok)         {             if(sqlite3_step(statement) == sqlite_ok){             }         }         sqlite3_finalize(statement);      }     sqlite3_close(database);  }  -(void) deletequery:(nsstring *) deletesql fordatabase:(nsstring *)database1{      sqlite3_stmt *statement = nil ;      nsstring *path = [self getdatabasepath:database1];      if(sqlite3_open([path utf8string],&database) == sqlite_ok )     {         if((sqlite3_prepare_v2(database,[deletesql utf8string],-1, &statement, null)) == sqlite_ok)         {             if(sqlite3_step(statement) == sqlite_ok){             }         }         sqlite3_finalize(statement);      }     sqlite3_close(database);  }    @end

now data use following code

nsstring *sql = @"select * userinfo"; <br> userinfo = [[database sharedatabase] getalldataforquery:sql fordatabase:@"sample.db"];

it return array of row in form of nsdictionary.

to add new record use following code

nsstring *sql = [nsstring stringwithformat:@"insert userinfo values ('city','name','phone')"]; [[database sharedatabase] inseryquery:sql fordatabase:@"sample.db"];

in same way there method update , delete record.

so best example have seen need call 1 method fetch, insert , update or delete.

thanks seeing question,


Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more