是否创建数据库判断以及建表

来源：互联网发布：淘宝小二工资多少编辑：程序博客网时间：2024/05/02 11:43

    NSUserDefaults *defaults3 =[NSUserDefaults standardUserDefaults];    NSString *companyUser = [NSString stringWithFormat:@"fire.sqlite3"];    [defaults3 setObject:companyUser forKey:@"CurrentDataBaseName"];    mydatabase *xguanjia = [[mydatabase alloc] initWithName:@"xguanjia.sqlite3"];    NSString *DBisExist =[NSString stringWithFormat:@"select Sqlite_Name from Company_User where Sqlite_Name = '%@'",companyUser];    NSArray *sqliteNames = [xguanjia qurrayTable: DBisExist];    //为各用户创建他们的数据库及表    if ([sqliteNames count] == 0 || sqliteNames == nil) {        NSString *companyUser = [NSString stringWithFormat:@"fire.sqlite3"];        mydatabase *newUser = [[mydatabase alloc] initWithName:companyUser];        mydatabase *xguanjia = [[mydatabase alloc] initWithName:@"xguanjia.sqlite3"];        [xguanjia updateTable:[NSString stringWithFormat:@"INSERT INTO Company_User (Sqlite_Name) values('%@')",companyUser]];        [newUser createTable:@"CREATE TABLE IF NOT EXISTS LocalContacts(AnnounceRecordId INTEGER PRIMARY KEY autoincrement,name    TEXT,sex    TEXT,age    TEXT,telphone    TEXT);"];    }

0 0