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);"];
}
是否创建数据库判断以及建表
最新推荐文章于 2021-04-06 13:55:45 发布