.m
****-------------------find database file----------------****
-(void) createdatabase{
NSString *dataname=@"insert_use.sqlite";
NSArray *docpath=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *docdri = [docpath objectAtIndex:0];
NSSrting *datapath=[docdri stringByAppendingPathComponent:dataname];
BOOL ttt;
NSFileManager *fmanager=[NSFileManager defaultManager];
ttt=[fmanager fileExistsAtPath:datapath];
if (ttt)return;
NSString *databasepathfromapp = [[[NSBundle mainBundle]resourcePath]stringByAppendingPathComponent:dataname];
[fmanager copyItemAtPath:databasepathfromapp toPath:datapath error:nil];
}
*****-------------------InsertData--------------*****
{
[self createdatabase];
sqlite3 *dataname1;
NSString *str1 = txt1.text;
NSString *str2 = txt2.text;
if (sqlite3_open([datapath UTF8String], &dataname1)==SQLITE_OK)
{
sqlite3_stmt *stmt1;
NSString *query;
query= [NSString stringWithFormat:@"insert into login_data(name, password)values(\"%@\",\"%@\")",str1,str2];
const char *compile = [query UTF8String];
sqlite3_prepare_v2(dataname1, compile, -1, &stmt1, NULL);
if (sqlite3_step(stmt1) == SQLITE_DONE)
{
NSLog(@"insert data");
} else {
NSLog(@"Not insert data");
}
sqlite3_reset(stmt1);
}
}
*****----------------------ReadDataFromDatabase-----------------*****
{
[self createdatabase];
sqlite3 *dataname1;
ar =[[NSMutableArray alloc]init];
ar1=[[NSMutableArray alloc]init];
if (sqlite3_open([datapath UTF8String], &dataname1) == SQLITE_OK)
{
const char *sqlstatment = "select * from login_data";
sqlite3_stmt *compilestatment;
if (sqlite3_prepare_v2(dataname1, sqlstatment, -1, &compilestatment, NULL)==SQLITE_OK) {
while (sqlite3_step(compilestatment)==SQLITE_ROW) {
NSString *name =[NSString stringWithUTF8String:(char *)sqlite3_column_text(compilestatment, 0)];
[ar addObject:name];
NSString *str = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compilestatment, 1)];
[ar1 addObject:str];
}
}
}
}
*****-------------------CheckLoginFromDatabase---------------*****
{ [self createdatabase];
sqlite3 *dataname1;
if (sqlite3_open([datapath UTF8String], &dataname1) == SQLITE_OK)
{
NSString *query;
query= [NSString stringWithFormat:@"select name password from login_data where name= \"%@\" and password= \"%@\"",[txt1 text],[txt2 text]];
NSLog(@"%@",query);
const char *sqlstatment= [query UTF8String];
sqlite3_stmt *compilestatment;
if (sqlite3_prepare_v2(dataname1, sqlstatment, -1, &compilestatment, NULL)==SQLITE_OK)
{
while (sqlite3_step(compilestatment)==SQLITE_ROW)
{
NSLog(@"log in");
}
}
}
}
*****------------------DeleteDataFromDatabase---------------------*****
{ [self createdatabase];
sqlite3 *dataname1;
if (sqlite3_open([datapath UTF8String], &dataname1) == SQLITE_OK)
{ NSString *query;
query= [NSString stringWithFormat:@"delete from login_data where name = \"%@\"",str_delete]; NSLog(@"%@",query);
const char *sqlstatment= [query UTF8String];
sqlite3_stmt *compilestatment;
if (sqlite3_prepare_v2(dataname1, sqlstatment, -1, &compilestatment, NULL)==SQLITE_OK)
{
while(sqlite3_step(compilestatment)==SQLITE_DONE)
{
NSLog(@"delete row");
} }
sqlite3_finalize(compilestatment);
sqlite3_close(dataname1);
}
}
****-------------------find database file----------------****
-(void) createdatabase{
NSString *dataname=@"insert_use.sqlite";
NSArray *docpath=NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *docdri = [docpath objectAtIndex:0];
NSSrting *datapath=[docdri stringByAppendingPathComponent:dataname];
BOOL ttt;
NSFileManager *fmanager=[NSFileManager defaultManager];
ttt=[fmanager fileExistsAtPath:datapath];
if (ttt)return;
NSString *databasepathfromapp = [[[NSBundle mainBundle]resourcePath]stringByAppendingPathComponent:dataname];
[fmanager copyItemAtPath:databasepathfromapp toPath:datapath error:nil];
}
*****-------------------InsertData--------------*****
{
[self createdatabase];
sqlite3 *dataname1;
NSString *str1 = txt1.text;
NSString *str2 = txt2.text;
if (sqlite3_open([datapath UTF8String], &dataname1)==SQLITE_OK)
{
sqlite3_stmt *stmt1;
NSString *query;
query= [NSString stringWithFormat:@"insert into login_data(name, password)values(\"%@\",\"%@\")",str1,str2];
const char *compile = [query UTF8String];
sqlite3_prepare_v2(dataname1, compile, -1, &stmt1, NULL);
if (sqlite3_step(stmt1) == SQLITE_DONE)
{
NSLog(@"insert data");
} else {
NSLog(@"Not insert data");
}
sqlite3_reset(stmt1);
}
}
*****----------------------ReadDataFromDatabase-----------------*****
{
[self createdatabase];
sqlite3 *dataname1;
ar =[[NSMutableArray alloc]init];
ar1=[[NSMutableArray alloc]init];
if (sqlite3_open([datapath UTF8String], &dataname1) == SQLITE_OK)
{
const char *sqlstatment = "select * from login_data";
sqlite3_stmt *compilestatment;
if (sqlite3_prepare_v2(dataname1, sqlstatment, -1, &compilestatment, NULL)==SQLITE_OK) {
while (sqlite3_step(compilestatment)==SQLITE_ROW) {
NSString *name =[NSString stringWithUTF8String:(char *)sqlite3_column_text(compilestatment, 0)];
[ar addObject:name];
NSString *str = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compilestatment, 1)];
[ar1 addObject:str];
}
}
}
}
*****-------------------CheckLoginFromDatabase---------------*****
{ [self createdatabase];
sqlite3 *dataname1;
if (sqlite3_open([datapath UTF8String], &dataname1) == SQLITE_OK)
{
NSString *query;
query= [NSString stringWithFormat:@"select name password from login_data where name= \"%@\" and password= \"%@\"",[txt1 text],[txt2 text]];
NSLog(@"%@",query);
const char *sqlstatment= [query UTF8String];
sqlite3_stmt *compilestatment;
if (sqlite3_prepare_v2(dataname1, sqlstatment, -1, &compilestatment, NULL)==SQLITE_OK)
{
while (sqlite3_step(compilestatment)==SQLITE_ROW)
{
NSLog(@"log in");
}
}
}
}
*****------------------DeleteDataFromDatabase---------------------*****
{ [self createdatabase];
sqlite3 *dataname1;
if (sqlite3_open([datapath UTF8String], &dataname1) == SQLITE_OK)
{ NSString *query;
query= [NSString stringWithFormat:@"delete from login_data where name = \"%@\"",str_delete]; NSLog(@"%@",query);
const char *sqlstatment= [query UTF8String];
sqlite3_stmt *compilestatment;
if (sqlite3_prepare_v2(dataname1, sqlstatment, -1, &compilestatment, NULL)==SQLITE_OK)
{
while(sqlite3_step(compilestatment)==SQLITE_DONE)
{
NSLog(@"delete row");
} }
sqlite3_finalize(compilestatment);
sqlite3_close(dataname1);
}
}