NSUserDefaults *defaults3 =[NSUserDefaults standardUserDefaults];
NSString *companyUser = [NSString stringWithFormat:@"fire.sqlite3"];
[defaults3 setObject:companyUser forKey:@"CurrentDataBaseName"];
zc *xguanjia = [[zc alloc] initWithDbName:@"xguanjia.sqlite3"];
NSString *DBisExist =[NSString stringWithFormat:@"select Sqlite_Name from Company_User where Sqlite_Name = '%@'",companyUser];
NSArray *sqliteNames = [xguanjia querryTable:DBisExist];
//为各用户创建他们的数据库及表
if ([sqliteNames count] == 0 || sqliteNames == nil) {
NSString *companyUser = [NSString stringWithFormat:@"fire.sqlite3"];
zc *newUser = [[zc alloc] initWithDbName:companyUser];
zc *xguanjia = [[zc alloc] initWithDbName:@"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);"];
}
appdelegate 数据库
最新推荐文章于 2022-09-20 11:14:58 发布