点菜系统程序副本.doc

5.1 数据库的实现 核心代码如下： //数据库的创建 static FMDatabase *db = nil; //创建沙河路径 + (NSString *)creatPath { return [NSHomeDirectory() stringByAppendingPathComponent:@/Documents/menuDataBase.sqlite]; } //创建数据库 + (FMDatabase *)creatDataBase { NSLog(@%@,[self creatPath]); return db = [[FMDatabase alloc]initWithPath:[self creatPath]]; } //创建表 + (void)creatTable { if (!db) { [self creatDataBase]; } if (![db open]) { NSAssert(NO, @此数据库打不开); } [db setShouldCacheStatements:YES]; if (![db tableExists:@groupTable]) { [db executeUpdate:@create table groupTable(group_id integer primary key,kind text,name text,picName text,highPicName text)]; } if (![db tableExists:@menuTable]) { [db executeUpdate:@create table menuTable(menu_id integer primary key,groupID integer,iKind text,name text,price integer,unit text,detail text,picName text)]; } if (![db tableExists:@myMenuTable]) { [db executeUpdate:@create table myMenuTable(myMenu_id integer primary key,myMenuName text,myMenuPrice integer,myMenuKind text,myMenuDealNum text)]; } if (![db tableExists:@historyMenuTable]) { [db executeUpdate:@create table historyMenuTable(historyMenu_id integer primary key,date text,hour text,roomNum text)]; } if (![db tableExists:@markMenuTable]) { [db executeUpdate:@create table markMenuTable(markMenu_id integer primary key,date text,hour text,roomNum text,myMenuName text,myMenuPrice integer,myMenuKind text,myMenuDealNum text)]; } [db close]; } //保存数据 + (void)saveWithGroup:(Group *)group { if (!db) { [self creatDataBase]; } if (![db open]) { NSAssert(NO, @此数据库打不开); } [db setShouldCacheStatements:YES]; if (![db tableExists:@groupTable]) { [self creatTable]; } FMResultSet *result = [db executeQuery:@select * from groupTable where kind = ?,group.kind]; if ([result next])