//value change
//
select *from table_name insert into table_name values (‘Mark’,’Za’,”,’ld’,’9111111111′) DELETE FROM table_name WHERE fname=’kaushik’
page88image11872.png ¬ page88image12480.png ¬ page88image13088.png ¬page88image13696.png ¬
// WHERE fname=’kaushik’
UPDATE table_name set fname=’info’, lname=’soft’ ,standard=’pvt.ltd.’
// select *from table_name where fname=’kaushik’
-(void)checkdatafilepathandcopyfilepath:(NSString *)strfilepath filename:(NSString *)strfilename fileextentn:(NSString *)strfileextentn;
{
NSString *strdatapath=[NSHomeDirectory() stringByAppendingPathComponent:strfilepath];
NSLog(@”%@”,strdatapath); /*
if ([[NSFileManager defaultManager]fileExistsAtPath:strdatapath]) {
NSError *error;
[[NSFileManager defaultManager]removeItemAtPath:strdatapath error:&error];
}
*/ if (![[NSFileManager defaultManager]fileExistsAtPath:strdatapath]) {
NSString *strbndlpath=[[NSBundle mainBundle]pathForResource:strfilename ofType:strfileextentn];
NSError *error;
[[NSFileManager defaultManager]copyItemAtPath:strbndlpath toPath:strdatapath error:&error];
NSLog(@”sucessful copy %@”,error); }
}
-(NSMutableArray *)readsqlfiledatafilepath:(NSString *)strfilepath query:(NSString *)strquery;
{
NSString *strdatapath=[NSHomeDirectory() stringByAppendingPathComponent:strfilepath];
if (sqlite3_open([strdatapath UTF8String], &database)==SQLITE_OK) {
NSLog(@”database open”); // select *from table_name
NSString *strqry=strquery;
NSMutableArray *arr=[[NSMutableArray alloc]init];
sqlite3 *database;
sqlite3_stmt *complitestament;
if (sqlite3_prepare_v2(database, [strqry UTF8String], -1, &complitestament, NULL)==SQLITE_OK)
{ NSLog(@”table open”); while (sqlite3_step(complitestament)==SQLITE_ROW) {
NSMutableDictionary *dic=[[NSMutableDictionary alloc]init];
for (int i=0; i<sqlite3_column_count(complitestament); i++) {
NSString *strcolnam=[NSString stringWithUTF8String:(char*)sqlite3_column_name(complitestament, i)];
// NSLog(@”%@”,strcolnam);
NSString *strcoltxt=[NSString stringWithUTF8String:(char*)sqlite3_column_text(complitestament, i)];
// NSLog(@”%@”,strcoltxt);
[dic setObject:strcoltxt forKey:strcolnam]; }
// NSLog(@”dic :: %@”,dic);
[arr addObject:dic]; }
} }
// NSLog(@”arr :: %@”,arr); sqlite3_close(database);
return arr; }
-(void)addsqlfiledatafilepath:(NSString *)strfilepath query:(NSString *)strquery;
{
NSString *strdatapath=[NSHomeDirectory() stringByAppendingPathComponent:strfilepath];
if (sqlite3_open([strdatapath UTF8String], &database)==SQLITE_OK) {
sqlite3 *database;
//
NSLog(@”database open”); insert into table_name values (‘Mark’,’Za’,’MBA’,’ld’,’9676283432′)
NSString *strqry=strquery;
sqlite3_stmt *complitestament;
if (sqlite3_prepare_v2(database, [strqry UTF8String], -1, &complitestament, NULL)==SQLITE_OK)
{ NSLog(@”table open”); if (sqlite3_step(complitestament)==SQLITE_DONE) {
NSLog(@”added”); }
else
{ NSLog(@”error”);
} }
}
sqlite3_close(database); }
-(void)deletesqlfiledatafilepath:(NSString *)strfilepath query:(NSString *)strquery
{
NSString *strdatapath=[NSHomeDirectory() stringByAppendingPathComponent:strfilepath];
if (sqlite3_open([strdatapath UTF8String], &database)==SQLITE_OK) {
sqlite3 *database;
//
NSLog(@”database open”); DELETE FROM table_name WHERE fname=’kaushik’
NSString *strqry=strquery;
sqlite3_stmt *complitestament;
if (sqlite3_prepare_v2(database, [strqry UTF8String], -1, &complitestament, NULL)==SQLITE_OK)
{ NSLog(@”table open”);
if (sqlite3_step(complitestament)==SQLITE_DONE) { NSLog(@”deleted”);
} else{
NSLog(@”error”); }
} }
sqlite3_close(database); }
-(void)updatesavesqlfiledatafilepath:(NSString *)strfilepath query:(NSString *)strquery
{
NSString *strdatapath=[NSHomeDirectory() stringByAppendingPathComponent:strfilepath];
if (sqlite3_open([strdatapath UTF8String], &database)==SQLITE_OK) {
NSLog(@”database open”);
// UPDATE form_table set fname=’info’, lname=’soft’ ,standard=’pvt.ltd.’ WHERE fname=’kaushik’
NSString *strqry=strquery; sqlite3_stmt *complitestament;
sqlite3 *database;
if (sqlite3_prepare_v2(database, [strqry UTF8String], -1, &complitestament, NULL)==SQLITE_OK)
{ NSLog(@”table open”);
if (sqlite3_step(complitestament)==SQLITE_DONE) { NSLog(@”updated”);
} else {
NSLog(@”error”); }
} }
sqlite3_close(database); }
-(NSMutableArray *)updateshowsqlfiledatafilepath:(NSString *)strfilepath query:(NSString *)strquery
{ NSMutableArray *arr=[[NSMutableArray alloc]init]; sqlite3 *database;
NSString *strdatapath=[NSHomeDirectory() stringByAppendingPathComponent:strfilepath];
if (sqlite3_open([strdatapath UTF8String], &database)==SQLITE_OK) {
NSLog(@”database open”); // select *from table_name where fname=’kaushik’
NSString *strqry=strquery;
sqlite3_stmt *complitestament;
if (sqlite3_prepare_v2(database, [strqry UTF8String], -1, &complitestament, NULL)==SQLITE_OK)
{ NSLog(@”table open”); while (sqlite3_step(complitestament)==SQLITE_ROW) {
NSMutableDictionary *dic=[[NSMutableDictionary alloc]init]; for (int i=0; i<sqlite3_column_count(complitestament); i++) {
NSString *strcolnam=[NSString stringWithUTF8String:(char*)sqlite3_column_name(complitestament, i)];
// NSLog(@”%@”,strcolnam);
NSString *strcoltxt=[NSString stringWithUTF8String:(char*)sqlite3_column_text(complitestament, i)];
// NSLog(@”%@”,strcoltxt);
[dic setObject:strcoltxt forKey:strcolnam]; }
// NSLog(@”dic :: %@”,dic); [arr addObject:dic];
} }
} // NSLog(@”arr :: %@”,arr); sqlite3_close(database);
return arr; }
Sqlite connection file .h
#import <Foundation/Foundation.h>
#import <sqlite3.h>
@interface sqliteconnecton : NSObject
{
NSMutableArray *data;
}
-(NSMutableArray *)selectrecord:(NSString *)dbpath SelectQuery:(NSString *)query ;
-(NSString *)IUDrecord:(NSString *)dbpath SelectQuery:(NSString *)query ;
@end
.m file
#import “sqliteconnecton.h”
#import <sqlite3.h>
@implementation sqliteconnecton
-(NSMutableArray *)selectrecord:(NSString *)dbpath SelectQuery:(NSString *)query{
data = [[NSMutableArray alloc]init];
sqlite3 *db;
int i;
if (sqlite3_open([dbpath UTF8String], &db)==SQLITE_OK)
{
NSString *strqury = query;
NSMutableDictionary *dict1;
sqlite3_stmt *statementss;
if (sqlite3_prepare_v2(db, [strqury UTF8String], -1, &statementss, nil)==SQLITE_OK)
{
while (sqlite3_step(statementss)==SQLITE_ROW)
{
dict1 =[[NSMutableDictionary alloc]init];
for (i=0; i<sqlite3_column_count(statementss); i++)
{
NSString *strcolumnname = [NSStringstringWithUTF8String:sqlite3_column_name(statementss, i)];
NSString *strcolumndata = [NSStringstringWithUTF8String:(char*)sqlite3_column_text(statementss, i)];
[dict1 setObject:strcolumndataforKey:strcolumnname];
}
[data addObject:dict1];
}
}
sqlite3_close(db);
}
return data;
}
-(NSString *)IUDrecord:(NSString *)dbpath SelectQuery:(NSString *)query{
sqlite3 *d1;
NSString *message;
if (sqlite3_open([dbpath UTF8String], &d1) ==SQLITE_OK)
{
NSLog(@”Database Open”);
sqlite3_stmt *completedStatement;
if (sqlite3_prepare_v2(d1, [query UTF8String], -1, &completedStatement, NULL) == SQLITE_OK)
{
if (sqlite3_step(completedStatement) ==SQLITE_DONE)
{
message = @”Success”;
sqlite3_close(d1);
}
else
{
message = @”error”;
}
}
else {
message =@”error”;
}
}
return message;
}
@end
appdelegate:
-(void) addFile
{
NSString *strpath = [@”~/Documents/Databese.sqlite”stringByExpandingTildeInPath];
NSLog(@”%@”,strpath);
NSError *err;
if (![[NSFileManager defaultManager]fileExistsAtPath:strpath])
{
NSString *str = [[NSBundlemainBundle]pathForResource:@”Databese”ofType:@”sqlite”];
[[NSFileManagerdefaultManager]copyItemAtPath:str toPath:strpatherror:&err];
}
else
{
NSLog(@”Already Exist…….”);
}
}
in h and m file
first create sqlite object and init then
NSString * dbpath = [NSHomeDirectory()stringByAppendingPathComponent:@”Documents/Databese.sqlite”];
NSString *strQuery=[NSStringstringWithFormat:@”insert into USER_REGISTRATION (FirstName,LastName, EmailId, Password,ConformPassword,Gender,DateOfBirth) values(‘%@’,’%@’, ‘%@’,’%@’,’%@’,’%@’,’%@’)”,txtfname.text,txtlname.text,txtemailid.text,txtpassword.text,txtconforpassword.text,txtgender.text,txtdate.text];
NSString * insert =[con IUDrecord:dbpathSelectQuery:strQuery];
NSLog(@”%@”,insert);
if ([txtpassword.text isEqual:txtconforpassword.text]) {
loginpage * login =[self.storyboardinstantiateViewControllerWithIdentifier:@”loginpage”];
[self.navigationControllerpushViewController:login animated:YES];